Current time: 11-16-2024, 09:49 PM Hello There, Guest! (LoginRegister)


Post Reply 
Installation SQL Error
Author Message
Standbye Offline
Newbie
*

Posts: 8
Joined: Apr 2008
Reputation: 0
Post: #1
Installation SQL Error
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 !
(This post was last modified: 04-15-2008 04:47 AM by Standbye.)
04-15-2008 04:33 AM
Find all posts by this user Quote this message in a reply
gOOvER Offline
Banned

Posts: 3,561
Joined: Jul 2007
Post: #2
RE: Installation SQL Error
Is the MySQL Server working. did you try to restart it?
04-15-2008 05:01 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Standbye Offline
Newbie
*

Posts: 8
Joined: Apr 2008
Reputation: 0
Post: #3
RE: Installation SQL Error
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 Wink

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
04-15-2008 05:29 PM
Find all posts by this user Quote this message in a reply
gOOvER Offline
Banned

Posts: 3,561
Joined: Jul 2007
Post: #4
RE: Installation SQL Error
Which Distro did you use?
04-15-2008 06:22 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Standbye Offline
Newbie
*

Posts: 8
Joined: Apr 2008
Reputation: 0
Post: #5
RE: Installation SQL Error
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
04-15-2008 06:27 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)