+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Trouble with ispcp-rqst-mngr (/thread-15138.html)
RE: Trouble with ispcp-rqst-mngr - joximu - 10-08-2011 07:10 AM
logging in mysql - see /etc/mysql/my.cnf
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
I cannot help - you have to find out why the perl programm cannot connect to mysql.
Is it a socket thing, is it a port thing... ???
Also try to stop mysql and see if theres a different error message.
Maybe there's a way to get a return code in the perl part where the connection is built up...
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-09-2011 01:14 AM
well, i enable MySQL logging and nothing gets logged. This tells me there is something wrong with the script. Any thoughts there? It used to work, then I did some things and the PHP stopped working. I fixed that by restoring the original isp configuration file and rebuilding the password. Please let me know if there is anything you can think of.
RE: Trouble with ispcp-rqst-mngr - joximu - 10-10-2011 06:14 PM
Hi
hm - a big fish...
ok, next, I'd use a sniffer (like tcpdump) to "see" what happens on the ports.
You may need to reduces the ports and ip addresses to get only the wanted traffic.
normally a
tcpdump -i localhost -w tcp.log -s0 port 3306
should do it - but maybe you also check ip "127.0.0.1" and maybe you check without exact port...
I have no idea why it doen't connect.
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-12-2011 04:10 AM
would a reinstall give me a problem with my database being wiped and my current information removed?
RE: Trouble with ispcp-rqst-mngr - joximu - 10-12-2011 08:31 AM
normally not.
But always:
Be sure to backup the db-key files and to backup the data (db, files, /etc etc)
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-20-2011 01:08 AM
okay, I guess I will start the journey of trying to fix this again.
There are no other ideas as to why I am getting the SQL connection error in the doHashSQL() function?
Here is one, how can I change the IP it is attempting to connect to? I would like to test changing 127.0.0.1 to localhost and see if that does anything.
RE: Trouble with ispcp-rqst-mngr - joximu - 10-20-2011 08:38 AM
change here:
/etc/ispcp/ispcp.conf
DATABASE_TYPE = mysql
DATABASE_HOST = localhost
DATABASE_NAME = ispcp
DATABASE_PASSWORD = xxx==
DATABASE_USER = ispcp-root
/J
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-24-2011 09:48 PM
joximu, If the PHP side is working, would that not be pulling from the same spot as the Perl side?
RE: Trouble with ispcp-rqst-mngr - joximu - 10-24-2011 10:49 PM
Hm, Perl and PHP have different libraries...
normally it works whatever cleint you use (command line, perl, php etc etc) if you use always the same credentials (host, username, password and client-ip)...
But - well... you never know... since you already tried alot, I would not say for sure that php-mysql and perl-mysql is exactly the same...
You got me?
/Joxi
RE: Trouble with ispcp-rqst-mngr - ewestlake - 10-25-2011 01:42 AM
is there a way to escalate this issue?