For the past week, I have been getting an error in the PACSONE log files.
The error reads:
ERROR - Exeption encountered in Database Job Thread
ERROR - RUNQUERY: SQL Bad Query: Access denied for user: 'ODBC@localhost' (Using password: NO)
I do not recall setting up a username 'ODBC'. This seems like a default name. Should I set this up? I did not see any mention of this user in the documentation.
Regards,
Greg
'ODBC@localhost'
From the log file, it looks like PacsOne has been configured to use the MySQL username ODBC to access MySQL, but was denied access.
If you did not use such MySQL username when running the installer for PacsOne, then someone has been tempering with your Windows registry settings since that's where PacsOne is reading the MySQL username from.
If that's the case, then PacsOne would not be able to access MySQL at all, since the MySQL username is invalid.
To fix this, you can do the following:
1. Uninstall PacsOne.
2. Re-install PacsOne but make sure to UNCHECK the checkbox Drop and create database tables, in ordr to use your existing MySQL database tables. Be sure to specify a valid MySQL username/password, or you'll be propmpted for the MySQL root password as a new MySQL username/password will be created for PacsOne.
If you did not use such MySQL username when running the installer for PacsOne, then someone has been tempering with your Windows registry settings since that's where PacsOne is reading the MySQL username from.
If that's the case, then PacsOne would not be able to access MySQL at all, since the MySQL username is invalid.
To fix this, you can do the following:
1. Uninstall PacsOne.
2. Re-install PacsOne but make sure to UNCHECK the checkbox Drop and create database tables, in ordr to use your existing MySQL database tables. Be sure to specify a valid MySQL username/password, or you'll be propmpted for the MySQL root password as a new MySQL username/password will be created for PacsOne.