in reply to Re: Canot connect to the remote mysql server through those lines
in thread Canot connect to the remote mysql server through those lines

Guys, this a remote server that i have only ftp access to it and some space to upload files.

I cant check whether the file '/var/run/mysqld/mysqld.sock' exists or not, i aksed na admin though and he definately stated that the mysql server on freehostia runs normally. I also have no access to any of the error logs.

I switched the code to this but it still produces the same error:

#===================================================================== +========== my $db = ( $ENV{'SERVER_NAME'} !~ /freehostia/ ) ? DBI->connect('DBI:mysql:e_shop@localhost', 'root', '*****', { +RaiseError=>1}) : DBI->connect('DBI:mysql:nikkou6_db@mysql3.freehostia.com', 'n +ikkou6_db', '*****', {RaiseError=>1}); if( $ENV{'SERVER_NAME'} =~ /freehostia/ ) { $ENV{'DOCUMENT_ROOT'} = ' +/www/nikos.varsa.gr/' }; #===================================================================== +==========
  • Comment on Re^2: Canot connect to the remote mysql server through those lines
  • Download Code

Replies are listed 'Best First'.
Re^3: Canot connect to the remote mysql server through those lines
by shmem (Chancellor) on Jul 01, 2007 at 20:48 UTC
    Consult the DBI docs. Your DSN doesn't fit. snopal gave you some hints.

    --shmem

    _($_=" "x(1<<5)."?\n".q·/)Oo.  G°\        /
                                  /\_¯/(q    /
    ----------------------------  \__(m.====·.(_("always off the crowd"))."·
    ");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}
Re^3: Canot connect to the remote mysql server through those lines
by Anonymous Monk on Jul 02, 2007 at 05:46 UTC
    Keep your own log
    A reply falls below the community's threshold of quality. You may see it by logging in.