[GRLUG] sugarcrm/mysql issue

Eric Beversluis ebever at researchintegration.org
Mon Jun 6 14:58:36 EDT 2011 

Well, for some reason, that worked (using 'mysql -u root -p -h
127.0.0.1'). 

(from 'ps -ef |grep mysql*':

root      3170     1  0 Jun05 ?
00:00:00 /bin/sh /opt/sugarcrm-5.5.4/mysql/bin/safe_mysqld --port=3306
--socket=/opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock --old-passwords
--datadir=/opt/sugarcrm-5.5.4/mysql/data
--log-error=/opt/sugarcrm-5.5.4/mysql/data/mysqld.log
--pid-file=/opt/sugarcrm-5.5.4/mysql/data/mysqld.pid
mysql     3338  3170  0 Jun05 ?
00:00:00 /opt/sugarcrm-5.5.4/mysql/bin/mysqld
--basedir=/opt/sugarcrm-5.5.4/mysql
--datadir=/opt/sugarcrm-5.5.4/mysql/data --user=mysql
--pid-file=/opt/sugarcrm-5.5.4/mysql/data/mysqld.pid
--skip-external-locking --port=3306
--socket=/opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock --old-passwords
root     13044 13027  0 12:02 pts/0    00:00:00 grep mysql*


On Fri, 2011-06-03 at 17:43 -0400, Roger Roelofs wrote:
> Eric,
> 
> That's odd.  This is a long shot, but what about (from the db server)
> 
> mysql -u root -p -h 127.0.0.1
> 
> On Fri, Jun 3, 2011 at 5:13 PM, Eric Beversluis
> <ebever at researchintegration.org> wrote:
> > 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.
> >
> > _______________________________________________
> > 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.

More information about the grlug mailing list