PDA

View Full Version : phpMyAdmin version 2.11.0 package available for ISPConfig


Hans
8th September 2007, 17:49
Today i've made a new phpMyAdmin package for ISPConfig.
It is based on the latest stable version phpMyAdmin 2.11.0.

It can be downloaded here:
http://www.ispconfig.org/downloads/phpmyadmin-2.11.0.pkg

NOTE:
Remove the old phpMyAdmin version first before you install this new package on your ISPConfig server!
You can do this with the folowing commands:
rm -r /home/admispconfig/ispconfig/web/phpmyadmin
rm /home/admispconfig/ispconfig/web/phpmyadmin.tar.gz
rm -r /home/admispconfig/ispconfig/web/tools/tools/phpmyadmin


After that the new phpMyAdmin package can be installed with the update manager within ISPConfig.

Have fun! :)

madmucho
9th September 2007, 18:08
Any idea how to completely hide default databases for clients when phpmyadmin is used? They have acces to default databases test and information_schema i dont thing this is secure..

Hans
9th September 2007, 19:32
If, for example you don't want to show the database "information_schema" within the database list, do the following:

Change the line no.87 within /home/admispconfig/ispconfig/web/phpmyadmin/config.inc.php from:

$cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings

into:

$cfg['Servers'][$i]['hide_db'] = 'information_schema'; // Database name to be hidden from listings

Of course you can create an array with database names if you don't want to show them within the database list. This means that you can add an extra line for the database 'test' in the same way as well.

madmucho
9th September 2007, 20:40
Thanks for fast reply. Simply works :)

$cfg['Servers'][$i]['hide_db'] = '(test|information_schema)';

Menzor
13th September 2007, 20:03
Let me start off with what i started out trying to do. I am trying to enter stored procedures into PHPMyAdmin.

I am running ISPConfig 2.2.13

I am not sure what version of PHPMyAdmin I was running, but it definitely was working.

I realized that the version of PHPMyAdmin that i had did not support stored procedures.

So i checked the http://www.ispconfig.org/downloads.htm and seen the new version of PHPMyAdmin 2.11.0.

I downloaded phpmyadmin-2.11.0.pkg witch is 4.247 MB in size.

I went into ISPConfig update tool and clicked update, I received the install successful, and then clicked on the PHPMyadmin Link on the tools menu. I knew then i did something wrong. When the window opened, instead of getting the normal PHPMyAdmin Window....all i got was a spinning indicator that the page was trying to load, no error, no indication of anything....just a blank page.

I then looked through the forums and found this thread, and realized i should have done

rm -r /home/admispconfig/ispconfig/web/phpmyadmin
rm /home/admispconfig/ispconfig/web/phpmyadmin.tar.gz
rm -r /home/admispconfig/ispconfig/web/tools/tools/phpmyadmin

I then ran these commands and was asked if i wanted to descend into each directory, after entering y a number of times, i realized that i needed to remove the files under the directory so I used an FTP program and removed the directories and files under the three folders, and the folders them selves.

I then reinstalled the PHPMyAdmin 2.11.0. using the update file upload tool in ISPConfig.

After clicking the PHPMyAdmin Link under the tools menu, I then received the same spinning browser icon and a blank page.

That is all i get when clicking the PHPMyAdmin tool icon in ISPConfig.....

Any idea how i can correct this? Or install the previous PHPMyadmin package that worked? I can not seem to find the download for the old package.

Any Help is greatly appreciated.

Menzor
13th September 2007, 22:24
Even tried
/phpmyadmin/scripts/setup.php

same thing.....blank page

Telesat
14th September 2007, 01:11
I've installed it as explained here and I'm having the very same issue in Firefox: first time it was fine but after that I'm getting the neverending sipinning logo and a blank grey page.

But I've tried with konqueror and it opens fine. So I guess it has to do with the browser's cache or something like that.

I think you did it right by removing the files and re-installing phpmyadmin. Just try with another browser and tell us how is it goin.

Hans
14th September 2007, 10:49
Let me start off with what i started out trying to do. I am trying to enter stored procedures into PHPMyAdmin.

I am running ISPConfig 2.2.13

I am not sure what version of PHPMyAdmin I was running, but it definitely was working.

I realized that the version of PHPMyAdmin that i had did not support stored procedures.

So i checked the http://www.ispconfig.org/downloads.htm and seen the new version of PHPMyAdmin 2.11.0.

I downloaded phpmyadmin-2.11.0.pkg witch is 4.247 MB in size.

I went into ISPConfig update tool and clicked update, I received the install successful, and then clicked on the PHPMyadmin Link on the tools menu. I knew then i did something wrong. When the window opened, instead of getting the normal PHPMyAdmin Window....all i got was a spinning indicator that the page was trying to load, no error, no indication of anything....just a blank page.

I then looked through the forums and found this thread, and realized i should have done

rm -r /home/admispconfig/ispconfig/web/phpmyadmin
rm /home/admispconfig/ispconfig/web/phpmyadmin.tar.gz
rm -r /home/admispconfig/ispconfig/web/tools/tools/phpmyadmin

I then ran these commands and was asked if i wanted to descend into each directory, after entering y a number of times, i realized that i needed to remove the files under the directory so I used an FTP program and removed the directories and files under the three folders, and the folders them selves.

I then reinstalled the PHPMyAdmin 2.11.0. using the update file upload tool in ISPConfig.

After clicking the PHPMyAdmin Link under the tools menu, I then received the same spinning browser icon and a blank page.

That is all i get when clicking the PHPMyAdmin tool icon in ISPConfig.....

Any idea how i can correct this? Or install the previous PHPMyadmin package that worked? I can not seem to find the download for the old package.

Any Help is greatly appreciated.


Before you perform an update with the update manager within ISPConfig, you MUST first take those steps (logged in as root):

rm -r /home/admispconfig/ispconfig/web/phpmyadmin
rm /home/admispconfig/ispconfig/web/phpmyadmin.tar.gz
rm -r /home/admispconfig/ispconfig/web/tools/tools/phpmyadmin

(With those commands, the current phpMyAdmin package on your server will be removed completely).


AFTER THAT, you can use the update manager NOT before, otherwise you will mix up the previous phpMyAdmin version with the new one.

Before i published the new phpMyAdmin 2.11.0 package, i tested it thoroughly. I am sure that the package has been build perfectly.

If you still got problems after a right install procedure, the previous package is still available here: http://www.ispconfig.bb-hosting.org/downloads/phpmyadmin/phpmyadmin-2.10.1.pkg.

But i am sure a step back to the previous version is not a solution, the new phpMyAdmin 2.11.0 package should work!

Menzor
17th September 2007, 17:05
I know have, everything working.

The final thing i did was to change permissions on the php files and it phpMyAdmin worked.