crash

tservice · Post by **tservice** » Tue Dec 23, 2008 10:04 pm

After a harddrive crash, I got the system back together. I restored my mysql database, while reinstalling pacsone it was asking for a upgrade code because I had unchecked drop and create database tables. So I checked that box and all is fine. However when I restored the Mysql database pacsone is giving a error
exception error connecting to mysql
any thoughts?

Post by **pacsone** » Wed Dec 24, 2008 1:45 am

When you restore the MySQL database from backup, the MySQL username/password you entered during the Installation of PacsOne Server may have been wiped out by the restore, thus the MySQL connection errors after the restore since PacsOne Server could no longer connect to MySQL using the previous MySQL username/password.

So you should either run the Installer AFTER restoring the MySQL database, or if you choose to run the Installer before restoring MySQL, you should make sure you enter a MySQL username/password which already exists in the MySQL database backup (to be restored from), so that the MySQL username/password are still valid after you restore the MySQL database.

tservice · Post by **tservice** » Wed Dec 24, 2008 1:57 am

thanks for your reply, Both user and password are the same. But after I restored the mysql database (after reinstalling pacsone) I can view images before the crash, and Pacsone keeps generating the error. I will admit that I don't have a full understanding of mysql yet, so I may have not done something right.
Thanks for your time

Post by **pacsone** » Wed Dec 24, 2008 1:02 pm

After restoring the MySQL database but before you install PacsOne Server, try logging into the MySQL database using the very same username/password from a local command shell, e.g.,

Code: Select all

C:\mysql\bin>mysql -u $username -p $database

where $database/$username is the MySQL database/username you assigned to PacsOne Server previously before restoring the MySQL database.