ispconfig login problem

[diehard67]

ok I just setup ispconfig, it said username and password were admin, I tried that and it told me I can't login error 101, how can I manuley change the username and password for isp config

[till]

Have you created the mysql database manually before you installed ISPConfig?

[diehard67]

yes I did, it's empty

[wiremeister]

I'm experiencing the same problem. Setup will locate MySQL, but does not populate the database. I'm noticing a couple of errors at the end of the setup routine:

Connected successfully to MySQL server
Es ist schon eine Datenbank mit dem Namen isp vorhanden!
ls: /etc/httpd/conf.d/*.conf: No such file or directory
ls: /etc/httpd/conf.d/*.conf: No such file or directory
ls: /etc/httpd/conf/vhosts.d/*.conf: No such file or directory
ls: /etc/httpd/conf/vhosts.d/*.conf: No such file or directory
Restarting some services...
Shutting down postfix: [ OK ]
Starting postfix: [ OK ]
Shutting down proftpd: [FAILED]
Starting proftpd: [ OK ]
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!
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.
Please direct your browser to

https://www.example.com:81

and log in:
Username: admin
Password: admin

Till, could use your help with a translation of the German!

Here is also the syntax of /root/ispconfig/scripts/lib/config.inc.php in and around line 47:

/**************************************
* Server Einstellungen
* V1.0 ISPConfig SERVER Modules
***************************************/
$link = @mysql_connect($go_info["server"]["db_host"], $go_info["server"]["db_user"], $go_info["server"]["db_password"])
or die("Could not connect to MySQL server!");
mysql_select_db($go_info["server"]["db_name"]);
$server_params = mysql_query("SELECT * FROM isp_server WHERE doc_id = '".$go_info["isp"]["server_id"]."'");
if(!$go_info["isp"]["server_conf"] = mysql_fetch_array($server_params)){
die("No results found!");
} else {
foreach($go_info["isp"]["server_conf"] as $key => $value) {
$value = trim($value);
while(strlen($value) > 1 && substr($value,-1) == "/") $value = substr($value,0,strlen($value)-1);
$go_info["isp"]["server_conf"][$key] = $value;
}
$key = NULL;
$value = NULL;
}
mysql_free_result($server_params);
$server_params = mysql_query("SELECT server_ip FROM isp_server_ip WHERE server_id = '".$go_info["isp"]["server_id"]."'");
while ($row = mysql_fetch_array($server_params)) {
$ips[] = $row['server_ip'];
}
$go_info["isp"]["server_conf"]["ips"] = $ips;
unset($ips);
mysql_free_result($server_params);
mysql_close($link);

$go_info["modules"]["string"] = "string";
$go_info["modules"]["file"] = "file";
$go_info["modules"]["system"] = "system";
$go_info["modules"]["mail"] = $go_info["isp"]["server_conf"]["server_mta"];
$go_info["modules"]["procmail"] = "procmail";
$go_info["modules"]["dns"] = "bind";

Have tried recompiling severl times. Same result! Help! Had this up and running one time, but server crashed and can't seem to reload. MySQL is set up, with permissions, passwords, etc..

[diehard67]

make a backup copy of the ispconfig dir in the root's home dir, install isp config agane, this puts data in the database but brakes the install, that is wyhy u have to backup first, restore your backup and it should work 4 u

[till]

The ISPConfig installer creates a database during the installation itself, if you create the databse manually, the installation will fail!

run:

/root/ispconfig/uninstall

Delete the database that you created manually and then run the ISPConfig installer again without creating any databases manually!

[till]

Originally Posted by diehard67

make a backup copy of the ispconfig dir in the root's home dir, install isp config agane, this puts data in the database but brakes the install, that is wyhy u have to backup first, restore your backup and it should work 4 u

For the correct installation, please see my post above.

[wiremeister]

Thanks Till!

Deleted the database, and all went fine. Up and running again. Thanks for all your good work!