Invalid MySQL Password for Administrator

[Glenn]

If you've installed version 3.1.5 of PacsOne Server, your configuration file $AeTitle.ini under the directory where PacsOne is installed should contain the MySQL port number and socket name, check if they match with what you have from the:

mysql>show variables;

command output.

I do not have a $AeTitle.ini, I do have a PacsOne.ini and the port and path match.

[pacsone]

$AeTitle is the AE title you've assigned for PacsOne, I guess in your case it's "PacsOne", so your configuration file was named "PacsOne.ini".

From your previous post, I saw the MySQL port is 3306 and the socket name is:

Socket = /var/lig/mysql/mysql.sock

which I don't think will match with the default MySQL socket in your configuration file.

[Glenn]

If you've installed version 3.1.5 of PacsOne Server, your configuration file $AeTitle.ini under the directory where PacsOne is installed should contain the MySQL port number and socket name, check if they match with what you have from the:

mysql>show variables;

command output.

I checked the download from your server and it matches the 3.1.5 tar file I used.
Does that ini file get created after you answer all the question? My process fails because of the mysql admin problem.
Your Install document talks about pacsone.ini.

[Glenn]

$AeTitle is the AE title you've assigned for PacsOne, I guess in your case it's "PacsOne", so your configuration file was named "PacsOne.ini".

From your previous post, I saw the MySQL port is 3306 and the socket name is:

Socket = /var/lig/mysql/mysql.sock

which I don't think will match with the default MySQL socket in your configuration file.

OK so I miss typed the Post.
The mysql.ini and the mysqli.ini files have that as the default.
I added them to the php.ini also and it still fails.
I reset all the passwords.
Strange part is the database is created with 31 tables.

[pacsone]

This means the MySQL client library that PacsOne uses is not compatible with the version of MySQL you've installed (4.1.12), again.

We'll try a test install using MySQL 4.1.12 and see if we run into the same problem here. In the meantime, you may want to try MySQL 4.1.8 or an older 4.1.x MySQL release instead.

[Guest]

I am having the same problem with pacsone 3.1.6 and mysql 4.1.12 on RHEL4. Can connect with /usr/bin/mysql -u $username -p $database.

mysql>show variables;

port = 3306
socket = /var/lib/mysql/mysql.sock

same as in $AeTitle

What to do?

[pacsone]

1. What's the exact error you were getting?

2. Does the MySQL username/password you entered when running Setup.exe contain any special characters (e.g., quotes, space, etc)?

[Guest]

1. When running install.sh during Setup.exe:

Config: Invalid MySQL Username/Password

[O]K =>

Warning

[O]K =>

Fom log file:

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

2. Just letters and numbers in username - root and password

[pacsone]

Can you try running the Setup.exe (under the directory where PacsOne is installed) again?

Use the same AE title but this time specify a new username/password other than root when it asks for a MySQL username? The username will be created by the installer if it does not already exist.

[Guest]

Same output from Setup.exe as before with different user (tuser):

Config: Invalid MySQL Username/Password

[O]K =>

Warning

[O]K =>

Fom log file:

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

2. Just letters and numbers in username - tuser and password

[Guest]

Correction from prior post for the log output:

MySQL: Couldn't connect to: dicom, error = Access denied for user 'tuser'@'localhost' (using password: YES), user = tuser

[pacsone]

Can you copy-n-paste the shell output of the entire session from running the Setup.exe? i.e., not just the final error.

[Guest]

************************************************************
Welcome to PacsOne Server Premium Edition Installation!
************************************************************

Will This Be a [N]ew Installation or pgrade?
Please Enter [N] or => N

Please Enter Application Entity Title for PacsOne Server Premium Edition: =>AETITLE

Please Enter Server Port Number for PacsOne Server Premium Edition: =>5678

Use Default MySQL Client Connection Settings Below ?
(TCP Port = [3306], Socket = [/var/lib/mysql/mysql.sock])
Please Type [Y]es, [N]o or ENTER to Use Default => Y

Please Enter MySQL Database Name for PacsOne Server Premium Edition: =>dicom

Please Enter MySQL Username for PacsOne Server Premium Edition: =>user2

Please Enter MySQL User Password for PacsOne Server Premium Edition: (Not Echoed for Security) =>

Please Enter Logfile Directory for PacsOne Server Premium Edition: [/home/pacsone/log/]
Press ENTER if default value is OK =>

Please Enter Default Archive Directory for PacsOne Server Premium Edition: [/var/pacsone/]
Press ENTER if default value is OK =>

Please Enter Storage Format: Dicom Part 10[X] or [N]ative
Please Enter [X] or [N] => X

*******************************************************************
Setup will delete any existing tables in database 'dicom'
before creating new tables

Press OK to confirm or CANCEL to abort.
*******************************************************************
[O]K [C]ANCEL =>O
Killing PacsOne Server with pid 4976

*******************************************************************
Database 'dicom' and/or Username 'user2' does not appear to be valid

Would you like to set it up?
*******************************************************************
[Y]ES [N]O =>Y

Please Enter MySQL Password for Administrator [root]: =>
*******************************************************************
Config: Invalid MySQL Username/Password
*******************************************************************
[O]K => [O]K =>O

*******************************************************************
Warning:
*******************************************************************
[O]K =>O

[pacsone]

The above session should have generated a dbinstall.log under the log sub-directory where PacsOne is installed. Can you verify that file has today's date as the modification date, and send it to mailto:pacsone@pacsone.net?

[retsil]

Hi,

I seem to have the same/similar problem.

What should I do?


[root@a3printer2 pacsone]# uname -a
Linux a3printer2 2.6.13-1.1532_FC4 #1 Thu Oct 20 01:30:08 EDT 2005 i686 i686 i386 GNU/Linux
[root@a3printer2 pacsone]# mysql --version
mysql Ver 14.7 Distrib 4.1.14, for redhat-linux-gnu (i386) using readline 4.3
[root@a3printer2 pacsone]# /usr/sbin/httpd -v
Server version: Apache/2.0.54
Server built: Sep 2 2005 11:54:18


mkdir /home/pacsone
chmod 644 /home/pacsone
cp pacsone-3.1.6.tar.gz /home/pacsone
cd /home/pacsone
gunzip pacsone-3.1.6.tar.gz
tar xvf pacsone-3.1.6.tar
./install.sh


[root@a3printer2 robert]# ls
applet.zip backup bin mbox pacsone-3.1.6.tar.gz public_html
[root@a3printer2 robert]# mkdir /home/pacsone
mkdir: cannot create directory `/home/pacsone': File exists
[root@a3printer2 robert]# chmod 644 /home/pacsone
[root@a3printer2 robert]# cp pacsone-3.1.6.tar.gz /home/pacsone
[root@a3printer2 robert]# cd /home/pacsone
[root@a3printer2 pacsone]# gunzip pacsone-3.1.6.tar.gz
[root@a3printer2 pacsone]# tar xvf pacsone-3.1.6.tar
db_schema
upgrade_schema
PacsOne.exe
PacsOneSrv.exe
Setup.exe
conformance.txt
license.txt
readme.txt
install.sh
uninstall.sh
pacsone.base
php/
php/actionItem.php
php/applentity.php
php/applet.php
php/authenticate.php
php/autoPurge.php
php/autoroute.php
php/cecho.php
php/cmove.php
php/contrast.php
php/database.php
php/dicom.php
php/display.php
php/download.php
php/edge.php
php/enhance.php
php/equalize.php
php/existingUser.php
php/export.php
php/exportStudy.php
php/download/
php/footer.php
php/forward.php
php/gamma.php
php/header.php
php/Hello.php
php/image2blob.php
php/image.php
php/importStudy.php
php/login.php
php/logout.php
php/manipulate.php
php/markPatient.php
php/markStudy.php
php/modifyAeTitle.php
php/modifyCoercion.php
php/modifyRoute.php
php/modifyUser.php
php/moveForm.php
php/negate.php
php/nocache.php
php/normalize.php
php/originalImage.php
php/pacsone.php
php/patient.php
php/remoteImage.php
php/remotePatient.php
php/remote.php
php/remoteSeries.php
php/remoteStudy.php
php/remoteWorklist.php
php/resize.php
php/rotate.php
php/searchPatient.php
php/search.php
php/searchRemote.php
php/searchRemoteWorklist.php
php/searchSeries.php
php/searchStudy.php
php/security.php
php/series.php
php/setup.php
php/sharedData.php
php/showImage.php
php/showReport.php
php/showTags.php
php/sreport.php
php/status.php
php/study.php
php/tempimage.php
php/tools.php
php/upgradeUser.php
php/user.php
php/utils.php
php/viewer.php
php/windowLevel.php
php/worklist.php
php/template_style.css
php/antispam.jpg
php/error.png
php/checkDate.js
php/thumbnails/
php/images/
php/print.php
php/printer.php
php/enabled.ico
php/disabled.ico
php/home.php
php/searchImage.php
php/logfile.php
php/manual.pdf
php/duplicates.php
php/browse.php
php/exportzip.php
php/report.php
php/basic_sasl_client.php
php/cram_md5_sasl_client.php
php/dailyreport.php
php/deencrypt.php
php/emailme.php
php/email.php
php/getmxrr.php
php/journal.php
php/login_sasl_client.php
php/mimePart.php
php/modifyEmail.php
php/monthlyreport.php
php/ntlm_sasl_client.php
php/plain_sasl_client.php
php/sasl.php
php/smtp.php
php/statistics.php
php/test_smtp.php
php/weeklyreport.php
php/htmlMimeMail5/
php/htmlMimeMail5/LICENSE
php/htmlMimeMail5/htmlMimeMail5.php
php/htmlMimeMail5/mimePart.php
php/htmlMimeMail5/RFC822.php
php/htmlMimeMail5/smtp.php
php/journalreport.php
mysql/
mysql/libmysqlpp.la
mysql/.libs/
mysql/.libs/libmysqlpp.la
mysql/.libs/libmysqlpp.so.1.0.0
mysql/.libs/libmysqlpp.lai
ImageMagick/
ImageMagick/libMagick.la
ImageMagick/Copyright.txt
ImageMagick/ImageMagick-5.5.6-Q16/
ImageMagick/ImageMagick-5.5.6-Q16/colors.mgk
ImageMagick/ImageMagick-5.5.6-Q16/log.mgk
ImageMagick/ImageMagick-5.5.6-Q16/magic.mgk
ImageMagick/ImageMagick-5.5.6-Q16/delegates.mgk
ImageMagick/ImageMagick-5.5.6-Q16/type-ghostscript.mgk
ImageMagick/ImageMagick-5.5.6-Q16/type-windows.mgk
ImageMagick/ImageMagick-5.5.6-Q16/type-solaris.mgk
ImageMagick/ImageMagick-5.5.6-Q16/type.mgk
ImageMagick/ImageMagick-5.5.6-Q16/modules/
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/modules.mgk
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/dcm.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/gif.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/jpeg.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/ttf.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/dcm.so
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/gif.so
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/jpeg.so
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/dcm.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/gif.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/jpeg.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/dcm.lai
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/gif.lai
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/jpeg.lai
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/ttf.la
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/ttf.so
ImageMagick/ImageMagick-5.5.6-Q16/modules/coders/.libs/ttf.lai
ImageMagick/php4/
ImageMagick/php4/imagick.so
ImageMagick/php5/
ImageMagick/php5/imagick.so
ImageMagick/.libs/
ImageMagick/.libs/libMagick.la
ImageMagick/.libs/libMagick-5.5.6-Q16.so.0.0.0
ImageMagick/.libs/libMagick.lai
cd/
dvd/
log/
log/report/
log/journal/
[root@a3printer2 pacsone]# ./install.sh
Checking for pre-requisites...
OK.
Configuring PacsOne Server Startup Scripts...
Done.
Configuring MySql Libraries...
/usr/bin/install -c .libs/libmysqlpp.so.1.0.0 /usr/local/lib/libmysqlpp.so.1.0.0
(cd /usr/local/lib && rm -f libmysqlpp.so.1 && ln -s libmysqlpp.so.1.0.0 libmysqlpp.so.1)
(cd /usr/local/lib && rm -f libmysqlpp.so && ln -s libmysqlpp.so.1.0.0 libmysqlpp.so)
/usr/bin/install -c .libs/libmysqlpp.lai /usr/local/lib/libmysqlpp.la
PATH="$PATH:/sbin" ldconfig -n /usr/local/lib
----------------------------------------------------------------------
Libraries have been installed in:
/usr/local/lib

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
- add LIBDIR to the `LD_LIBRARY_PATH' environment variable
during execution
- add LIBDIR to the `LD_RUN_PATH' environment variable
during linking
- use the `-Wl,--rpath -Wl,LIBDIR' linker flag
- have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
Done.
Configuring ImageMagick Libraries...
/usr/bin/install -c .libs/libMagick-5.5.6-Q16.so.0.0.0 /usr/local/lib/libMagick-5.5.6-Q16.so.0.0.0
(cd /usr/local/lib && rm -f libMagick-5.5.6-Q16.so.0 && ln -s libMagick-5.5.6-Q16.so.0.0.0 libMagick-5.5.6-Q16.so.0)
(cd /usr/local/lib && rm -f libMagick.so && ln -s libMagick-5.5.6-Q16.so.0.0.0 libMagick.so)
/usr/bin/install -c .libs/libMagick.lai /usr/local/lib/libMagick.la
PATH="$PATH:/sbin" ldconfig -n /usr/local/lib
----------------------------------------------------------------------
Libraries have been installed in:
/usr/local/lib

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
- add LIBDIR to the `LD_LIBRARY_PATH' environment variable
during execution
- add LIBDIR to the `LD_RUN_PATH' environment variable
during linking
- use the `-Wl,--rpath -Wl,LIBDIR' linker flag
- have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
PATH="$PATH:/sbin" ldconfig -n /usr/local/lib
----------------------------------------------------------------------
Libraries have been installed in:
/usr/local/lib

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
- add LIBDIR to the `LD_LIBRARY_PATH' environment variable
during execution
- add LIBDIR to the `LD_RUN_PATH' environment variable
during linking
- use the `-Wl,--rpath -Wl,LIBDIR' linker flag
- have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------

dcm.la
gif.la
jpeg.la
ttf.la
Done.
Configuring PacsOne Server...

************************************************************
Welcome to PacsOne Server Premium Edition Installation!
************************************************************

Will This Be a [N]ew Installation or pgrade?
Please Enter [N] or => N

Please Enter Application Entity Title for PacsOne Server Premium Edition: =>ap3rinter2

Please Enter Server Port Number for PacsOne Server Premium Edition: =>104

Use Default MySQL Client Connection Settings Below ?
(TCP Port = [3306], Socket = [/var/lib/mysql/mysql.sock])
Please Type [Y]es, [N]o or ENTER to Use Default =>

Please Enter MySQL Database Name for PacsOne Server Premium Edition: =>pacsone

Please Enter MySQL Username for PacsOne Server Premium Edition: =>root

Please Enter MySQL User Password for PacsOne Server Premium Edition: (Not Echoed for Security) =>

Please Enter Logfile Directory for PacsOne Server Premium Edition: [/home/pacsone/log/]
Press ENTER if default value is OK =>

Please Enter Default Archive Directory for PacsOne Server Premium Edition: [/var/pacsone/]
Press ENTER if default value is OK =>

Please Enter Storage Format: Dicom Part 10[X] or [N]ative
Please Enter [X] or [N] => X

*******************************************************************
Setup will delete any existing tables in database 'pacsone'
before creating new tables

Press OK to confirm or CANCEL to abort.
*******************************************************************
[O]K [C]ANCEL =>O

*******************************************************************
Database 'pacsone' and/or Username 'root' does not appear to be valid

Would you like to set it up?
*******************************************************************
[Y]ES [N]O =>Y

Please Enter MySQL Password for Administrator [root]: =>
*******************************************************************
Config: Invalid MySQL Username/Password
*******************************************************************
[O]K => [O]K =>O

*******************************************************************
Warning:
*******************************************************************
[O]K =>O
PacsOne Server Installation Complete.


[root@a3printer2 pacsone]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15 to server version: 4.1.14

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use pacsone
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
-> \g
+--------------------+
| Tables_in_pacsone |
+--------------------+
| annotation |
| applentity |
| attachment |
| autopurge |
| autoroute |
| coercion |
| conceptname |
| config |
| cronjob |
| dbjob |
| download |
| export |
| image |
| imagenotes |
| journal |
| patient |
| postroute |
| privilege |
| procedurecode |
| protocolcode |
| referencedpatient |
| referencedpps |
| referencedstudy |
| referencedvisit |
| requestedprocedure |
| scheduledps |
| series |
| smtp |
| study |
| studynotes |
| worklist |
+--------------------+
31 rows in set (0.00 sec)


I try /etc/rc.d/pacsone start but nothing happens

[root@a3printer2 pacsone]# ls
ap3rinter2.ini dvd log pacsone.base readme.txt
cd ImageMagick mysql PacsOne.exe Setup.exe
conformance.txt install.sh pacsone PacsOneSrv.exe uninstall.sh
db_schema license.txt pacsone-3.1.6.tar php upgrade_schema
[root@a3printer2 pacsone]# more ap3rinter2.ini
ApplicationEntityTitle = ap3rinter2
ServerPortNumber = 104
LogDirectory = /home/pacsone/log/
DefaultArchiveDirectory = /var/pacsone/
StorageFormat = DicomPart10
Database = pacsone
MysqlPort = 3306
MysqlSocket = /var/lib/mysql/mysql.sock
MySqlUser = C1CDB2DA37BC185F35976DDA0CA50171B056E30E8AD243AEF1D4745F0A3D7A440B7EA62943752114FC59509A052AC8618492C71CCC39CBDEDF9CFEFBA3C6F5889099EBBE637D15D6A9C7EDDEC42424FFD5D1A2EBAD518C1B8F6D7F3B00
MySqlPassword = C2D7B2C55CDD185F35976DDA0CA50171B056E30E8AD243AEF1D4745F0A3D7A440B7EA62943752114FC59509A052AC8618492C71CCC39CBDEDF9CFEFBA3C6F5889099EBBE637D15D6A9C7EDDEC42424FFD5D1A2EBAD518C1B8F6D7F3B00
[root@a3printer2 pacsone]# ls /var/lib/mysql/mysql.sock
/var/lib/mysql/mysql.sock
[root@a3printer2 pacsone]# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
<<garbage>>>
^]
telnet> close
Connection closed.
[root@a3printer2 pacsone]#