[GRLUG] sugarcrm/mysql issue

[Roger Roelofs]

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.