Re: [cobalt-security] Re: [RaQ4] ASP and MySQL problem (URGENT)

["Ian" <cobalt@xxxxxxxxxxxxx>]

On 12 Feb 2003 at 11:12, Mikael Siirilä wrote:

> Hi,
> 
> > > For some reason some ASP scripts that used to work are now
> > > resulting in errors. They all use MySQL databases. Also the
> > > ASP server DSN test results in the following error:
> > >
> > > - - -
> > >
> > > Test connecton failed
> > >
> > > Error: -2147418113
> > > Description: Chili!Soft ASP ADO control - build 3.6.2 SQLState: S1000
> > > Native Error Code: 2002
> > > [TCX][MyODBC]Can't connect to local MySQL server through
> > > socket '/tmp/mysql.sock' (111)
> > 
> > does /tmp/mysql.sock exist?
> > perhaps the updated MySQL put it in another directory (see conf file).
> 
> No, /tmp/mysql.sock does not exist. The mysql.sock file is 
> in /var/lib/mysql/mysql.sock (/home/mysql/mysq.sock). This path is mentioned 
> in the PHP settings but apparently ASP uses a "/tmp/mysql.sock". The existing 
> file is 0 bytes in size.

First of all cd to /tmp

# cd tmp

Then create a symbolic link to the socket file, so any other 
connections are not messed up:

ln -s /home/mysql/mysql.sock .

The trailing dot is important.


Ian
--

> Where do I specify the socket path for Chili!ASP 3.6.2? I have been unable to 
> find initialization files with this setting ...
>
> Thanks in advance! Sorry for posting this to the security list even though 
> there probably is no security concern in this issue. My bad.
> 
> --
> Mikael
> 
> _______________________________________________
> cobalt-security mailing list
> cobalt-security@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-security