New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable Support for phpMyAdmin #117

Closed
collizo4sky opened this Issue Jun 26, 2016 · 23 comments

Comments

Projects
None yet
4 participants
@collizo4sky

collizo4sky commented Jun 26, 2016

I installed phpmyadmin at www folder. Accessing wplib.box/phpmyadmin resulted in

The wplib.box page isn’t working

wplib.box is currently unable to handle this request.
@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky commented Jun 26, 2016

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 26, 2016

Member

@collizo4sky Will Adminer work for you instead? Have you considered downloading Sequel Pro?

We can get PhpMyAdmin working but both of those are better options...

Member

mikeschinkel commented Jun 26, 2016

@collizo4sky Will Adminer work for you instead? Have you considered downloading Sequel Pro?

We can get PhpMyAdmin working but both of those are better options...

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jun 26, 2016

Am used to phpmyadmin.

Already downloaded and using sequel pro but i still desire phpmyadmin

collizo4sky commented Jun 26, 2016

Am used to phpmyadmin.

Already downloaded and using sequel pro but i still desire phpmyadmin

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 26, 2016

Member

I will install PhpMyAdmin later today and see if I run into the same issue.

Member

mikeschinkel commented Jun 26, 2016

I will install PhpMyAdmin later today and see if I run into the same issue.

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 27, 2016

Member

@collizo4sky I just tried to install PhpMyAdmin and ran into a whole bunch of different issues, some of which I am concerned would cause the rest of the box to be unstable so I decided to stop.

Note I was trying to install on top of our existing box image in order to provide a tutorial for how to install it, I was not working with the box image itself, which I do not work on (@clubdeuce does.)

How difficult for you it is to learn a new (and IMO a better) tool in Sequel Pro? Is sticking with PhpMyAdmin really that important? What features does it have the Sequel Pro cannot offer?

However I will talk with @clubdeuce and see what the options we might have to make it work. Unfortunately given client projects we may not be able to discuss immediately.

Member

mikeschinkel commented Jun 27, 2016

@collizo4sky I just tried to install PhpMyAdmin and ran into a whole bunch of different issues, some of which I am concerned would cause the rest of the box to be unstable so I decided to stop.

Note I was trying to install on top of our existing box image in order to provide a tutorial for how to install it, I was not working with the box image itself, which I do not work on (@clubdeuce does.)

How difficult for you it is to learn a new (and IMO a better) tool in Sequel Pro? Is sticking with PhpMyAdmin really that important? What features does it have the Sequel Pro cannot offer?

However I will talk with @clubdeuce and see what the options we might have to make it work. Unfortunately given client projects we may not be able to discuss immediately.

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jun 27, 2016

Its alright. Take your time.

FWIW, i have temporarily switch to laravel homestead and successfully running phpMyAdmin.

collizo4sky commented Jun 27, 2016

Its alright. Take your time.

FWIW, i have temporarily switch to laravel homestead and successfully running phpMyAdmin.

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 27, 2016

Member

i have temporarily switch to laravel homestead

:-(

Member

mikeschinkel commented Jun 27, 2016

i have temporarily switch to laravel homestead

:-(

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jun 27, 2016

No way to get phpmyadmin working was a bummer for me.

Call me old school. I have grown accustom to it for my database management.

collizo4sky commented Jun 27, 2016

No way to get phpmyadmin working was a bummer for me.

Call me old school. I have grown accustom to it for my database management.

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 27, 2016

Member

Not saying it won't happen. We just have to discuss what it will take. It might be easy for @clubdeuce.

Member

mikeschinkel commented Jun 27, 2016

Not saying it won't happen. We just have to discuss what it will take. It might be easy for @clubdeuce.

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jun 27, 2016

I could get it to work by creating a new project for it. But that would mean only getting it working with my wordpress dev box inactive.

Unlike
homestead, you can only create one site per box instance/project. This was the limiting factor.

collizo4sky commented Jun 27, 2016

I could get it to work by creating a new project for it. But that would mean only getting it working with my wordpress dev box inactive.

Unlike
homestead, you can only create one site per box instance/project. This was the limiting factor.

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 27, 2016

Member

I could get it to work by creating a new project for it. Nut that would mean only getting it working with my wordpress dev box inactive.

I do not understand what you mean here.

You can only create one site per box instance/project.

You can create as many projects as you want with WPLib Box. Currently that means updating the nginx conf files yourself though but we plan to change that with our API and then our admin console.

And it also means adding alias hostnames in the Vagrantfile like this:

 config.hostsupdater.aliases = ["phpmyadmin.wplib.box"]`
Member

mikeschinkel commented Jun 27, 2016

I could get it to work by creating a new project for it. Nut that would mean only getting it working with my wordpress dev box inactive.

I do not understand what you mean here.

You can only create one site per box instance/project.

You can create as many projects as you want with WPLib Box. Currently that means updating the nginx conf files yourself though but we plan to change that with our API and then our admin console.

And it also means adding alias hostnames in the Vagrantfile like this:

 config.hostsupdater.aliases = ["phpmyadmin.wplib.box"]`
@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jun 27, 2016

I could get it to work by creating a new project for it. But that would mean only getting it working with my wordpress dev box inactive.
I do not understand what you mean here.

My point was, i could get it to work if i make phpmyadmin a project on it own to have a url like phpmyadmin.box

collizo4sky commented Jun 27, 2016

I could get it to work by creating a new project for it. But that would mean only getting it working with my wordpress dev box inactive.
I do not understand what you mean here.

My point was, i could get it to work if i make phpmyadmin a project on it own to have a url like phpmyadmin.box

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 27, 2016

Member

My point was, i could get it to work if i make phpmyadmin a project on it own to have a url like phpmyadmin.box

That is one way. But you can add more hostnames to WPLib if you want.

But let's table this until we see if we can add to the box, or provide an installer for the box.

Member

mikeschinkel commented Jun 27, 2016

My point was, i could get it to work if i make phpmyadmin a project on it own to have a url like phpmyadmin.box

That is one way. But you can add more hostnames to WPLib if you want.

But let's table this until we see if we can add to the box, or provide an installer for the box.

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jun 28, 2016

Member

@clubdeuce #122 is what ( in part?) was need to get PhpMyAdmin working.

Member

mikeschinkel commented Jun 28, 2016

@clubdeuce #122 is what ( in part?) was need to get PhpMyAdmin working.

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jul 1, 2016

From the FAQ, apparently adminer (a phpmyadmin alternative) has been added to the box. Any love for phpmyadmin anytime soon?

collizo4sky commented Jul 1, 2016

From the FAQ, apparently adminer (a phpmyadmin alternative) has been added to the box. Any love for phpmyadmin anytime soon?

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jul 1, 2016

Member

@collizo4sky We actually discussed adding Adminer about 3 weeks ago and added it 16 days ago. But we just now got it documented.

@clubdeuce and I have periodic calls to discuss what to include in the next release -- about every 2-3 weeks if the past few months are predictive -- and we had met just before you submitted this ticket to set the objectives for the next release. So it may be a bit longer before we will meet to discuss adding this.

BTW, the goal for the next release is to get a functioning API working in the box, which is a decent size project in itself.

One thing I have been thinking about is to come up with a way to support some sort of "optional packages" that we or anyone can build and then easily add to the box. I am envisioning they would be added during the Vagrant "provisioning" step but in a way not likely to fail like typical box provisioning can fail. And also it would need to be very fast to install so that provisioning would not be a long drawn-out process like VVV.

If we added phpMyAdmin as our first optional package would that work for you? You'd need to specify it in your Vagrantfile or a .json file rather than having it be added to the base box image.

Member

mikeschinkel commented Jul 1, 2016

@collizo4sky We actually discussed adding Adminer about 3 weeks ago and added it 16 days ago. But we just now got it documented.

@clubdeuce and I have periodic calls to discuss what to include in the next release -- about every 2-3 weeks if the past few months are predictive -- and we had met just before you submitted this ticket to set the objectives for the next release. So it may be a bit longer before we will meet to discuss adding this.

BTW, the goal for the next release is to get a functioning API working in the box, which is a decent size project in itself.

One thing I have been thinking about is to come up with a way to support some sort of "optional packages" that we or anyone can build and then easily add to the box. I am envisioning they would be added during the Vagrant "provisioning" step but in a way not likely to fail like typical box provisioning can fail. And also it would need to be very fast to install so that provisioning would not be a long drawn-out process like VVV.

If we added phpMyAdmin as our first optional package would that work for you? You'd need to specify it in your Vagrantfile or a .json file rather than having it be added to the base box image.

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jul 1, 2016

That should work. I am sure thee are also a number of folks that prefer
phpMyAdmin.

On Fri, Jul 1, 2016 at 7:17 AM, Mike Schinkel notifications@github.com
wrote:

@collizo4sky https://github.com/collizo4sky We actually discussed
adding Adminer about 3 weeks ago and added it 16 days ago. But we just now
got it documented.

@clubdeuce https://github.com/clubdeuce and I have periodic calls to
discuss what to include in the next release -- about every 2-3 weeks if the
past few months are predictive -- and we had met just before you submitted
this ticket to set the objectives for the next release. So it may be a bit
longer before we will meet to discuss adding this.

BTW, the goal for the next release is to get a functioning API working in
the box, which is a decent size project in itself.

One thing I have been thinking about is to come up with a way to support
some sort of "optional packages" that we or anyone can build and then
easily add to the box. I am envisioning they would be added during the
Vagrant "provisioning" step but in a way not likely to fail like
typical box provisioning can fail. And also it would need to be very fast
to install so that provisioning would not be a long drawn-out process like
VVV.

If we added phpMyAdmin as our first "optional package" would that work
for you? You'd need to specify it in your Vagrantfile or a .json file
rather than having it be added to the base box image.


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#117 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AD8uc_qpTz9PobRVjaVw4zbUBwkXPy6Xks5qRLEOgaJpZM4I-jVQ
.

collizo4sky commented Jul 1, 2016

That should work. I am sure thee are also a number of folks that prefer
phpMyAdmin.

On Fri, Jul 1, 2016 at 7:17 AM, Mike Schinkel notifications@github.com
wrote:

@collizo4sky https://github.com/collizo4sky We actually discussed
adding Adminer about 3 weeks ago and added it 16 days ago. But we just now
got it documented.

@clubdeuce https://github.com/clubdeuce and I have periodic calls to
discuss what to include in the next release -- about every 2-3 weeks if the
past few months are predictive -- and we had met just before you submitted
this ticket to set the objectives for the next release. So it may be a bit
longer before we will meet to discuss adding this.

BTW, the goal for the next release is to get a functioning API working in
the box, which is a decent size project in itself.

One thing I have been thinking about is to come up with a way to support
some sort of "optional packages" that we or anyone can build and then
easily add to the box. I am envisioning they would be added during the
Vagrant "provisioning" step but in a way not likely to fail like
typical box provisioning can fail. And also it would need to be very fast
to install so that provisioning would not be a long drawn-out process like
VVV.

If we added phpMyAdmin as our first "optional package" would that work
for you? You'd need to specify it in your Vagrantfile or a .json file
rather than having it be added to the base box image.


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#117 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AD8uc_qpTz9PobRVjaVw4zbUBwkXPy6Xks5qRLEOgaJpZM4I-jVQ
.

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Jul 2, 2016

Member

@collizo4sky We got it working.

Be sure to download the latest box image first from your host computer's command line:

box vagrant update

Then:

vagrant ssh
sudo apt-get install php5.6-mcrypt
sudo apt-get install php-gettext

# After running the next line follow the instructions "Installing phpMyAdmin" below
sudo apt-get install phpmyadmin 

sudo service php5.6-fpm restart
ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

After the above phpMyAdmin should be installed in your WPLib Box.

Loading phpMyAdmin in your Browser
You should be able to load phpMyAdmin in your browser at:

You can then use wordpress and wordpress for username and password, respectively.

If you have changed the hostname of the box, use your new hostname instead of wplib.box.

PHP 7.0
To also get it working for PHP 7.0 add these commands:

sudo apt-get install php7.0-mcrypt
sudo service php7.0-fpm restart

Installing phpMyAdmin

  1. After running sudo apt-get install phpmyadmin it will run a bit and then display a dialog where it asks you to select Apache or LightHTTP. Just press <tab> to select <Ok> and press enter.
  2. Since Apache is not installed you will have to wait for it to time out.
  3. Next you will get a dialog with the heading _"Configuring phpmyadmin"; press enter on with <Yes> selected.
  4. Finally will be a dialog asking for the root database password. Since there is not root password just press <tab> then press enter to select <Ok>.
  5. That's it.

Let me know if you have

Member

mikeschinkel commented Jul 2, 2016

@collizo4sky We got it working.

Be sure to download the latest box image first from your host computer's command line:

box vagrant update

Then:

vagrant ssh
sudo apt-get install php5.6-mcrypt
sudo apt-get install php-gettext

# After running the next line follow the instructions "Installing phpMyAdmin" below
sudo apt-get install phpmyadmin 

sudo service php5.6-fpm restart
ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

After the above phpMyAdmin should be installed in your WPLib Box.

Loading phpMyAdmin in your Browser
You should be able to load phpMyAdmin in your browser at:

You can then use wordpress and wordpress for username and password, respectively.

If you have changed the hostname of the box, use your new hostname instead of wplib.box.

PHP 7.0
To also get it working for PHP 7.0 add these commands:

sudo apt-get install php7.0-mcrypt
sudo service php7.0-fpm restart

Installing phpMyAdmin

  1. After running sudo apt-get install phpmyadmin it will run a bit and then display a dialog where it asks you to select Apache or LightHTTP. Just press <tab> to select <Ok> and press enter.
  2. Since Apache is not installed you will have to wait for it to time out.
  3. Next you will get a dialog with the heading _"Configuring phpmyadmin"; press enter on with <Yes> selected.
  4. Finally will be a dialog asking for the root database password. Since there is not root password just press <tab> then press enter to select <Ok>.
  5. That's it.

Let me know if you have

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jul 2, 2016

Will give it a spin by Monday and met you know how it shake out.

Thanks for all the hard work.

collizo4sky commented Jul 2, 2016

Will give it a spin by Monday and met you know how it shake out.

Thanks for all the hard work.

@clubdeuce

This comment has been minimized.

Show comment
Hide comment
@clubdeuce

clubdeuce Jul 12, 2016

Contributor

@collizo4sky Were you able to get phpMyAdmin working?

Contributor

clubdeuce commented Jul 12, 2016

@collizo4sky Were you able to get phpMyAdmin working?

@collizo4sky

This comment has been minimized.

Show comment
Hide comment
@collizo4sky

collizo4sky Jul 12, 2016

Haven't have the time yet. School has resumed and it's been pretty hectic.
I'll see how this weekend shakes out if there will be free time.

On another note, been pretty impressed with Laravel Homestead, spinning up
a site is as easy as editing a Homestead.yaml file.

On Tue, Jul 12, 2016 at 4:46 PM, Daryl Lozupone notifications@github.com
wrote:

@collizo4sky https://github.com/collizo4sky Were you able to get
phpMyAdmin working?


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#117 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AD8uczL6zsJlEPfDhx2V8TwetUegsXdQks5qU7bfgaJpZM4I-jVQ
.

collizo4sky commented Jul 12, 2016

Haven't have the time yet. School has resumed and it's been pretty hectic.
I'll see how this weekend shakes out if there will be free time.

On another note, been pretty impressed with Laravel Homestead, spinning up
a site is as easy as editing a Homestead.yaml file.

On Tue, Jul 12, 2016 at 4:46 PM, Daryl Lozupone notifications@github.com
wrote:

@collizo4sky https://github.com/collizo4sky Were you able to get
phpMyAdmin working?


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#117 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AD8uczL6zsJlEPfDhx2V8TwetUegsXdQks5qU7bfgaJpZM4I-jVQ
.

@mikeschinkel mikeschinkel changed the title from No luck getting phpmyadmin to work to Enable Support for phpMyAdmin Jul 13, 2016

@clubdeuce clubdeuce added this to the 0.17.0 milestone May 22, 2017

@mikeschinkel

This comment has been minimized.

Show comment
Hide comment
@mikeschinkel

mikeschinkel Feb 12, 2018

Member

#295 duplicates this

Member

mikeschinkel commented Feb 12, 2018

#295 duplicates this

@MickMake

This comment has been minimized.

Show comment
Hide comment
@MickMake

MickMake Jul 2, 2018

Contributor

#295 is closed.

Contributor

MickMake commented Jul 2, 2018

#295 is closed.

@MickMake MickMake closed this Jul 2, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment