HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   SuSE 10.1 - ISPConfig admin/admin login help. (http://www.howtoforge.com/forums/showthread.php?t=8233)

Wrongway 15th November 2006 19:48

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

Wrongway 15th November 2006 19:54

Also here is my netstat


Quote:

server:~ # netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:mysql *:* LISTEN 19343/mysqld
tcp 0 0 *:sunrpc *:* LISTEN 2070/portmap
tcp 0 0 localhost:novell-zen *:* LISTEN 2130/zmd
tcp 0 0 *:hosts2-ns *:* LISTEN 21700/ispconfig_htt
tcp 0 0 *:ftp *:* LISTEN 9426/proftpd: (acce
tcp 0 0 server.XXXXXX.XXX:domain *:* LISTEN 3345/named
tcp 0 0 localhost:domain *:* LISTEN 3345/named
tcp 0 0 *:smtp *:* LISTEN 9343/master
tcp 0 0 localhost:953 *:* LISTEN 3345/named
tcp 0 0 *:imaps *:* LISTEN 6016/couriertcpd
tcp 0 0 *:pop3s *:* LISTEN 5991/couriertcpd
tcp 0 0 *:pop3 *:* LISTEN 5946/couriertcpd
tcp 0 0 *:imap *:* LISTEN 5961/couriertcpd
tcp 0 0 *:www-http *:* LISTEN 7449/httpd2-prefork
tcp 0 0 *:domain *:* LISTEN 3345/named
tcp 0 0 *:ssh *:* LISTEN 2199/sshd
tcp 0 0 *:smtp *:* LISTEN 9343/master
tcp 0 0 localhost:953 *:* LISTEN 3345/named
tcp 0 0 *:https *:* LISTEN 7449/httpd2-prefork
tcp 0 444 server.XXXXXX.com:ssh 192.168.2.234%3084:vpvc ESTABLISHED 21636/0

Thanks again,

WW..

falko 16th November 2006 15:57

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?

Wrongway 16th November 2006 17:26

Quote:

Originally Posted by falko
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
Quote:

mysql> use ispconfig_database;
Database changed
mysql> show tables;
Empty set (0.00 sec)
I checked /home/admispconfig/ispconfig/lib/config.inc.php? and here is what I have. The root name and password are correct.
Quote:

$go_info["server"]["db_host"] = "localhost";
$go_info["server"]["db_name"] = "ispconfig_database";
$go_info["server"]["db_user"] = "root";
$go_info["server"]["db_password"] = "XXXXXXXXX";
$go_info["server"]["db_type"] = "mysql";
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..

Wrongway 17th November 2006 01:18

/bump for new viewers

falko 17th November 2006 15:04

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

Quote:

Originally Posted by Wrongway
I see that the database ispconfig_database is empty.. how do I populate that?

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

Quote:

Originally Posted by Wrongway
Not sure on the SQL Dump. I just followed the ISPConfig Installation Manual

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

Wrongway 17th November 2006 17:57

Quote:

Originally Posted by falko
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).

No special characters.

Quote:

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

Ok, starting that now.

Wrongway 17th November 2006 18:08

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

Please enter your MySQL server: E.G. localhost - localhost
Please enter your MySQL user: E.G. root - root
Please enter your MySQL password: Your MySQL password - password
Please enter a name for the ISPConfig database: E.g. ispconfigdb - mysql
Please enter the IP address of the ISPConfig web: E.g. 192.168.0.1 - 192.168.2.10 - local IP address of server
Please enter the host name: E.g. www - www
Please enter the domain: E.g. xyz.de - xxxxxx.com
Please select the protocol (http or https (SSL encryption)) to use to access the ISPConfig system: If you want to use your control panel with SSL, select 1. You can then access it under https://www.xyz.de:81. If you want to access it under http://www.xyz.de:81, choose 2. - 2

Wrongway 17th November 2006 18:12

Here is my MySQL Setup.
Quote:

login as: root
Using keyboard-interactive authentication.
Password:
Last login: Fri Nov 17 08:54:07 2006 from 192.168.2.234
Have a lot of fun...
server:~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.18

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.01 sec)

mysql> use mysql
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
17 rows in set (0.01 sec)

mysql>

Wrongway 17th November 2006 18:45

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

Quote:

Connected successfully to MySQL server
Es ist schon eine Datenbank mit dem Namen mysql vorhanden!
ls: /etc/apache2/vhosts.d/*.conf: No such file or directory
ls: /etc/apache2/vhosts.d/*.conf: No such file or directory
Restarting some services...
which: no apachectl in (/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/libexec)
Shutting down mail service (Postfix) done
Starting mail service (Postfix) done
Shutting down mail service (Postfix) done
Starting mail service (Postfix) done
Shutting down ProFTPD Server: done
Starting ProFTPD Server: done
Shutting down ProFTPD Server: done
Starting ProFTPD Server: done
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!FreshClam is already running!
ISPConfig system is now up and running!
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.

and log in:
Username: admin
Password: admin


All times are GMT +2. The time now is 20:45.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.