reinstalled ISPConfig... And still have the same problem what have I missed any help would be greatfully appriciated there is an MySQL warning but I am not sure is if it's relevent as it says it can connect to the database fine? Code: Connected successfully to MySQL server Es ist schon eine Datenbank mit dem Namen ispconfig vorhanden! Restarting some services... httpd not running, trying to start Stopping Postfix Mail Transport Agent: postfixpostfix: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol postfix: warning: inet_protocols: configuring for IPv4 support only . Starting Postfix Mail Transport Agent: postfixpostfix: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol postfix: warning: inet_protocols: configuring for IPv4 support only . Stopping ftp server: proftpd. Starting ftp server: proftpd. 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.xyz.org.uk:81 and log in: Username: admin Password: admin
I have come accross the log file for the install so I thought it might be of some help Thank you in advanced Code: Wed Sep 12 11:16:34 BST 2007 - [ISPConfig] - installation directory: /downloads/install_ispconfig Wed Sep 12 11:16:34 BST 2007 - [ISPConfig] - operating system: Debian 4.0 Wed Sep 12 11:16:37 BST 2007 - [ISPConfig] - Upgrade einer existierenden ISPConfig-Installation. / Upgrading an existing ISPConfig installation. / Mise à jour d'une installation d'ISPConfig existante. Wed Sep 12 11:16:38 BST 2007 - [ISPConfig] - ISPConfig server stopped Wed Sep 12 11:16:54 BST 2007 - [ISPConfig] - selected language: en Wed Sep 12 11:16:57 BST 2007 - [ISPConfig] - licence accepted Wed Sep 12 11:16:59 BST 2007 - [ISPConfig] - httpd syntax ok! Wed Sep 12 11:16:59 BST 2007 - [ISPConfig] - gcc found: /usr/bin/gcc Wed Sep 12 11:16:59 BST 2007 - [ISPConfig] - make found: /usr/bin/make Wed Sep 12 11:16:59 BST 2007 - [ISPConfig] - flex found: /usr/bin/lex Wed Sep 12 11:16:59 BST 2007 - [ISPConfig] - g++ found: /usr/bin/g++ Wed Sep 12 11:17:02 BST 2007 - [ISPConfig] - Directory /var/www/sharedip created. Wed Sep 12 11:17:02 BST 2007 - [ISPConfig] - Use sharedip_index.html_en as SharedIP default page. Wed Sep 12 11:17:02 BST 2007 - [ISPConfig] - saved /home/admispconfig/ispconfig/lib/config.inc.php Wed Sep 12 11:17:02 BST 2007 - [ISPConfig] - saved /home/admispconfig/ispconfig/users Wed Sep 12 11:17:02 BST 2007 - [ISPConfig] - saved /home/admispconfig/ispconfig/adminmail.txt Wed Sep 12 11:17:28 BST 2007 - [ISPConfig] - created backup of directory /root/ispconfig/ Wed Sep 12 11:17:42 BST 2007 - [ISPConfig] - created backup of directory /home/admispconfig/ Wed Sep 12 11:17:42 BST 2007 - [ISPConfig] - deleted directory /root/ispconfig/ Wed Sep 12 11:19:11 BST 2007 - [ISPConfig] - installation directory: /downloads/install_ispconfig Wed Sep 12 11:19:11 BST 2007 - [ISPConfig] - operating system: Debian 4.0 Wed Sep 12 11:19:14 BST 2007 - [ISPConfig] - Neuinstallation eines ISPConfig-Systems. / Installation of a new ISPConfig system. / Installation d'ISPConfig sur un nouveau système. Wed Sep 12 11:19:16 BST 2007 - [ISPConfig] - selected language: en Wed Sep 12 11:19:24 BST 2007 - [ISPConfig] - installation note accepted Wed Sep 12 11:19:25 BST 2007 - [ISPConfig] - licence accepted Wed Sep 12 11:31:17 BST 2007 - [ISPConfig] - installation mode: standard Wed Sep 12 11:31:21 BST 2007 - [ISPConfig] - mail: postfix Wed Sep 12 11:31:21 BST 2007 - [ISPConfig] - dist_mail=postfix ## Wed Sep 12 11:31:22 BST 2007 - [ISPConfig] - dist_mail_log=/var/log/mail.log ## Wed Sep 12 11:31:22 BST 2007 - [ISPConfig] - dist_mail_virtusertable=/etc/postfix/virtusertable ## Wed Sep 12 11:31:22 BST 2007 - [ISPConfig] - dist_mail_local_host_names=/etc/postfix/local-host-names ## Wed Sep 12 11:31:24 BST 2007 - [ISPConfig] - ftp: proftpd Wed Sep 12 11:31:24 BST 2007 - [ISPConfig] - dist_ftp=proftpd ## Wed Sep 12 11:31:24 BST 2007 - [ISPConfig] - dist_ftp_conf=/etc/proftpd.conf ## Wed Sep 12 11:31:24 BST 2007 - [ISPConfig] - dist_ftp_version=standalone ## Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - dist_ftp_log=/var/log/xferlog ## Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - procmail found: /usr/bin/procmail Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - quota found: /usr/bin/quota Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - mysql found: /usr/bin/mysql Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - openssl found: /usr/bin/openssl Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - named found: /usr/sbin/named Wed Sep 12 11:31:25 BST 2007 - [ISPConfig] - iptables found: /sbin/iptables Wed Sep 12 11:31:26 BST 2007 - [ISPConfig] - httpd found: /usr/bin/httpd Wed Sep 12 11:31:26 BST 2007 - [ISPConfig] - httpd syntax ok! Wed Sep 12 11:31:26 BST 2007 - [ISPConfig] - dist_path_httpd_root=/var/www ## Wed Sep 12 11:31:26 BST 2007 - [ISPConfig] - gcc found: /usr/bin/gcc Wed Sep 12 11:31:27 BST 2007 - [ISPConfig] - make found: /usr/bin/make Wed Sep 12 11:31:27 BST 2007 - [ISPConfig] - flex found: /usr/bin/lex Wed Sep 12 11:31:27 BST 2007 - [ISPConfig] - g++ found: /usr/bin/g++ Wed Sep 12 11:31:31 BST 2007 - [ISPConfig] - Directory /var/www/sharedip created. Wed Sep 12 11:31:31 BST 2007 - [ISPConfig] - Use sharedip_index.html_en as SharedIP default page. Wed Sep 12 12:21:37 BST 2007 - [ISPConfig] - unpacked ISPConfig system Wed Sep 12 12:21:37 BST 2007 - [ISPConfig] - moved directory ispconfig_tmp to /root/ispconfig Wed Sep 12 12:25:13 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 962: copied directory scripts to /root/ispconfig/ Wed Sep 12 12:25:13 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 963: copied directory sv to /root/ispconfig/ Wed Sep 12 12:25:13 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 966: copied directory isp to /root/ispconfig/ Wed Sep 12 12:25:13 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 967: copied cronolog to /root/ispconfig/ Wed Sep 12 12:25:13 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 968: copied cronosplit to /root/ispconfig/ Wed Sep 12 12:25:14 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 976: copied ispconfig_server to /etc/init.d Wed Sep 12 12:25:21 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 990: copied directory ispconfig to /home/admispconfig/ispconfig Wed Sep 12 12:25:21 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 991: chown -R admispconfig:admispconfig /home/admispconfig Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 994: chown -R admispconfig:mysql /home/admispconfig/ispconfig/backup Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 995: chmod -R 770 /home/admispconfig/ispconfig/backup Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1027: cp -f /etc/proftpd.conf /etc/proftpd.conf.orig Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - Connected successfully to MySQL server Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - db ispconfig already exists! Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1181: chmod 600 /home/admispconfig/ispconfig/lib/config.inc.php Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1182: chown admispconfig:admispconfig /home/admispconfig/ispconfig/lib/config.inc.php Wed Sep 12 12:25:22 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1238: cp -f /etc/apache2/apache2.conf /etc/apache2/apache2.conf.orig Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1274: create /etc/apache2/vhosts/Vhosts_ispconfig.conf Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1276: create /var/log/httpd/ispconfig_access_log Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 582: /etc/init.d/cron restart Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1327: cp -f /etc/postfix/main.cf /etc/postfix/main.cf.orig Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - virtusertable entry already in /etc/postfix/main.cf Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - mydestination entry already in /etc/postfix/main.cf Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1355: mv -f /etc/Bastille /etc/Bastille.backup_09_12_2007__12_25_13 Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1358: cp -f isp/conf/bastille-firewall.cfg.master /etc/Bastille/bastille-firewall.cfg Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1359: chmod 644 /etc/Bastille/bastille-firewall.cfg Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1381: mv -f /etc/init.d/bastille-firewall /etc/init.d/bastille-firewall.backup_09_12_2007__12_25_13 Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1382: cp -f security/bastille-firewall /etc/init.d Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1383: chmod 700 /etc/init.d/bastille-firewall Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1385: mv -f /sbin/bastille-ipchains /sbin/bastille-ipchains.backup_09_12_2007__12_25_13 Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1386: cp -f security/bastille-ipchains /sbin Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1387: chmod 700 /sbin/bastille-ipchains Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1389: mv -f /sbin/bastille-netfilter /sbin/bastille-netfilter.backup_09_12_2007__12_25_13 Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1390: cp -f security/bastille-netfilter /sbin Wed Sep 12 12:25:23 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1391: chmod 700 /sbin/bastille-netfilter Wed Sep 12 12:25:24 BST 2007 - [ISPConfig] - /downloads/install_ispconfig/install.php, Line 1437: delete /root/ispconfig/dist.inc.php Wed Sep 12 12:25:25 BST 2007 - [ISPConfig] - httpd restart successful Wed Sep 12 12:25:28 BST 2007 - [ISPConfig] - postfix restart successful Wed Sep 12 12:25:36 BST 2007 - [ISPConfig] - file /root/ispconfig/dist.info deleted Wed Sep 12 12:25:42 BST 2007 - [ISPConfig] - directory install_ispconfig deleted Wed Sep 12 12:25:42 BST 2007 - [ISPConfig] - ##############################
more info... Just adding things as I find them not sure weather this is relevent?? Code: s15259242:/home/admispconfig/ispconfig# /etc/init.d/ispconfig_server restart 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! s15259242:/home/admispconfig/ispconfig#
Did you install the mysql database dump manually? If yesm you will have to reinstall ISPConfig and make sure that the database you choose for ISPConfig to install does not exist. ISPConfig will create the database itself.
I followed the howtoforge perfect setup except I added phpmyadmin and I think that I did create the database certanly on the second install it was already there so I have to start over a third time? Thank you in advanced tim
Then you will have to reinstall ISPConfig, but not reinstall the server of course. Run: rm -rf /home/admispconfig rm -rf /root/ispconfig and delete the directory that has the same name then the ispconfig database in the directory /var/lib/mysql/ Then unpack and install ISPConfig again.
so can I after the database hase been installed limit the ispconfig user to the ispconfig database? If you know what I mean limit its privalages to the one database? timm
This is a bad idea because ISPConfig will not be able to create and manage the customer databases anymore.
ok this is fine just as long as I know! I could not find /var/lib/mysql/ispconfig "ispconfig" being my database but I did delete it with phpmyadmin is that enough??
