[GRLUG] sugarcrm/mysql issue

[Eric Beversluis]

The trouble is, it's not working. Likely it's not even a user/password
problem, as that would return a 'permission denied' error, I think
rather than a strange 'socket' problem.

On Fri, 2011-06-03 at 17:03 -0400, Roger Roelofs wrote:
> Eric,
> 
> Well, If root at localhost is defined I would think you could log in as
> root from the command line.  You don't type type network part it is
> automatically generated based on what box you are logging in from.
> Assuming you are logged into the db server box via ssh, I would expect
> 
> mysql -uroot -p
> 
> to work also assuming you have the correct password.
> 
> On Fri, Jun 3, 2011 at 4:54 PM, Eric Beversluis
> <ebever at researchintegration.org> wrote:
> > I've tried
> > from: the server itself; ssh connection from a Ubuntu box; NX connection
> > from a Win 7 box
> >
> > using
> > root
> > root at localhost
> > root at 127.0.0.1
> > root at lagohsl03
> >
> > Always get the same error.
> > Going into mysql/data/mysql and cat user.MYD only indicates 'root' and
> > those various host names.
> >
> > On Fri, 2011-06-03 at 16:28 -0400, Roger Roelofs wrote:
> >> Eric,
> >>
> >> mysql stores username / network pairs.  The user could exist but not
> >> have access from a particular network location.  So it could be a bad
> >> password or a network restriction.  Do you have access to the user
> >> list in some form?
> >>
> >> On Fri, Jun 3, 2011 at 4:11 PM, Eric Beversluis
> >> <ebever at researchintegration.org> wrote:
> >> > Duh! I'm not sure why I forget that. I suspect I don't really understand
> >> > why it's necessary.
> >> >
> >> > Making progress. But now getting this error message after entering
> >> > password:
> >> >
> >> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> >> > '/tmp/mysql.sock' (2)
> >> >
> >> > I got this result both as 'eric' and as 'root'.
> >> > Would this be a password problem for the DB? or would it say something
> >> > explicitly about password if that's now the problem?
> >> >
> >> > On Fri, 2011-06-03 at 15:48 -0400, Ben Rousch wrote:
> >> >> Assuming you have execute rights, try ./mysql and ./mysqldump
> >> >>
> >> >> On Fri, Jun 3, 2011 at 3:37 PM, Eric Beversluis
> >> >> <ebever at researchintegration.org> wrote:
> >> >> > We've got Sugarcrm running on a SLES box. I"m trying to do a backup of
> >> >> > the mysql DB and running into this problem:
> >> >> >
> >> >> > As root, I navigate to /opt/<sugarfolder>/mysql/bin, where I see the
> >> >> > list of all the mysql commands, including 'mysql' and 'mysqldump'. But
> >> >> > when I try either of these, I get the 'command unknown' response.
> >> >> >
> >> >> > mysql -u root -p
> >> >> > or
> >> >> > mysqldump -u root -p sugarcrm
> >> >> >> /home/eric/Desktop/sugar_mysql_backup.sql
> >> >> >
> >> >> > I think I've used both of those commands successfully with other mysql
> >> >> > settings.
> >> >> >
> >> >> > Any ideas or insights?
> >> >> >
> >> >> > Thanks.
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > --
> >> >> > This message has been scanned for viruses and
> >> >> > dangerous content by MailScanner, and is
> >> >> > believed to be clean.
> >> >> >
> >> >> > _______________________________________________
> >> >> > grlug mailing list
> >> >> > grlug at grlug.org
> >> >> > http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >>  Ben Rousch
> >> >>    brousch at gmail.com
> >> >>    http://clusterbleep.net/
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> > This message has been scanned for viruses and
> >> > dangerous content by MailScanner, and is
> >> > believed to be clean.
> >> >
> >> > _______________________________________________
> >> > grlug mailing list
> >> > grlug at grlug.org
> >> > http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
> >> >
> >>
> >>
> >>
> >> --
> >> Roger
> >>
> >> Roger Roelofs
> >> Know what you value.
> >>
> >
> >
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> >
> > _______________________________________________
> > grlug mailing list
> > grlug at grlug.org
> > http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
> >
> 
> 
> 
> -- 
> Roger
> 
> Roger Roelofs
> Know what you value.
> 



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.