PacsOne fails to connect to MySQL

Antw1 · Post by **Antw1** » Sat May 20, 2006 12:27 pm

I installed PacsOne on a WinXP Pro test box with a RAID 5 array, initially with PHP 5.1.2 and MySQL 4.1.18, but eventually downgraded to PHP 5.0.0 and MySQL 4.1.7.

The system drive happens to be F:\ because of the RAID config, while C:\ is some smart card reader (now disabled), and this has caused me a tiny bit of trouble with the MySQL install (see:http://bugs.mysql.com/bug.php?id=625)

Anyway, I got everything up and running, PacsOne successfully installed, created database and tables, I logged in, added users, AET, so on and so forth.

Now, trying to send images to PacsOne is a no-go.
I checked the log, it states:

2006 error - MySQL : Couldn't connect to:PROXY_1, error Access denied for user 'root'@'localhost' (using password: YES), user = root

Gee!
When I thought I had PacsOne's install down...

Can't figure it out. Everything checks Ok.
I tried to run PacsOne installer a second time to setup a new instance (PROXY_2), but it doesn't seem to be running, I'm guessing trial license limitation...

Any thoughts?

Post by **pacsone** » Sun May 21, 2006 2:06 am

Try running the Setup.exe again, specify the same AE Title, database name, but specify a new username/password since the root username should not be used to run any client services such as PacsOne, as it is the Administrator username for MySQL.

Yes, the trial license only supports one PacsOne Server instance, so if you need to run multiple instances for your trial, please send a copy of your current trial license to mailto:pacsone@pacsone.net.

Antw1 · Post by **Antw1** » Sun May 21, 2006 2:17 am

Ran the setup again and specified different user but getting the same error...

Hmm....

Post by **pacsone** » Sun May 21, 2006 12:28 pm

Are you able to login to MySQL from a command shell, using the same very database, username and password? i.e.,

Code: Select all

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

where:

$database/$username is the MySQL database/username you've assigned for PacsOne Server.

Antw1 · Post by **Antw1** » Sun May 21, 2006 1:06 pm

Yes, the MySQL install worked just fine.

I ended up reinstalling Windows and repartitionning the RAID array with a more usual lettering scheme with C:\ as system volume, and D:\ as archiving volume.
After reinstalling everything from scratch, it seems to be running smoothly now.
This is odd, but I guess some software component got upset to have its install dir being F:\ instead of C:\.

Maybe PacsOne expected C:\ to be the system volume and got mixed up?

Anyway, now it's working.

Post by **pacsone** » Mon May 22, 2006 1:08 am

We had been installing PacsOne on non-C drives (e.g., D:, E:, F:, etc.) successfully so that should not be an issue for PacsOne.

Some older version of MySQL (3.x) had a known problem when it was not installed on the C: drive, but that was fixed a long time ago and should not be a problem for the MySQL 4.1.8 you've installed on this server.

We will keep an eye on this problem in case it shows up again.

trato01 · Post by **trato01** » Tue May 23, 2006 7:11 pm

Hi,

I am having the same connection problem..

During the installtion.. i specified the root id and pwd...
i connected OK..then created database and tables..

but when i launched:
http://ip/pacsone/pacsone.php. I tried to enter root and CORRECT password... it can't connect to the database...

What seems to be the problem?

Best regards,
tt.

trato01 · Post by **trato01** » Tue May 23, 2006 8:11 pm

By the way.. it's for the lastest Pacsone 4.0.1.

Thanks
tt.

Post by **pacsone** » Wed May 24, 2006 1:32 am

Did you check if the mysql or mysqli PHP extension has been loaded from the test page:

http://localhost/pacsone/Hello.php