Installation problems on Lenny

[ralfoertner]

Hello Specialists!

I am having trouble installing under Lenny.

I tried a few times always with the same result.

Starting Installation...
ERROR: Unable to connect SQL server !
casius-backup:/var/www/ispcp/engine/setup#

I tried a few tips from the forum regarding the problem but it did not work.

I'm using lenny 32 bit.

I do not use a password with special characters and I am sure that mysql is running.

Can somebody help please?

[xtc007]

(02-12-2010 09:16 AM)ralfoertner Wrote:  Hello Specialists!

I am having trouble installing under Lenny.

I tried a few times always with the same result.

Starting Installation...
ERROR: Unable to connect SQL server !
casius-backup:/var/www/ispcp/engine/setup#

I tried a few tips from the forum regarding the problem but it did not work.

I'm using lenny 32 bit.

I do not use a password with special characters and I am sure that mysql is running.

Can somebody help please?

Hello,

Your MySQL Server are installed and service started...

do you provide root account to setup?

are you able to connect to mySQL from command line

Your server are configured to use a resolvable fully qualified domain name?

We need a little more information on your problem to really help you

i have 2 servers with debian 5 32 bits fully updated and when you follow all step provided in documentation the installation are very quick and running, all service must be installed first!

Let me know your config and service installed

xtc007
rtmedia.ca

[ralfoertner]

(02-13-2010 01:21 PM)xtc007 Wrote:  

(02-12-2010 09:16 AM)ralfoertner Wrote:  Hello Specialists!

I am having trouble installing under Lenny.

I tried a few times always with the same result.

Starting Installation...
ERROR: Unable to connect SQL server !
casius-backup:/var/www/ispcp/engine/setup#

I tried a few tips from the forum regarding the problem but it did not work.

I'm using lenny 32 bit.

I do not use a password with special characters and I am sure that mysql is running.

Can somebody help please?

Hello,

Your MySQL Server are installed and service started...

do you provide root account to setup?

are you able to connect to mySQL from command line

Your server are configured to use a resolvable fully qualified domain name?

We need a little more information on your problem to really help you

i have 2 servers with debian 5 32 bits fully updated and when you follow all step provided in documentation the installation are very quick and running, all service must be installed first!

Let me know your config and service installed

xtc007
rtmedia.ca

Hello!

First of all thank you for your help!

I made a fresh install of Lenny walked through the installation one more time truely did not miss any step but ended up with the same result.

Welcome to ispCP '1.0.3 OMEGA' Setup Dialog.

This program will set up ispCP OMEGA system on your server.

Next you are asked to enter a "fully qualified hostname" (FQHN).
For more infos read http://en.wikipedia.org/wiki/FQDN.


Please enter a fully qualified hostname. [Casius-Backup.oertner.intra]:

Please enter system network address. [192.168.1.46]:

Please enter the domain name where ispCP OMEGA will run on [admin.casius-backup.oertner.intra]:

Please enter SQL server host. [localhost]:

Please enter system SQL database. [ispcp]:

Please enter system SQL user. [root]:

Please enter system SQL password. [none]:

Please enter ispCP ftp SQL user. [vftp]:

Please enter ispCP ftp SQL user password. [auto generate]:
ispCP ftp SQL user password set to: {hg^USde>s6fIxr24

Please enter ispCP phpMyAdmin Control user. [pma]:

Please enter ispCP phpMyAdmin Control user password. [auto generate]:
phpMyAdmin Control user password set to: R6%^Dmx7F}G$NQYK+DZ

Please enter administrator login name. [admin]:

Please enter administrator password:
Please repeat administrator password:

Please enter administrator e-mail address: administrator@ro-data.de

IP of Secondary DNS. (optional) []:

Use MySQL Prefix.
Possible values: [i]nfront, [b]ehind, [n]one. [none]:

FastCGI Version: [f]cgid or fast[c]gi. [fcgid]:

Activate AWStats. [no]:

Starting Installation...
ERROR: Unable to connect SQL server !
Casius-Backup:/var/www/ispcp/engine/setup#

I can connect to mysql using: mysql -p root -u

The host has a fqdn (I can ping it in any direction)

What more infos do you need? I will provide them immediately.

Thank you!

[kilburn]

Quote:Please enter system SQL password. [none]:

Did you enter your mysql root password here? Are you sure that it's correct? (try connecting directly by executing "mysql -uroot -p").

[xtc007]

--- Yeah, The [none] in password area can be your trouble

when asked, did you type your root password?-----

Sorry Kilburn, i didn't have read your reply carefully before replying

xtc007
RTMedia.ca

[ralfoertner]

(02-14-2010 12:12 PM)xtc007 Wrote:  --- Yeah, The [none] in password area can be your trouble

when asked, did you type your root password?-----

Sorry Kilburn, i didn't have read your reply carefully before replying

xtc007
RTMedia.ca

Hello!

As you can see here it's no problem to connec manual to mysql.

Casius-Backup:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34
Server version: 5.0.51a-24+lenny2+spu1 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

What else could be the problem?

[xtc007]

Hello,

in the setup when asked you are typing the root password?

not just typing enter like the log you are sending

Please enter system SQL user. [root]:

Please enter system SQL password. [none]: "did you type your password here"


i'm not sure your FQHN are ok

http://en.wikipedia.org/wiki/Fully_quali...omain_name

habitually, it's supposed to be addressable from external like somehost.domain.com

xtc007
RTMedia.ca

[ralfoertner]

(02-15-2010 06:16 AM)xtc007 Wrote:  Hello,

in the setup when asked you are typing the root password?

not just typing enter like the log you are sending

Please enter system SQL user. [root]:

Please enter system SQL password. [none]: "did you type your password here"


i'm not sure your FQHN are ok

http://en.wikipedia.org/wiki/Fully_quali...omain_name

habitually, it's supposed to be addressable from external like somehost.domain.com

xtc007
RTMedia.ca

Thank you all!!!

I got it running now!

I am not sure what it was but it seems to be trouble wit h my FQDN settings.

[xtc007]

(02-17-2010 09:24 AM)ralfoertner Wrote:  Thank you all!!!

I got it running now!

I am not sure what it was but it seems to be trouble wit h my FQDN settings.

Great, have fun

xtc007
RTMedia.ca