View Single Post
  #5  
Old 31st July 2005, 11:16
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by Tribal-Dolphin
The file db_ispconfig.sql is on the root directory of the ISPConfig archive.
The installer normally delete this dir after install.
Untar again the archive and dump the file to our mysql database.
But that won't help because in the SQL dump the table isp_server is empty. It is filled by the installer on the fly. There should only be one entry in isp_server, like this:

Quote:
INSERT INTO `isp_server` (`doc_id`, `doctype_id`, `server_host`, `server_domain`, `server_ip`, `server_netzmaske`, `server_sprache`, `server_db_type`, `server_db_user`, `server_db_passwort`, `server_path_httpd_conf`, `server_path_httpd_root`, `server_httpd_user`, `server_httpd_group`, `server_path_frontpage`, `server_path_httpd_error`, `server_name`, `server_mta`, `server_sendmail_virtuser_datei`, `server_sendmail_cw`, `server_ftp_typ`, `server_proftpd_conf_datei`, `server_proftpd_log`, `server_bind_user`, `server_bind_group`, `server_bind_named_conf`, `server_bind_zonefile_dir`, `userid_von`, `groupid_von`, `passwd_datei`, `group_datei`, `server_ipliste`, `shadow_datei`, `server_bind_ns1_default`, `server_bind_ns2_default`, `server_path_httpd_log`, `server_soap_ip`, `server_soap_port`, `server_soap_encoding`, `server_admin_email`, `server_bind_standard_mx`, `server_bind_adminmail_default`, `server_mail_log_save`, `server_ftp_log_save`, `server_httpd_suexec`, `dist`, `dist_init_scripts`, `dist_runlevel`, `dist_smrsh`, `dist_shells`, `dist_bind_init_script`, `dist_bind_pidfile`, `dist_bind_hintfile`, `dist_bind_localfile`, `dist_cron_daemon`, `dist_cron_tab`, `dist_mysql_group`, `dist_httpd_daemon`, `dist_pop3`, `dist_pop3_version`, `dist_ftp_version`, `dist_httpd_conf`, `dist_mail_log`, `use_maildir`, `virusadmin`, `spamfilter_enable`, `server_enable_frontpage`, `client_salutatory_email_sender_email`, `client_salutatory_email_sender_name`, `client_salutatory_email_bcc`, `client_salutatory_email_subject`, `client_salutatory_email_message`, `res_salutatory_email_sender_email`, `res_salutatory_email_sender_name`, `res_salutatory_email_bcc`, `res_salutatory_email_subject`, `res_salutatory_email_message`, `standard_index`, `user_standard_index`) VALUES (1, 1010, 'server1', 'example.com', '1.2.3.4', '255.255.255.0', 'de', 'mysql', 'root', 'db_password', '/etc/apache', '/var/www', 'www-data', 'www-data', '/usr/local/frontpage/version5.0/bin/owsadm.exe', '', 'Server 1', 'postfix', '/etc/postfix/virtusertable', '/etc/postfix/local-host-names', 'proftpd', '/etc/proftpd.conf', '/var/log/xferlog', 'root', 'root', '/etc/bind/named.conf', '/etc/bind', '10000', '10000', '/etc/passwd', '/etc/group', '', '/etc/shadow', 'ns1.example.com', 'ns2.example.com', '/var/log/httpd/ispconfig_access_log', '', '', '', 'hostmaster@example.com', '0', 'hostmaster@example.com', '0', '0', '1', 'debian30', '/etc/init.d', '/etc', '', '/etc/shells', 'bind9', '/var/run/named.pid', 'db.root', 'db.local', 'cron', '/var/spool/cron/crontabs/root', 'mysql', 'apache', '', '', 'standalone', '/etc/apache/httpd.conf', '/var/log/mail.log', '1', 'abuse@example.com', '1', '0', 'noreply@example.com', 'Example.com Account Changes', 'hostmaster@example.com', 'Your Webhosting Account', 'Dear %%%FIRST_NAME%%% %%%LAST_NAME%%%,\r\n\r\nThank you for having entrusted us with your domain and hosting needs.\r\nYou can now log in to your control panel.\r\n\r\nLogin-URL:\r\n%%%CP%%%\r\n\r\nUsername: %%%USER%%%\r\nPassword: %%%PASSWORD%%%\r\n\r\nThe manual for the control panel can be found here:\r\n%%%MANUAL%%%\r\n\r\nThere are several management functions available from your panel, please do explore and contact us at one of the following addresses should you have any questions regarding them:\r\n\r\nCustomer Service: customerservice@example.com\r\n\r\nTechnical Support: support@example.com\r\n\r\nWe wish you the best with your hosting venture and are hopeful that our business relationship will be both agreeable and profitable.\r\n\r\nWelcome,\r\n\r\nExample.com', 'noreply@example.com', 'Example.com Account Changes', 'hostmaster@example.com', 'Your Reseller Account', 'Dear %%%FIRST_NAME%%% %%%LAST_NAME%%%,\r\n\r\nThank you for having signed up with us as a reseller.\r\nYou can now log in to your control panel.\r\n\r\nLogin-URL:\r\n%%%CP%%%\r\n\r\nUsername: %%%USER%%%\r\nPassword: %%%PASSWORD%%%\r\n\r\nThe manual for the control panel can be found here:\r\n%%%MANUAL%%%\r\n\r\nThere are several management functions available from your panel, please do explore and contact us at one of the following addresses should you have any questions regarding them:\r\n\r\nCustomer Service: customerservice@example.com\r\n\r\nTechnical Support: support@example.com\r\n\r\nWe wish you the best with your hosting venture and are hopeful that our business relationship will be both agreeable and profitable.\r\n\r\nWelcome,\r\n\r\nExample.com', '<html>\r\n<head>\r\n<title>Under Construction</title>\r\n</head>\r\n<body bgcolor=''#FFFFFF'' leftMargin=0 topMargin=0 rightMargin=0 marginheight=''0'' marginwidth=''0''>\r\n<center>\r\n<table border=''0'' width=''100%'' cellspacing=''0''>\r\n <tr>\r\n <td bgcolor=''#DF0029'' align=''center''>\r\n <hr size=''1'' color=''#FFFFFF''>\r\n <table>\r\n <tr>\r\n <td><font size=''3'' color=''#FFFFFF'' face=''Helvetica, Arial''><b>Under Construction\r\n </b></font></td>\r\n </tr>\r\n </table>\r\n <hr size=''1'' color=''#FFFFFF''>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=''#FFFFFF''>\r\n <br><br><center>\r\n <img src=''http://www.example.com/images/under_construction.gif'' width=''209'' height=''166'' border=''0'' alt=''''>\r\n <br><br>\r\n <font color=''#000000'' size=''2'' face=''Helvetica, Arial''>This website is under construction! Please come back again later.\r\n <p>In case of questions or problems please contact the webmaster.</font></center>\r\n <br>\r\n <hr size=''1'' width=''90%''>\r\n <center>\r\n<font size=''1'' color=''#000000'' face=''Verdana, Arial''>Hosting by <a href=''http://www.example.com/'' target=''_blank''>Example.com</a></font>\r\n </center>\r\n </td>\r\n </tr>\r\n</table>\r\n</center>\r\n</body>\r\n</html>', '');
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote