@maina will try that as soon as am back up since i just edited back; @steven tried that and guess was the genesis of my woes rgds *_______________________________________________________________ We must Keep on, * On Wed, Jul 4, 2012 at 11:35 AM, joe mwirigi <joemwirigi@gmail.com> wrote:
@peter I think all sysadmins will throw rocks at me:( yet i'll not gain martyrdom.
Changed hosts and my tired self, tried to restart the network service, and errors on some postfix files have me locked out and guess the network service has not restarted, just stopped.... this will be a loooong day. .... getting on call to beg for a physical restart. :( . On the brighter side, guess am enthusiastic at trying out options.
Will get back after a reboot;
rgds
*_______________________________________________________________ We must Keep on, *
On Wed, Jul 4, 2012 at 11:06 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
Wait, what about the server real/public IP address? Have you specified in the hosts file if its also similar to localhost?
I am not sure if MySQL error logs record failed log ins, but if it does, maybe the error message can give you a clue as to which host is actually being sent...
And to prevent you from being fired immediately, you can set the host column in mysql.user table to %, as a very temporary measure.
I am not sure if the network service needs a restart after making changes to the hosts file.
On Wed, Jul 4, 2012 at 10:55 AM, gisho <gichuhie@gmail.com> wrote:
i can't help but i checked my my.cnf and there's nothing close to your problem. this is my unmodified .cnf
[root@lenana]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0
[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [root@lenana]#
-erastus
On Wed, Jul 4, 2012 at 10:39 AM, joe mwirigi <joemwirigi@gmail.com>wrote:
@kip,
The pings both return normal, my problem is getting mysql to re-learn that localhost== 127.0.0.1. and actually allow connections from localhost as would from the ip. This affects all apps that have localhost as the 'host'
I also have the paths to mysqld.sock well defined
rgds
*_______________________________________________________________ We must Keep on, *
On Wed, Jul 4, 2012 at 10:29 AM, kipropest <kipropbrian@gmail.com>wrote:
What does ping localhost say.
Also try coffee.
On Wed, Jul 4, 2012 at 8:25 AM, joe mwirigi <joemwirigi@gmail.com>wrote:
Hi All, I encountered a unique problem(to me) While i was setting up remote Mysql Access to a server.
(1). Edited my.cnf to bind at the server address instead of 127.0.0.1 (2). Allowed access from my remote ip on the iptables (3) Added host to mysql and granted access to the database (4) Realized something was wrong all 'localhost' configs could no longer access db -shoot! I reverted to the old my.cnf (5)Hell broke and could no longer access server via localhost as host but can access only though 127.0.0.1 as host.
Stuff I have checked and done (1) /etc/hosts had the directive that localhost is 127.0.0.1 (2) Passwords on mysql user are Ok (3) Reset users,host and passwords but still access denied for user@localhost (4) Restarted mysql n times (5) Drunk lots of tea
My question: How do I make it revert to the Old access where localhost meant 127.0.0.1
Could this be the sockets and TCPIP issue is there hope for getting back?
even a google pointer here is welcome since my eyes are now red (cant tell whether its sleep || 'am so screwed color' || part of the bug
help!
Regards again!
*_______________________________________________________________ We must Keep on, *
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards, Peter Karunyu -------------------
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke