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-
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)){
|
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.
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…
Recent comments
15 hours 36 min ago
22 hours 17 min ago
1 day 2 hours ago
1 day 3 hours ago
1 day 12 hours ago
1 day 21 hours ago
1 day 22 hours ago
2 days 2 hours ago
2 days 6 hours ago
2 days 6 hours ago