MySql problemm installing 6.3.1 version on SLES11 SP1

jlgamero · Post by **jlgamero** » Wed May 04, 2011 10:51 pm

Hello,
I've just dowloaded and installed PacsOne Premiun 6.3.1 in a clean install of SLES 11 SP 1 64 bits.

The problem I've found is that when the installer needs to setup the database it can not connect as root user. I've checked MySql is up and runnig fine, I've also checked I'm using the rigth password.

This is the message i get whenever i try to install.

Please Enter Database Password for Administrator [root]: =>
*******************************************************************
Failed to connect to database as: 'root'
*******************************************************************

Thanks for your help

Jorge

Post by **pacsone** » Thu May 05, 2011 12:57 am

1. Can you check if you can login to MySQL as root from a local command shell?

Code: Select all

$ mysql -u root -p

2. If so, check and make sure all the dependent shared libraries of the Installer (Setup.exe under the directory where PacsOne is installed) can be found by the dynamic linker:

Code: Select all

$ ldd Setup.exe

jlgamero · Post by **jlgamero** » Thu May 05, 2011 4:38 pm

I've already double checked I can login to MySQL from a command shell.

this is the output from the linker:

install # ldd Setup.exe
linux-vdso.so.1 => (0x00007fffb0a6c000)
libmysqlpp.so.2 => /usr/local/lib/libmysqlpp.so.2 (0x00007ff340f99000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007ff340c8e000)
libm.so.6 => /lib64/libm.so.6 (0x00007ff340a38000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007ff340821000)
libc.so.6 => /lib64/libc.so.6 (0x00007ff3404c3000)
libmysqlclient.so.15 => /usr/lib64/libmysqlclient.so.15 (0x00007ff340167000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007ff33ff4a000)
libz.so.1 => /lib64/libz.so.1 (0x00007ff33fd34000)
/lib64/ld-linux-x86-64.so.2 (0x00007ff3411d4000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007ff33faf9000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007ff33f8e1000)
libssl.so.0.9.8 => /usr/lib64/libssl.so.0.9.8 (0x00007ff33f68d000)
libcrypto.so.0.9.8 => /usr/lib64/libcrypto.so.0.9.8 (0x00007ff33f312000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007ff33f10e000)

I've also checked the MySQL socket as you suggested in other post, its ok.
I still can't finish the installation.

Jorge

Post by **pacsone** » Thu May 05, 2011 6:30 pm

1. What is the version of MySQL installed on this server and is it 64-bit or 32-bit?

Code: Select all

# ldd mysqld

2. When you ran the PacsOne Server Installer, what did you enter as the database hostname (default is localhost)?

jlgamero · Post by **jlgamero** » Thu May 05, 2011 6:49 pm

Ok, I think that was the problem, I was using my host name instead of "localhost"
Thanks for your help

Jorge

Post by **pacsone** » Thu May 05, 2011 10:15 pm

Yes, you should enter a non-default hostname only if the MySQL database server is running on a remote host (not localhost).