[GRLUG] sugarcrm/mysql issue

[Eric Beversluis]

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.