SuSE 10.1 - ISPConfig admin/admin login help.

Hello and thanks for the help in advance.

I’m very new to Linux and ISPConfig, but quick to learn. I’m having some issues during the installation of ISPConfig.

I followed the Perfect Setup to install SuSE 10.1 and everything goes well till I setup ISPConfig using the ISPConfig Manual Installation

I am unable to login to ISPConfig using admin/admin. I’m under the assumption that I’m having issues with MySql because when I run this – /etc/init.d/ispconfig_server restart
I get this-

So, I, vi /root/ispconfig/scripts/lib/config.inc.php to see what line 47 is:

I’m guessing the server conf file is having issues, so I vi /home/admispconfig/ispconfig/lib/config.inc.php to see some of the configuration, and here is my setup.

When I do a mysql –u root –p
Password “xxxxxx’ then a show databases;

use information_schema;
Database changed

mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| KEY_COLUMN_USAGE |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| VIEWS |
| USER_PRIVILEGES |
+---------------------------------------+
16 rows in set (0.00 sec)

That is where I am stuck.

If anyone can help, I would appreciate it.

Thanks again,

WW…

 

Also here is my netstat

Thanks again,

WW..

 

What's the output of

Code:

show tables;

in ispconfig_database? Are the MySQL user (should be root) and password correct in /home/admispconfig/ispconfig/lib/config.inc.php?

Is it possible you manually installed the SQL dump that came with ISPConfig?

 

This is what I have for show tables; using ispconfig_database

I checked /home/admispconfig/ispconfig/lib/config.inc.php? and here is what I have. The root name and password are correct.

I see that the database ispconfig_database is empty.. how do I populate that?

Not sure on the SQL Dump. I just followed the ISPConfig Installation Manual

Thanks alot for the help. I appriciate it.

WW..

 

/bump for new viewers

 

Does your MySQL root password contain special characters? Then you should change it. Special characters have caused problems in the past (there are some threads about this in the forum).

You can't populate it manually. Please remove the empty database and the directories /root/ispconfig and /home/admispconfig and install ISPConfig again.

That's good because you can't install the SQL dump manually.

 

No special characters.

Ok, starting that now.

 

Questions I'm asked.. I'm sure this is where everything may go bad. My answers are in bold.

 

Here is my MySQL Setup.

 

This is what I get after the re-installation.. I still cannot log in.

 

You must specify a database name that doesn't exist yet. mysql is an existing database name, and it's crucial for the functioning of MySQL!

 

Recompiled and it works!!!!.... Thank you VERY much for your help!