[GRLUG] sugarcrm/mysql issue

[Roger Roelofs]

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.