5,188 reputation
1133
bio website alexclear.livejournal.com
location Mother Russia
age 37
visits member for 3 years, 11 months
seen yesterday

An experienced software developer with a bit of sysadmin background. Can't dance.


Aug
21
comment Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminal
So basically you need to tweak the [client] section of your my.cnf to set up the correct location of mysqld.sock (it should be /tmp/mysqld.sock I guess). You can't just copy the socket file because it will be recreated in the old location on MySQL restart.
Aug
21
comment Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminal
Most probably MySQL has been installed from sources not via the standard package manager.
Aug
21
answered Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminal
Aug
21
comment Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminal
Please provide dpkg -l | grep mysql output.
Aug
21
comment Install packages that must be self-compiled on CentOS server is a bad practice?
In my opinion RVM is the only way to manage any Ruby environment including production ones (and yes, I do use it in production) currently. And I believe this situation will unlikely change (based on my experience with Java packaging).
Aug
21
answered Install packages that must be self-compiled on CentOS server is a bad practice?
Aug
21
answered Intercepting/blocking outgoing emails from mailx + phpmailer
Aug
16
answered on suse11 executables are run using sh instead of bash. How to change this
Aug
15
comment On Windows machines, what is the typical toolchain for remote maintenance?
Please provide more details, what DB and web servers are you going to use exactly? I believe Apache for Windows is not suitable for even moderate loads so you should probably consider to use IIS.
Aug
14
comment Software raid10 failed with 3 disks
Please provide cat /proc/mdstat output
Aug
13
answered MySQL HA Solutions
Aug
13
comment log slow queries killed before completion
I just tried pt-query-digest --processlist on one of my production hosts, it does not need a log file to work, it watches the live server and records queries from SHOW FULL PROCESSLIST instead. It prints the queries to standard output so if you redirect it to a file you will get a kind of slow log.
Aug
13
comment log slow queries killed before completion
A quote from pt-query-digest manual:Watch SHOW FULL PROCESSLIST and output a log in slow query log format: pt-query-digest --processlist h=host1 --print --no-report
Aug
11
comment OpenVPN not Routing correctly on CentOS 6
tcpdump -i tun0 should work
Aug
11
answered PermGen error in Java, while memory usage seems low
Aug
11
comment OpenVPN not Routing correctly on CentOS 6
Well the counter is 0 not only on the tun0 forwarding rule but on the whole FORWARD chain too. It definitely is not forwarding anything, try sysctl -p to apply sysctl.conf settings.
Aug
11
comment OpenVPN not Routing correctly on CentOS 6
Have you tried to run tcpdump on the VPN server on tun0 and your external interface? BTW a counter on your FORWARD rule is 0, the server does not seem to be forwarding anything from tun0. Are you sure your sysctl.conf has applied properly? What is an output of cat /proc/sys/net/ipv4/ip_forward?
Aug
10
answered log slow queries killed before completion
Aug
10
awarded  Citizen Patrol
Aug
10
revised nagios automation in big scale
edited title