Exception error connecting to database!

sother · Post by **sother** » Tue Jun 18, 2013 3:34 pm

Hello,

I installed wampserver2.2e (php5.3.13-httpd2.2.22-mysql5.5.24 32bit ) followed by PacsOne 6.3.7 on a Windows 2003 Server R2 system.

The installation went through fine and I am able to login, create user accounts etc.. However I am seeing several errors/exception in log file.

What could be missing here?

Relevant excerpts from the logs file is shown below

Tue Jun 18 04:01:46 2013 INFO - Server Process [1408] Initialized as AE Title: [DICOMae]
Tue Jun 18 04:01:46 2013 INFO - Server Socket: 240 created successfully
Tue Jun 18 04:01:46 2013 INFO - Socket: 240 bind to Port: 107
Tue Jun 18 04:01:46 2013 INFO - Worker Thread: 1520 running
Tue Jun 18 04:01:46 2013 INFO - Worker Thread: 1524 running
Tue Jun 18 04:01:54 2013 ERROR - Exception error connecting to database!
Tue Jun 18 04:01:55 2013 ERROR - Exception error connecting to database!
Tue Jun 18 04:01:56 2013 ERROR - Exception error connecting to database!
Tue Jun 18 04:01:57 2013 ERROR - Exception error connecting to database!
Tue Jun 18 04:01:58 2013 ERROR - Exception error connecting to database!
Tue Jun 18 04:01:59 2013 ERROR - Exception error connecting to database!
Tue Jun 18 04:02:00 2013 ERROR - Exception error connecting to database!

Post by **pacsone** » Tue Jun 18, 2013 4:26 pm

The errors mean PacsOne Server could not connect to MySQL using the username/password you assigned during its installation. So do you still remember the MySQL username/password you assigned to PacsOne Server during its installation? If so, you can try logging into MySQL using that very same username/password from a local command shell:

Code: Select all

C:\wamp\bin\mysql.exe -u $username -p

where $username is the MySQL username you assigned to PacsOne Server during its installation.

sother · Post by **sother** » Tue Jun 18, 2013 5:12 pm

Thanks! The issue was PacsOne Server was starting before mysqlserver. I started the services in the correct order and it seems to work now.

vtphilk · Post by **vtphilk** » Thu Aug 08, 2013 4:10 am

I too am getting this error after upgrade to 6.3.6. I stoped WAMP and PACs then restarted WAMP waited then started PACSone. Still same thing. Also it appears to not like one of my AE's. Does it include whitespaces in the AE names?

Thu Aug 08 00:05:41 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:05:42 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:05:43 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:05:43 2013 WARNING - Service STOP request received, shutting down...
Thu Aug 08 00:05:44 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:05:44 2013 INFO - Worker Thread: 6012 returning: 0
Thu Aug 08 00:05:44 2013 INFO - Worker Thread: 6008 returning: 0
Thu Aug 08 00:05:45 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:05:46 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:05:47 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:07 2013 INFO - Server Process [258204] Initialized as AE Title: [AETITLE]
Thu Aug 08 00:06:07 2013 INFO - Server Socket: 284 created successfully
Thu Aug 08 00:06:07 2013 INFO - Socket: 284 bind to Port: 104
Thu Aug 08 00:06:07 2013 INFO - Worker Thread: 255180 running
Thu Aug 08 00:06:07 2013 INFO - Worker Thread: 258996 running
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 INFO - Session: <1> started from SCU: 192.168.1.19
Thu Aug 08 00:06:12 2013 INFO - <1> Receiving A-ASSOCIATE-RQ PDU
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 INFO - 0 record found in [applentity] table
Thu Aug 08 00:06:12 2013 ERROR - Access denied for Application Entity: [NEMIO ], REJECTING
Thu Aug 08 00:06:12 2013 INFO - <1> Sending A-ASSOCIATE-RJ PDU
Thu Aug 08 00:06:12 2013 INFO - <1> A-ASSOCIATE-RJ PDU sent successfully
Thu Aug 08 00:06:12 2013 INFO - Session: <1> disconnected for client: 192.168.1.19
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!
Thu Aug 08 00:06:12 2013 ERROR - Exception error connecting to database!

Post by **pacsone** » Thu Aug 08, 2013 12:01 pm

The error means PacsOne Server could not connect to the MySQL database using the assigned MySQL username/password during its installation/upgrade. So can you verify if you can login to MySQL using that very same MySQL username/password by running the MySQL client from a local command shell? e.g.,

Code: Select all

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

where $database is the name of the MySQL database assigned to PacsOne Server, and $username is the MySQL username assigned to PacsOne Server during its installation/upgrade.