Where is mysql.sock path configured.

[Anton Müller]

Hi,

my problem for during installing icinga-web-1.0.1
on suse linux 11.1:

the "make db-initialize" tries to connect to:

'/var/lib/mysql/mysql.sock'

But my mysql runs on:

'/var/run/mysql/mysql.sock'

I greped the whold /etc but didn't find out,
how "make db-initialize" gets his configuration.


I am just reading:

http://docs.icinga.org/latest/en/icinga-web-scratch.html

I am at step 4, "Create Database".

I type:

#> make db-initialize

I get:--------------------------

make db-initialize

Buildfile: /home/anton/install/icinga/icinga-web-1.0.1/etc/build.xml
[property] Loading /home/anton/install/icinga/icinga-web-1.0.1/etc/build.properties

icinga-web > db-initialize:

[phingcall] Calling Buildfile '/home/anton/install/icinga/icinga-web-1.0.1/etc/build.xml' with target 'db-create'
[property] Loading /home/anton/install/icinga/icinga-web-1.0.1/etc/build.properties

icinga-web > prepare:


icinga-web > db-prepare:

Use the db-user specified in icinga-webs database.xml (Needs create Database/create Table rights)?(n,y)? y

icinga-web > db-create:

Error during schema creation - are you sure the table doesn't already exist? If so, use the update command.

PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
WARNING: Initial data import may have failed due too many references.

BUILD FINISHED

# end ---------------------------------------


Could you give me a hint???

Thanks a lot

Anton

[Michael Friedrich]

Post by Anton Müller
Hi,
my problem for during installing icinga-web-1.0.1
'/var/lib/mysql/mysql.sock'
'/var/run/mysql/mysql.sock'
I greped the whold /etc but didn't find out,
how "make db-initialize" gets his configuration.
http://docs.icinga.org/latest/en/icinga-web-scratch.html
I am at step 4, "Create Database".
#> make db-initialize
I get:--------------------------

Post by Anton Müller
make db-initialize

Buildfile: /home/anton/install/icinga/icinga-web-1.0.1/etc/build.xml
[property] Loading /home/anton/install/icinga/icinga-web-1.0.1/etc/build.properties
[phingcall] Calling Buildfile '/home/anton/install/icinga/icinga-web-1.0.1/etc/build.xml' with target 'db-create'
[property] Loading /home/anton/install/icinga/icinga-web-1.0.1/etc/build.properties
Use the db-user specified in icinga-webs database.xml (Needs create Database/create Table rights)?(n,y)? y
Error during schema creation - are you sure the table doesn't already exist? If so, use the update command.
PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
WARNING: Initial data import may have failed due too many references.
BUILD FINISHED
# end ---------------------------------------
Could you give me a hint???

Well that's PHP PDO related - you need to point PDO where your MySQL
socket can be found. E.g. by editing the php.ini and then restarting the
webserver.

http://stackoverflow.com/questions/1435445/error-on-creating-connection-to-pdo-in-php

Kind regards,
Michael

Post by Anton Müller
Thanks a lot
Anton

--
DI (FH) Michael Friedrich

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria

email: ***@univie.ac.at
phone: [phone]
fax: [phone]
web: http://www.univie.ac.at/zid

Icinga Core& IDOUtils Developer
http://www.icinga.org

[Anton Müller]

Hi Michael,

thanks for the fast response.

snip snip cut off some lines

Post by Anton Müller
Could you give me a hint???

Well that's PHP PDO related - you need to point PDO where your MySQL
socket can be found. E.g. by editing the php.ini and then restarting the
webserver.
http://stackoverflow.com/questions/1435445/error-on-creating-connection-to-pdo-in-php

Unfortunately I don't get it work since I am
using php 5.3.3.

I suppose its related to:

"php.ini directive pdo_mysql.default_socket is ignored"

see: http://bugs.php.net/bug.php?id=50829

:-(

Thanks again,

Anton

[User66]

Hi,

Have you set the socket parameter in both php.ini files, cli and apache2 ?

My installation (openSUSE 11.3, PHP 5.3.2, MySQL 5.1.46) went fine, even
though I have set "socket = /var/run/mysql/mysql.sock" in /etc/my.cnf and my
PDO parameters in php.ini are set to default (empty).
Did you check my.cnf ?

Cheers
Ralf

Post by Anton Müller

Post by Michael Friedrich
Well that's PHP PDO related - you need to point PDO where your MySQL
socket can be found. E.g. by editing the php.ini and then restarting the
webserver.
http://stackoverflow.com/questions/1435445/error-on-creating-conne
ction-to-pdo-in-php

Unfortunately I don't get it work since I am
using php 5.3.3.
"php.ini directive pdo_mysql.default_socket is ignored"
see: http://bugs.php.net/bug.php?id=50829

[Anton Müller]

Hi,

Post by User66
Have you set the socket parameter in both php.ini files, cli and apache2 ?

Yes ... but perhaps I did a mistake.

In what section die you add it...
in [PHP]?

I added a section PDO with all syntax forms to be sure:

[PDO]
PDO.mysql.default_socket = /var/run/mysql/mysql.sock
pdo_mysql.default_socket =/var/run/mysql/mysql.sock

[pdo_mysql]
PDO.mysql.default_socket = /var/run/mysql/mysql.sock
pdo_mysql.default_socket =/var/run/mysql/mysql.sock

Post by User66
My installation (openSUSE 11.3, PHP 5.3.2, MySQL 5.1.46) went fine, even
though I have set "socket = /var/run/mysql/mysql.sock" in /etc/my.cnf and my
PDO parameters in php.ini are set to default (empty).
Did you check my.cnf ?

Oh yes in my my.cnf there are only /var/run/mysql/mysql.sock,
I checked this.

Post by User66
Cheers
Ralf

Post by Anton Müller

Post by Michael Friedrich
Well that's PHP PDO related - you need to point PDO where your MySQL
socket can be found. E.g. by editing the php.ini and then restarting

the

Post by Anton Müller

Post by Michael Friedrich
webserver.
http://stackoverflow.com/questions/1435445/error-on-creating-conne
ction-to-pdo-in-php

Unfortunately I don't get it work since I am
using php 5.3.3.
"php.ini directive pdo_mysql.default_socket is ignored"
see: http://bugs.php.net/bug.php?id=50829

Thanks

Anton