+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: Installation SQL Error (/thread-3045.html)
Installation SQL Error - Standbye - 04-15-2008 04:33 AM
Hi together,
perhaps someone here can help me, im currently trying to install rc4 but i get a problem during the installation.
Code:
Activate AWStats. [no]:
Starting Installation...
ERROR: Unable to connect SQL server !when i start "perl ispcp-setup"
The strange thing is, he creates the database tables (i can see them in the DB) but then gets an error.
Is there any possiblibity to see what went wrong? When i set on debug in the .conf file there isn much more output that helps me.
For information, the database server is another one then the server ispcp is running at. But connections work fine (tried with some test perl db scripts)
thanks in advance
Standbye
edit:
here some more logs
Code:
DEBUG: push_el() sub_name: store_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: store_conf(), msg: Ending...
DEBUG: push_el() sub_name: setup_config(), msg: Ending...
DEBUG: push_el() sub_name: setup_sql(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/usr/bin/mysql --host=somehost --user=root --pass=xxx < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr'), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/usr/bin/mysql --host=somehost --user=root --pass=xxx ispcp < /etc/ispcp/database/languages.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr'), msg: Ending...
DEBUG: push_el() sub_name: del_file(), msg: Starting...
DEBUG: push_el() sub_name: del_file(), msg: Ending...
DEBUG: push_el() sub_name: del_file(), msg: Starting...
DEBUG: push_el() sub_name: del_file(), msg: Ending...
DEBUG: push_el() sub_name: del_file(), msg: Starting...
DEBUG: push_el() sub_name: del_file(), msg: Ending...
DEBUG: push_el() sub_name: crypt_data(), msg: Starting...
DEBUG: push_el() sub_name: gen_rand_num(), msg: Starting...
DEBUG: push_el() sub_name: gen_rand_num(), msg: Ending...
DEBUG: push_el() sub_name: crypt_data(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Unable to connect SQL server !
DEBUG: pop_el() sub_name: doSQL(), msg: ERROR: Unable to connect SQL server !
ERROR: Unable to connect SQL server !RE: Installation SQL Error - gOOvER - 04-15-2008 05:01 PM
Is the MySQL Server working. did you try to restart it?
RE: Installation SQL Error - Standbye - 04-15-2008 05:29 PM
hi,
the server works fine, im currently debugging the perl script step by step already found the first thing (problem was located on my site
there was a missing "flush privileges" access to the iscp user, now trying again.
But would be handy to get out more detailed error messages what went wrong
greetings
Standbye
RE: Installation SQL Error - gOOvER - 04-15-2008 06:22 PM
Which Distro did you use?
RE: Installation SQL Error - Standbye - 04-15-2008 06:27 PM
Hi, ok got it working now,
i use centos 5.1 as xen guestsystem
database server is another guest but also centos 5.1
greetings & thx for response
the problem was located with the missing flush privileges right to the user
so my fault. Just got confused as there was no error message that was specific