Admin Panel 2: phpMyBackupPro: Difference between revisions
(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 ...) |
(Removed excess category tags) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
'''phpMyBackupPro''' | '''phpMyBackupPro''' | ||
Click this link to login into '''phpMyBackup Pro''' | 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 also 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) | Login requires your MySQL username and password (defaults are root and root). Remember to change your MySQL root password using [[Admin Panel 2: MySQL Server Configuration|MySQL server configuration]]. | ||
The next time you login use the new password. | The next time you login. use the new password. | ||
== Security == | == Security == | ||
PhpMybackupPro has what I would define an interesting little security feature | PhpMybackupPro has what I would define as 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 | 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 | Now let's 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'''! | '''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. | 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. Then click on save data. The next time you login, use the new password and everything will work. | ||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
== Locked out == | == 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. | It is an excellent piece of software but it does not like to be hacked around. If it detects something amiss with its configuration file, it 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, | A classic lockout situation is password inconsistencies. (OK, I confess that I just could not remember the password I was using.) | ||
I found this by using MySQL Server Configuration in apanel and made sure that phpMyAdmin could access the MySQL sever. So the server was working right. I was just locked out of phpMyBackupPro. | |||
So the server | |||
No problem opened the file: '''global_conf.php''' | No problem. I opened the file: '''global_conf.php''', located in folder '''*\Uniform Server\udrive\home\admin\www\phpMyBackupPro''', I went down to the line '''$CONF['sql_passwd']="idiot";''' and change the password from '''idiot''' (or whatever) to the new password and I was able to access phpMyBackupPro. | ||
'''''Note'':''' For security reasons, the password file is located outside of your public web server’s root directory (www). | |||
'''''Note'':''' For security reasons the password file is located outside of your public web server’s root directory www. | |||
== The real problem == | == The real problem == | ||
Until the code can be corrected (requiring a version change), when you run into this problem and get locked out, at least now you know where to look. | |||
'''''[[#top | Top]]''''' | '''''[[#top | Top]]''''' | ||
| Line 48: | Line 42: | ||
[[Category: UniCenter]] | [[Category: UniCenter]] | ||
Latest revision as of 10:08, 21 June 2013
| 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 also 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 as 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 let's 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. Then click on save data. The next time you login, use the new password and everything will work.
Locked out
It is an excellent piece of software but it does not like to be hacked around. If it detects something amiss with its configuration file, it 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 that I just could not remember the password I was using.) I found this by using MySQL Server Configuration in apanel and made sure that phpMyAdmin could access the MySQL sever. So the server was working right. I was just locked out of phpMyBackupPro.
No problem. I opened the file: global_conf.php, located in folder *\Uniform Server\udrive\home\admin\www\phpMyBackupPro, I went down to the line $CONF['sql_passwd']="idiot"; and change the password from idiot (or whatever) to the new password and I was 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
Until the code can be corrected (requiring a version change), when you run into this problem and get locked out, at least now you know where to look.
 |
Ric |