View Single Post
  #1  
Old 15th November 2006, 19:48
Wrongway Wrongway is offline
Junior Member
 
Join Date: Nov 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default SuSE 10.1 - ISPConfig admin/admin login help.

Hello and thanks for the help in advance.

Im very new to Linux and ISPConfig, but quick to learn. Im 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. Im under the assumption that Im having issues with MySql because when I run this /etc/init.d/ispconfig_server restart
I get this-
Quote:
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd stopped
ISPConfig system stopped!
Starting ISPConfig system...
/root/ispconfig/httpd/bin/apachectl startssl: httpd started

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
No results found!ISPConfig system is now up and running!
server:~ #
So, I, vi /root/ispconfig/scripts/lib/config.inc.php to see what line 47 is:
Quote:
if(!$go_info["isp"]["server_conf"] = mysql_fetch_array($server_params)){
Im 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.
Quote:
$go_info["server"]["db_host"] = "localhost";
$go_info["server"]["db_name"] = "information_schema";
$go_info["server"]["db_user"] = "root";
$go_info["server"]["db_password"] = "XXXXXX";
$go_info["server"]["db_type"] = "mysql";
$go_info["server"]["mail_server"] = "";
$go_info["server"]["mail_user"] = "";
$go_info["server"]["mail_password"] = "";
$go_info["server"]["smtp_server"] = "localhost";
$go_info["server"]["mode"] = "";
$go_info["server"]["lang"] = "en";
When I do a mysql u root p
Password xxxxxx then a show databases;
Quote:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| ispconfig_database |
| mysql |
| test |
| tmp |
+--------------------+
5 rows in set (0.00 sec)
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
Reply With Quote
Sponsored Links