ispCP - Board - Support
ERROR: Unable to connect SQL server ! - Printable Version

+- 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: ERROR: Unable to connect SQL server ! (/thread-7977.html)

Pages: 1 2


ERROR: Unable to connect SQL server ! - nmore - 09-27-2009 01:57 AM

Quote:**:/var/www/ispcp/engine/setup# perl ./ispcp-setup
Generating database keys, it may take some time, please wait...
If it takes to long, please check http://www.isp-control.net/documentation/frequently_asked_questions/what_does_generating_database_keys_it_may_take_some_time_please_wait..._on_setup​_mean

Welcome to ispCP '1.0.2 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. [***.com]: **.com

Please enter system network address. [***]: ***

Please enter the domain name where ispCP OMEGA will run on [admin.***]: ***

Please enter SQL server host. [localhost]: localhost

Please enter system SQL database. [ispcp]: ispcp

Please enter system SQL user. [root]: root

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

Please enter ispCP ftp SQL user. [vftp]: root1

Please enter ispCP ftp SQL user password. [auto generate]:
Please repeat ispCP ftp SQL user password:

Please enter ispCP phpMyAdmin Control user. [pma]: root2

Please enter ispCP phpMyAdmin Control user password. [auto generate]:
Please repeat ispCP phpMyAdmin Control user password:

Please enter administrator login name. [admin]: admin

Please enter administrator password:
Please repeat administrator password:

Please enter administrator e-mail address: ***@gmail.com

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 !
***:/var/www/ispcp/engine/setup# /etc/init.d/mysql status
/usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486
Copyright © 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.51a-24+lenny2
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 hour 33 min 19 sec

Threads: 1 Questions: 226 Slow queries: 0 Opens: 133 Flush tables: 2 Open tables: 1 Queries per second avg: 0.040.
***:/var/www/ispcp/engine/setup#
all carried out under:
http://www.isp-control.net/documentation/doku.php?id=start:installation:debian

what could be wrong?




Quote:*****:/var/www/ispcp/engine/setup# mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] n
... skipping.

By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
... Success!

Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
... Success!

By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
- Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
... Failed! Not critical, keep moving...
- Removing privileges on test database...
... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
... Success!

Cleaning up...



All done! If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!



RE: ERROR: Unable to connect SQL server ! - BeNe - 10-02-2009 04:09 AM

Did you used special chars in the Password ?

Greez BeNe


RE: ERROR: Unable to connect SQL server ! - gamerlv - 11-28-2009 08:10 AM

I have the exact same problem. followed the guide.
I'm however running ubuntu 9.10 with webmin on it. ( if that makes any difference) Also I am one hundert procent sure that the database is up and running correctly, verified by phpmyadmin. Also I of course didn't use any special chars (UTF-8) in anything where it wasn't allowed to be in.

Please help me out here!

Best Regards,
Gamerlv


RE: ERROR: Unable to connect SQL server ! - Gleno0h - 11-28-2009 08:29 AM

I assume you have mysql on localhost and not on external server?(maybe port issue if you do have it external)

If not, restart mysql and try again, make sure you give correct answers.


RE: ERROR: Unable to connect SQL server ! - gamerlv - 11-28-2009 06:31 PM

Its on localhost indeed.
Ill see what I can do about the restarting concern!

Thanks for you reply!


RE: ERROR: Unable to connect SQL server ! - gamerlv - 11-28-2009 08:33 PM

Sorry for double posting but i tried some more ways to get this to work.
I have removed the root password temporally and got this error as a result:
Code:
Starting Installation...
ERROR: External command '/usr/bin/mysql --host="localhost" --user="root" --pass=3ȺOx¨¦" < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '1' status !
I see that it is filling in a password for root, but there is none and i have entered none in the installer.

Hope this helps.


RE: ERROR: Unable to connect SQL server ! - joximu - 11-28-2009 10:01 PM

I'd suggest to change the password - see http://www.isp-control.net/documentation/doku.php?id=howto:ispcp:change_db_pass

/J


RE: ERROR: Unable to connect SQL server ! - gamerlv - 11-29-2009 07:50 AM

(11-28-2009 10:01 PM)joximu Wrote:  I'd suggest to change the password - see http://www.isp-control.net/documentation/doku.php?id=howto:ispcp:change_db_pass

/J
Thank you, that was just what i needed. I now successfully installed ispCP.
But i now see that my ftp isn't working correct. I would welcome any advice you may have. ( i have enabled the mysql modules and changed all that).

--Gamerlv


RE: ERROR: Unable to connect SQL server ! - gOOvER - 11-29-2009 04:57 PM

(11-29-2009 07:50 AM)gamerlv Wrote:  But i now see that my ftp isn't working correct. I would welcome any advice you may have. ( i have enabled the mysql modules and changed all that).

Maybe this helps:

http://www.isp-control.net/documentation/doku.php?id=solving_proftpd_issues


RE: ERROR: Unable to connect SQL server ! - gamerlv - 11-29-2009 08:17 PM

(11-29-2009 04:57 PM)gOOvER Wrote:  
(11-29-2009 07:50 AM)gamerlv Wrote:  But i now see that my ftp isn't working correct. I would welcome any advice you may have. ( i have enabled the mysql modules and changed all that).

Maybe this helps:

http://www.isp-control.net/documentation/doku.php?id=solving_proftpd_issues

I forgot to say I already did all of that. I get a username correct massage but then says password incorrect.
I just checked the logs again and it said username not found.
I have also tried the method of php5 incorrectly encrypting the password but that didn't help as well. And i can still login with my unix user account.