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#

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!

(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

(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).

(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