Updated for phpMyAdmin 2.6.2

Log into your server as root via ssh



Thats it. Log in as usual. It doesnt over write anything, or remove anything. Totally Ensim Friendly.

Enjoy!

Note 1. If you ever upgrade the phpMyAdmin from ensim with their version, it will break the sym link in /var/www/html

Just recreate the sim link, or rerun this script.

Side note for IE users: It would appear, that there is a glitch with IE. Dump all history, cookies, and temp files. Reboot the computer. Then fire up IE and you should be fine. Can always convert to firefox as well. Upgrade script has been updated to allow an upgrade to phpMyAdmin-2.6.2

Very nice script, well done!

Please don't cross post though

crosspost? whats that mean

I had this message in 3 areas, cause I couldn't really say it was an add-on, nor was it a how to, and it did qualify for general conversation....

haha nice.

Hello,

Thank you for the smooth upgrade script. Very usefull, but after the upgrade I get:



Any hints on this.

Thank You.

Nuno Souto

Yea....I have the blowfish set for 128 bit.

in ssh, command prompt as root, type in:

mkpasswd -l 56

copy and paste the result into notepad or something

pico -w /var/www/html/MyAdmin/config.inc.php

find the blowfish passwd line

replace that long mess with the shorter mess you have in notepad

save, close and give it a try.

Might want to see about running up2date on your server too.

Thanks,

I tried it and it still didn't work.

I'm running the up2date now.

And will give it a try again when it's finished.

Nuno

Cool...I'm thinking the mcrypt / php is too old. Thought maybe knocking it back to 56 bit would help. Sorry.

Can always try:

mkpasswd -l 8

same procedure as above

worked great
much thanks

Thanks...

It worked with the 8.

I'll let you know if I can get it to work with the 128 or 56, after the up2date completes.

Nuno

Yea, supposedly that was fixed in php4 and up, but i still see cries for help in google....I dunno....

Your welcome.

Hi,

Well up2date just finished and all went well.

but I still wasn't able to get it to work with either 56 or 128.

I'm not sure what might cause it.. I'm using gpan's PHP 5.0.3 and mySQL 4.1

Thank You for your support.

Nuno Souto

php 5 might be the problem.

Some issues have been reported across the board with that and alot of code thats out there.

No issues with MySQL 4.1...use it myself on 4.1

Leave it at the 8. It still will function till php5 has all the kinks worked out.

Very nice skeeter1jd Thanks!

Thanks again Skeeter As always simple as type commands and hit enter ......

Thanks for the script

However, i ge the following:

Fatal error: mcrypt_decrypt(): Mcrypt initialisation failed in /var/www/html/phpMyAdmin-2.6.1/libraries/mcrypt.lib.php on line 90

Any idea's? I've tried "mkpasswd -l 8" but get: bash: mkpasswd: command not found

I'm in as root so it cant be a permission thing...

Cheers for any help...

excellent script. thanks.

It's really worth upgrading, v 2.6.1 is really great

badnbusy: What version of php...?

mkpasswd -l 8 not found?

up2date -u expect

mkpasswd -l 8

should do the trick...take it this is an older Ensim Install?

Thanks for the post skeeter1jd.

I actually cahnged it back to use http authentication (thats how i've always used it anyway).

Yes, its an old Ensim 3.5 box. Works fine with http auth.

Cheers

Cool...as long as your happy.

Thanks for this.
I did it on my RHEL box and it worked out of the box.

Correct me, but upgrading such way can block future Ensim upgrades with rpm. Isn't it?

Nope....not at all....

that was one sexy update ... thank you very much!

hehehehe.....remember if the ladies can't find you handsome, at least let them find you handy!

Another way to get ride of mcrypt() error is setting secret passphrase on line 60 in the
/var/www/html/phpMyAdmin-2.6.1/config.inc.php file.

The only folks who have had any issues, are the ones still running the older versions of ensim (3.1 - 3.7), and don't have the rpm "expect" installed, and some of the php5 users. Even they can get past it if they mkpasswd -l 8 .

I have had no other reports or any requests for a generated passwd incase someone can't install expect for what ever reason.

Weird. I have php 4.3.10, Ensim 4.0.2-7, installed expect-5.39.0 and without passphrase I got error.

Just means for what ever reason, mkpasswd never ran.

Hi Anyone,

I got the error message when I log in xxx.xxx.xxx.xxx/MyAmin


The configuration file now needs a secret passphrase (blowfish_secret).


How to fix it?


Thanks

While upgraded I found the problem :

mkpasswd : command not found

How to do??? Now can not login to php myadmin....



Thanks

Expect is required on this system. rpm -q expect to see if you have it. If you do, then type mkpasswd -l 128 and copy that mess you just got into line 60 of /var/www/html/phpMyAdmin-2.6.1/config.inc.php

If you dont have expect, or cant make a password for some reason, shoot me an I/M and I will make one for you

If you dont have an I/M client:

http://www.aim.com/get_aim/express/aim_expr.adp?aolp=

# rpm -q expect
package expect is not installed


And how to do, Now I am registering aim

log in to aim

and shoot an im to CrankyCronos

Hi again,

When I try to login to the new version : 2.6.1 from admin user/passwd it show the form, Create new database....

I dont want this ability for any clients in phpmyadmin to create new database...
( except root) ....


How to disable this form....????


Thanks

You cant disable the form.

It wont let them create any either.

Update to 2.6.1-pl2

edit your upgrade_phpMyAdmin to look like this:



Than run:

./upgrade_phpMyAdmin

It's all

bye

Updated....Thanks for letting me know.

First of all, thanks for the script.

I have modified it a bit to check for expect and for easier use when use a different version of phpmyadmin.


Use as you see fit. I take no resposibility for lost data etc.




#!/bin/bash

#
# Change FILENAME to the version you wish to install
#
FILENAME="phpMyAdmin-2.6.2-rc1.tar.gz"

DIRNAME=`echo $FILENAME | awk -F.tar '{ print $1 }'`

# Check to see if expect is install. If not exit.
EXPECT=`rpm -q expect | awk -F- '{ print $1 }'`
if [ "$EXPECT" = "expect" ]
then
echo "expect installed"
else
echo "expect not installed. Stopping program."
exit;
fi

secret_password=`mkpasswd -l 128`
cd /var/www/html
wget http://heanet.dl.sourceforge.net/sourcefor...admin/$FILENAME
tar -zxvf $FILENAME
chown -R apache:apache /var/www/html/$DIRNAME
cp /var/www/html/MyAdmin/wp.config.inc.php /var/www/html/$DIRNAME
chmod 644 /var/www/html/$DIRNAME/wp.config.inc.php
cd /var/www/html/$DIRNAME
wget http://www.customensimbackup.com/download/config.inc
mv config.inc.php config.inc.php_origianl
chown apache.apache config.inc
replace "SECRET_PASSWORD" "$secret_password" -- config.inc
mv config.inc config.inc.php
ln -s index.php indexsite.php
cd /var/www/html
rm -f MyAdmin
ln -s /var/www/html/$DIRNAME MyAdmin
rm -f $FILENAME
echo "phpMyAdmin upgrade: [COMPLETE]"



Have fun !

PKN :-)

Thanks for the suggestion. While taking a break from a couple of server updates, this is what I came up with. If you don't mind, I would like to post this as the newest release of this script.

version 2.6.2 is out. Upgrade ;-)

Improvements:

* MySQL 4.1.x native column comments
* MySQL 5.0: Basic detection mechanism for views:
o Views are no longer displayed as tables in use
o Ability to drop views
* MySQL 5.0: Interface fixes and hardcoded virtual relations for information_schema
* MySQL 4.1: Better automatic detection for available storage engines
* New storage engines overview page
o Plugin-like infrastructure for storage engine status monitors
o Overview of startup variables and current values
o MySQL 5.0 / InnoDB: Buffer pool activity monitor
* MySQL 4.1.2+ TIMESTAMP options
* Export: Native Microsoft Word 2000 and Excel 2000 formats
* PDF schema visual editor: column names now optional
* MySQL 5.0.3 new Japanese charsets support (cp932, eucjpms)
* Parser: added missing date and time MySQL functions
* Documentation: explain all Export options handling
* Cookie paths: added / to end of path
* Show database comments at more places
* Better use of print styles in themes
* Bookmarks: sort by label, remove the number before each label
* Better protection against possible collation conflicts and out-of-sync errors in PMADB queries
* Relation view: removed pmadb-style comments handling (now available just on the Structure page)
* FAQ about using HTTP authentication under IIS
* New editions for some language files (especially ISO-8859-15)
* (rc1) English messages improvements
* (final) New language: belarusian

Fixes:

* Detection of SELECT query to display on multiple submits
* PDF schema: missing header
* A failed connection was not properly detected
* Problem with Japanese language under MySQL 4.1.x
* Export
o Various errors under mysqli extension
o SQL format under Safari browser
o Do not offer export modes not available in current MySQL version
* Changing the type of a FLOAT unsigned column
* Adding field with collation
* Calendar popup and TIMESTAMP field under MySQL 4.1.x
* PHP 4.1.x: wrong parameter count (mcrypt.lib.php)
* Problem when SHOW DATABASES is disabled
* Copy table: commands out of sync
* User management
o Host not changing with editing user
o Escaping character removed by error
* MySQL 5.0.x: "No database selected" error
* Print view: displaying of indexes
* Cookie auth: error when blowfish_secret is empty
* MySQL 4.1.2: "Reload MySQL" link not seen
* MySQL 5 server binlog compatibility
* PDF pages generation: wrong documentation
* Inserted row id was not always correctly reported
* (rc1) Do not offer unavailable collations
* (rc1) XSS vulnerability on "convcharset"
* (rc1) Do not allow to drop information_schema
* (rc1) Undefined offset (on the left panel)
* (rc1) Problem copying InnoDB table with foreign-key constraints to a table in the same database
* (final) Problem editing a user's profile
* (final) Error going from Export to Insert tab

Yup, its out but the symlink is breaking the log ins. Till that bug is worked out, this will not be happening. Am looking for beta testers to see whats going on where?

Interested, contact me either PM or via IM.

Yes I have noticed the break on the logins as well, I'll let you know when I perform more tests, if I find anything about it.

Nuno Souto

It would appear, that there is a glitch with IE. Dump all history, cookies, and temp files. Reboot the computer. Then fire up IE and you should be fine. Can always convert to firefox as well. Upgrade script has been updated to allow an upgrade to phpMyAdmin-2.6.2

well, it's stated in the release info for this version

---
Note:

If you are using the 'cookie' authentication type, please delete in your browser's data the cookies which relate to phpMyAdmin, before your first use of phpMyAdmin 2.6.2. Thanks to Dmitry Chorine for the information.
---

It's odd IE should have that issue, but none of the other browsers did. Well, We figured it all out.