Trouble with ispcp-rqst-mngr

[joximu]

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

[ewestlake]

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.

[joximu]

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

[ewestlake]

would a reinstall give me a problem with my database being wiped and my current information removed?

[joximu]

normally not.

But always:
Be sure to backup the db-key files and to backup the data (db, files, /etc etc)

/J

[ewestlake]

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.

[joximu]

change here:
/etc/ispcp/ispcp.conf

DATABASE_TYPE = mysql
DATABASE_HOST = localhost
DATABASE_NAME = ispcp
DATABASE_PASSWORD = xxx==
DATABASE_USER = ispcp-root

/J

[ewestlake]

joximu, If the PHP side is working, would that not be pulling from the same spot as the Perl side?

[joximu]

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

[ewestlake]

is there a way to escalate this issue?