socket.

From: Deen (deen_at_slt.lk)
Date: 12/11/03 

To: <dbi-users@perl.org>
Date: Wed, 10 Dec 2003 18:39:58 -0800

I have installed DBI-1.19, and trying to use radiator radius server to call an MySQL query using DBI. I am getting the following error. My actual socket is under /etc.
I guess this error originates from the DBI. The install was perfect.

Deen

Wed Dec 10 18:29:47 2003: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Wed Dec 10 18:29:47 2003: DEBUG: Deleting session for mikem,
203.63.154.1, 1234
Wed Dec 10 18:29:47 2003: DEBUG: Handling with Radius::AuthSQL
Wed Dec 10 18:29:47 2003: DEBUG: Handling with Radius::AuthSQL:
DBI->connect(radius) failed: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) at
/usr/lib/perl5/site_perl/5.8.0/Radius/SqlDb.pm line 108
Wed Dec 10 18:29:47 2003: ERR: Could not connect to SQL database with
DBI->connect dbi:mysql:radius, root, deen123: Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Wed Dec 10 18:29:47 2003: ERR: Could not connect to any SQL database.
Request is ignored. Backing off for 600 seconds
Wed Dec 10 18:29:52 2003: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1184 ....
Code: Accounting-Request
Identifier: 78
Authentic: <152>5<192>G~<220><205>?<222><138>J<219>.<232>R<239>
Attributes:
        User-Name = "mikem"
        Service-Type = Framed-User
        NAS-IP-Address = 203.63.154.1
        NAS-Port = 1234
        NAS-Port-Type = Async
        Acct-Session-Id = "00001234"
        Acct-Status-Type = Start
        Called-Station-Id = "123456789"
        Calling-Station-Id = "987654321"
        Acct-Delay-Time = 0

Wed Dec 10 18:29:52 2003: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Wed Dec 10 18:29:52 2003: DEBUG: Adding session for mikem,
203.63.154.1, 1234

Relevant Pages

  • Re: MySQL via SSH Tunnel
    ... Can't connect to local MySQL server through socket ... Der Socket existiert. ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the filesystem, or by using TCP/IP, which connects through a port number. ...
    (de.comp.datenbanken.mysql)
  • DBD::mysql failing to make test
    ... To teach myself, I have been working my way through Paul DuBois' 'MySQL' book, first edition. ... I've had no problem connecting to the server with the 'mysql' client and running the test exercises. ... So now I'm up to the chapter on the Perl DBI. ... This test requires a running server and write permissions. ...
    (perl.dbi.users)
  • Re: MySQL 4.1+ Password Incompatibility
    ... >> I'm having trouble getting DBI connect to a MySQL 4.1+ server. ... >> byte hashes instead of 45 byte hashes. ...
    (perl.dbi.users)
  • Re: [SLE] Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (13)
    ... "Can't connect to local MySQL server through socket ... The socket in question exists in /var/lib/mysql, ... commandline client, use the -s option to specify the socket. ...
    (SuSE)
  • Re: cant connect
    ... > can connect from command line and can do mysql commands. ... > the same machine as the web server, so I use localhost as the host. ... Dos it redefine the socket ...
    (comp.lang.php)