[ic] Problem connecting to MySQL

[Dan B]

At 06:24 AM 3/3/2001 -0600, you wrote:
>It is on the same machine, but it won't connect via localhost. I get a can't
>connect to mysql via mysql.sock(111) error. But if I change it to the
>machine name it works. I had to do this to get DBD::mysql installed
>correctly.

Are you saying that you can't even connect using a $mysql prompt?  Maybe 
you could take your question to the MySQL list and try to get some help there.

Could be your DNS/network setup or a MySQL permissions problem.  Make sure 
you GRANT'ed the user for the right hostname and the 'localhost' hostname.

:-)

HTH, -dan.


>Robert
>----- Original Message -----
>From: "Mark Johnson" <markj@redhat.com>
>To: <interchange-users@lists.akopia.com>
>Sent: Friday, March 02, 2001 6:21 PM
>Subject: Re: [ic] Problem connecting to MySQL
>
>
> > If mysql is on the same machine as interchange, just remove the host
> > (and port if it's set) and try that. That is, in catalog.cfg:
> >
> > SQLDSN  dbi:mysql:dbname
> >
> >
> > Dan B wrote:
> > >
> > > At 05:51 PM 3/2/2001 -0600, you wrote:
> > > >I don't know because I don't know where to change the host setting.
>It's not
> > > >in the makecat script.
> > >
> > > There should be a line in catalog.cfg where you can set the $dbi
> > > thingy.  (hostname/port/etc.).
> > >
> > > -Dan
> > >
> > > >----- Original Message -----
> > > >From: "Dan B" <db@cyclonehq.dnsalias.net>
> > > >To: <interchange-users@lists.akopia.com>
> > > >Sent: Friday, March 02, 2001 5:29 PM
> > > >Subject: Re: [ic] Problem connecting to MySQL
> > > >
> > > >
> > > > > At 05:14 PM 3/2/2001 -0600, you wrote:
> > > > > >My DBI and DBD are uptodate but for some reason I cannot connect to
>mysql
> > > > > >using localhost, only the actual machine name. Please help or tell
>me if
> > > >I
> > > > > >can change the host setting somewhere to fix this.
> > > > >
> > > > > Does 127.0.0.1 work?
> > > > >
> > > > >
> > > > > Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > Interchange-users mailing list
> > > > > Interchange-users@lists.akopia.com
> > > > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > > >
> > > >
> > > >_______________________________________________
> > > >Interchange-users mailing list
> > > >Interchange-users@lists.akopia.com
> > > >http://lists.akopia.com/mailman/listinfo/interchange-users
> > >
> > > Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> > --
> > Mark Johnson
> > Senior Developer - Professional Services
> > Red Hat, Inc.
> > E-Business Solutions
> > markj@redhat.com
> > 703-456-2912
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users

Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com