SuSE 10.1 - ISPConfig admin/admin login help.

Discussion in 'Installation/Configuration' started by Wrongway, Nov 15, 2006.

  1. Wrongway

    Wrongway New Member

    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…
     
  2. Wrongway

    Wrongway New Member

    Also here is my netstat



    Thanks again,

    WW..
     
  3. falko

    falko Super Moderator ISPConfig Developer

    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?
     
  4. Wrongway

    Wrongway New Member

    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..
     
  5. Wrongway

    Wrongway New Member

    /bump for new viewers
     
  6. falko

    falko Super Moderator ISPConfig Developer

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

    Wrongway New Member

    No special characters.

    Ok, starting that now.
     
  8. Wrongway

    Wrongway New Member

    Questions I'm asked.. I'm sure this is where everything may go bad. My answers are in bold.
     
    Last edited: Nov 17, 2006
  9. Wrongway

    Wrongway New Member

    Here is my MySQL Setup.
     
  10. Wrongway

    Wrongway New Member

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

     
  11. falko

    falko Super Moderator ISPConfig Developer

    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!
     
  12. Wrongway

    Wrongway New Member


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

Share This Page