[GRLUG] sugarcrm/mysql issue

[Roger Roelofs]

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.