Re: [mv] Newbie and DBI problem please help

[Oldarnie <ecommerce@a-dream.com.au>]

******    message to minivend-users from Oldarnie <ecommerce@a-dream.com.au>     ******

Hi,

Thanks for the reply, the answers to your questions follow:

1) is mysqld running?            Yes
2) if you su to your minivend user can you run "mysql test_minivend"?
Yes and No    Clarification follows:
If I su minivend and run "mysql test_minivend" the command fails and produces the
can't connect through socket error, however if I exit back to root and run the
command "mysql -u minivend test_minivend" it works.
I think I understand what is happening but am unsure how to correct it.
I thought MySQL users were not the same as standard linux users i.e. you could be
xyz user under linux and connect to mysql as abc user as long as the privileges were
set to allow abc access.
I have set the privileges in mysql to allow "minivend" full access and when I run
the command "mysql -u minivend test_minivend" from "root" or any other user the
command works.
If I run the same command from the user "minivend" (linux user) the command doesn't
work.
This is very confusing
I have other users to the minivend group, and I have added minivend to the groups of
the other users, and set the file and directory permissions to allow members of the
users group full access.
So, the question is:
How do I get to run the command "mysql test_minvend" to work when I have su to
minivend???
or any other linux member for that matter that minivend has been set up to run
under?
Once I know the above I can start to work on getting a catalog to work

Thanks in advance
Oldarnie

Dan Busarow wrote:

> ******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******
>
> On Sat, 11 Mar 2000, Oldarnie wrote:
> > I am having a problem connecting to MySQL via socket from minivend 4 and
> > wondered if
> > someone who knows how the sockets work could give me a few pointers to
> > overcome the problem ?
> >
> > When trying to connect the error message that's generated is:
> >
> > Configuring catalog simple...
> > Using MySQL for databases, DSN=dbi:mysql:test_minivend.
> >
> > simple config error: DBI connect failed: Can't connect to local MySQL
> > server through socket
> > '/var/lib/mysql/mysql.sock'  (111)
>
> 1) is mysqld running?
> 2) if you su to your minivend user can you run "mysql test_minivend"?
> 3) if answer to 2 is yes, you need to test your DBI installation
>
> Dan
> --
>  Dan Busarow                                                  949 443 4172
>  Dana Point Communications, Inc.                            dan@dpcsys.com
>  Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list