Admin Panel 2: phpMyBackupPro

From The Uniform Server Wiki
Revision as of 17:58, 26 June 2008 by Ric (talk | contribs) (New page: {{Uc_nav_apanel2}} '''phpMyBackupPro''' Click this link to login into '''phpMyBackup Pro''' this is a very easy to use MySQL backup application. You can create and restore backups at any ...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Admin Panel 2

phpMyBackupPro

Click this link to login into phpMyBackup Pro this is a very easy to use MySQL backup application. You can create and restore backups at any time it has the facility to schedule backups hence there is no excuse not to make a backup.

Login requires your MySQL username and password (defaults are root and root) remember to change your MySQL root password using MySQL server configuration.

The next time you login use the new password.

Security

PhpMybackupPro has what I would define an interesting little security feature, it assumes you will only ever change your MySQL root password once, well that's how it appears to me.

It is neither a design flaw or bug more a lack of a crystal ball. Let me explain, when phpMyBackupPro is set-up it requires your MySQL root password not only to access the server but also to login.

Now lets say you change your MySQL root password using phpMyAdmin and then try to login to phpMyBackupPro of course you will be rejected if using the new password. So you log in using the old password no problem however you receive this error message:

MySQL data is not correct!

This is because phpMyBackupPro is using the old password to access your MySQL server. To resolve this click on phpMyBackupPro’s configuration tab and enter the new MySQL root password click on save data. The next time you login use the new password and everything will work.

Top

Locked out

It is an excellent piece of software but does not like to be hacked around. If it detects something amiss with its configuration file, makes corrections and overwrites it. Now if for whatever reason you have done something silly it is possible to get locked out.

A classic lockout situation is password inconsistencies, OK I confess just could not remember the password I was using. Found this by using MySQL Server Configuration in apanel, made sure that phpMyAdmin could access the MySQL sever? So the server and every thing were working just locked out of phpMyBackupPro.

No problem opened the file: global_conf.php Located in folder *\Uniform Server\udrive\home\admin\www\phpMyBackupPro

Zapped down to the line $CONF['sql_passwd']="idiot"; and change the password from idiot or whatever to the new password and you will be able to access phpMyBackupPro.

Note: For security reasons the password file is located outside of your public web server’s root directory www.

The real problem

In the short term that code can be corrected, however that would be specific to that version, when updated would bite back, hence if you get locked out at least you know where to look.

Top


Ric