HELP NEEDED => Can't connect to DB after executing a gran

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

HELP NEEDED => Can't connect to DB after executing a gran

Postby lmora » Thu Nov 19, 2009 11:59 am

Hi guys

I think I entered the nose in the wrong place and now my system is crashed.

Please I need your help.

I entered to mysql command line as mysql -u root and executed the following commands :
-- grant process *.* to mysqltop@10.0.1.215;
-- grant process *.* to cron@10.0.1.215;
-- flush privileges;

Right after that all the operation was stopped and started receiving this error
MySQL connect ERROR: Access denied for user 'cron'@'10.0.1.215' (using password: YES)

at admin.php

BTW, I did it because I read it was needed in order to be able to run mtop command.
how do I revert this ?

Execution of the command mysql -u cron -p and password is still recognized.
Connection to db from a third-party console also works and am able to list and see table contents.

Unfortunately my operation is down. :(
Vicibox Redux v.3.1.10 from .iso | Version: 2.4-327c Build: 110510-1637 | Asterisk 1.4.39.2-vici | Single Server | TDM410P Digium | No additional software on server
lmora
 
Posts: 153
Joined: Wed Jul 01, 2009 7:17 pm
Location: Mexico

Postby lmora » Thu Nov 19, 2009 12:30 pm

This is the contents of /var/log/mysqld.log

091119 10:31:28 mysqld ended

091119 10:34:09 mysqld started
091119 10:34:10 InnoDB: Started; log sequence number 0 61777
091119 10:34:11 [Warning] 'user' entry 'root@vici' ignored in --skip-name-resolve mode.
091119 10:34:11 [Warning] 'user' entry '@vici' ignored in --skip-name-resolve mode.
091119 10:34:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.67' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
Vicibox Redux v.3.1.10 from .iso | Version: 2.4-327c Build: 110510-1637 | Asterisk 1.4.39.2-vici | Single Server | TDM410P Digium | No additional software on server
lmora
 
Posts: 153
Joined: Wed Jul 01, 2009 7:17 pm
Location: Mexico

Postby Op3r » Thu Nov 19, 2009 12:42 pm

LOL,

are you sure about the password?

When you did that mod on your mysql user did you make sure you added a password?
Get paid for US outbound Toll Free calls. PM me. visit https://stopmanualdial.com for vicidial services.
Op3r
 
Posts: 1432
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila

Postby lmora » Thu Nov 19, 2009 12:59 pm

I owe you one Op3r !!

:oops:

indeed! I didn't added the password
just ran the command including the password and operation is up and running again
Vicibox Redux v.3.1.10 from .iso | Version: 2.4-327c Build: 110510-1637 | Asterisk 1.4.39.2-vici | Single Server | TDM410P Digium | No additional software on server
lmora
 
Posts: 153
Joined: Wed Jul 01, 2009 7:17 pm
Location: Mexico


Return to Support

Who is online

Users browsing this forum: contactcentre24x7, Google [Bot] and 85 guests