Ubuntu Server MySQL error

[ricardopacs]

Well here complet screens:


ricardo@ubuntu-pacs:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 41
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| smsrl |
+--------------------+
3 rows in set (0.00 sec)

mysql> show grants for pacsone@localhost;
+-------------------------------------------------------------------------------------------------------------------------+
| Grants for pacsone@localhost |
+-------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'pacsone'@'localhost' IDENTIFIED BY PASSWORD '*26B38CADBE249591F60B1D88ADF2A5E775AAE4BB' |
+-------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> quit
Bye
ricardo@ubuntu-pacs:~$ cd pacsone
ricardo@ubuntu-pacs:~/pacsone$ sudo ./install.sh
[sudo] password for ricardo:
Checking for pre-requisites...
OK.
Using default /sbin/chkconfig.
Configuring PacsOne Server Startup Scripts...
Done.
Configuring JPEG-LS Library...
libtool: install: /usr/bin/install -c .libs/libjpegls.so.1.0 /usr/local/lib/libjpegls.so.1.0
libtool: install: (cd /usr/local/lib && { ln -s -f libjpegls.so.1.0 libjpegls.so.1 || { rm -f libjpegls.so.1 && ln -s libjpegls.so.1.0 libjpegls.so.1; }; })
libtool: install: (cd /usr/local/lib && { ln -s -f libjpegls.so.1.0 libjpegls.so || { rm -f libjpegls.so && ln -s libjpegls.so.1.0 libjpegls.so; }; })
libtool: install: /usr/bin/install -c .libs/libjpegls.lai /usr/local/lib/libjpegls.la
libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/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.
----------------------------------------------------------------------
Configuring MySql Libraries...
libtool: install: /usr/bin/install -c .libs/libmysqlpp.so.2.3.2 /usr/local/lib/libmysqlpp.so.2.3.2
libtool: install: (cd /usr/local/lib && { ln -s -f libmysqlpp.so.2.3.2 libmysqlpp.so.2 || { rm -f libmysqlpp.so.2 && ln -s libmysqlpp.so.2.3.2 libmysqlpp.so.2; }; })
libtool: install: (cd /usr/local/lib && { ln -s -f libmysqlpp.so.2.3.2 libmysqlpp.so || { rm -f libmysqlpp.so && ln -s libmysqlpp.so.2.3.2 libmysqlpp.so; }; })
libtool: install: /usr/bin/install -c .libs/libmysqlpp.lai /usr/local/lib/libmysqlpp.la
libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/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...
libtool: install: /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
libtool: install: (cd /usr/local/lib && { ln -s -f libMagick-5.5.6-Q16.so.0.0.0 libMagick-5.5.6-Q16.so.0 || { 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; }; })
libtool: install: (cd /usr/local/lib && { ln -s -f libMagick-5.5.6-Q16.so.0.0.0 libMagick.so || { rm -f libMagick.so && ln -s libMagick-5.5.6-Q16.so.0.0.0 libMagick.so; }; })
libtool: install: /usr/bin/install -c .libs/libMagick.lai /usr/local/lib/libMagick.la
libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/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.
----------------------------------------------------------------------
libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/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: =>PAC

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

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

Please Enter Username for PacsOne Server Premium Edition: =>pacsone@localhost

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

Use Default Database 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 Logfile Directory for PacsOne Server Premium Edition: [/home/ricardo/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

Enable HL-7 Message Listner Option?
Please Enter [Y] or [N] => N

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

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

*******************************************************************
Database 'smsrl' and/or Username 'pacsone@localhost' does not appear to be valid

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

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

Please Enter Database Password for Administrator [root]: =>
[3]+ Detenido sudo ./install.sh
ricardo@ubuntu-pacs:~/pacsone$

the databases, and users it's created but ...
please help me

Best Regards

[pacsone]

There were 2 issues:

1. The mysql username you've configured is pacsone, but you've entered "pacsone@localhost" as the MySQL username when running the PacsOne Server Installer, which is different from the pacsone MySQL username you've already created.

2. A more series problem is that the PacsOne Server Installer could not connect to MySQL as the Administrator root, although you seem to be able to login to MySQL from a local command shell. So make sure you enter the same password for root when prompted by the PacsOne Server Installer and if so, check if MySQL is running with the default socket name and TCP port on this server:

Code: Select all

# ps -ef|grep mysqld

[ricardopacs]

Well ... the error are the socket, here the correct configuration for Ubuntu Server 10.10 :


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

Please Enter Database Client TCP Port Number [3306]: =>3306

Please Enter Database Client Socket [/var/lib/mysql/mysql.sock]: =>/var/run/mysqld/mysqld.sock

and work fine, thank you

Best Regards