You can use yast to install the package perl-Net-DNS. Then you don't have to fiddle with the Perl shell to install that module.
You can install all the packages with yast. Just start yast, go to the software installation module, search for the package name and install it.
I installed perl-HTML-parser, perl-Net-DNS, and perl-Digest-SHA1 using yast, then did install DB_File using the PERL shell. I got the following: Code: /usr/bin/make install UNINST=1 -- OK rather than Code: /usr/bin/make install -- OK I tried again and got the following: Code: Running install for module DB_File Running make for P/PM/PMQS/DB_File-1.814.tar.gz Is already unwrapped into directory /root/.cpan/build/DB_File-1.814 Has already been processed within this session Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/db-btree....ok t/db-hash.....ok t/db-recno....ok All tests successful. Files=3, Tests=567, 5 wallclock secs ( 2.98 cusr + 0.93 csys = 3.91 CPU) /usr/bin/make test -- OK Running make install Already done
Well, I was able to install ISPConfig. I deleted the database it created and renamed the backup file to replace the database. So, when I log in, the users and stuff are missing. Email still seems to be working, and the sites are still there when I do the following: Code: mysql -u root -p mysql> USE ispconfigdb; mysql> SELECT * FROM isp_isp_web WHERE 1; Nothing's showing up when I log in to ISPConfig.
That's ok. Is the database information in /home/admispconfig/ispconfig/lib/config.inc.php correct? Can you check your ISPConfig database if the tables exist and if there are records in them?
I think the database information is correct: Code: /********************************************** * System Settings **********************************************/ $go_info["server"]["dir_trenner"] = "/"; $go_info["server"]["server_root"] = "/home/admispconfig/ispconfig"; $go_info["server"]["server_url"] = "https://rmmail.rwhm.net:81"; $go_info["server"]["include_root"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."lib"; $go_info["server"]["classes_root"] = $go_info["server"]["include_root"] . $go_info["server"]["dir_trenner"] ."classes"; $go_info["server"]["temp_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."temp"; $go_info["server"]["files_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."files"; $go_info["server"]["backup_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."backup"; $go_info["server"]["version"] = "2.0.7"; $go_info["server"]["os"] = "linux"; $go_info["server"]["ort"] = "local"; $go_info["server"]["banner"] = "0"; $go_info["server"]["db_host"] = "localhost"; $go_info["server"]["db_name"] = "ispconfigdb"; ...And it looks like the tables exist: Code: mysql> USE ispconfigdb; Database changed mysql> SHOW TABLES; +-----------------------+ | Tables_in_ispconfigdb | +-----------------------+ | del_status | | dns_a | | dns_cname | | dns_dep | | dns_isp_dns | | dns_mx | | dns_nodes | | dns_secondary | | dns_spf | | doctype | | groups | | help_documents | | help_nodes | | isp_com | | isp_dep | | isp_dienste | | isp_firewall | | isp_htaccess | | isp_isp_actions | | isp_isp_admin | | isp_isp_datenbank | | isp_isp_domain | | isp_isp_kunde | | isp_isp_reseller | | isp_isp_user | | isp_isp_web | | isp_isp_web_template | | isp_monitor | | isp_nodes | | isp_server | | isp_server_ip | | isp_serverstatus | | isp_traffic | | isp_traffic_ip | | listtype | | login | | multidoc_dep | | multidoc_nodes | | session | | sys_config | | sys_dep | | sys_modules | | sys_news | | sys_nodes | | sys_user | | user_groups | +-----------------------+ 46 rows in set (0.00 sec)
I think so. I used the same username and password as I did originally: Code: /********************************************** * System Settings **********************************************/ $go_info["server"]["dir_trenner"] = "/"; $go_info["server"]["server_root"] = "/home/admispconfig/ispconfig"; $go_info["server"]["server_url"] = "https://rmmail.rwhm.net:81"; $go_info["server"]["include_root"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."lib"; $go_info["server"]["classes_root"] = $go_info["server"]["include_root"] . $go_info["server"]["dir_trenner"] ."classes"; $go_info["server"]["temp_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."temp"; $go_info["server"]["files_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."files"; $go_info["server"]["backup_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."backup"; $go_info["server"]["version"] = "2.0.7"; $go_info["server"]["os"] = "linux"; $go_info["server"]["ort"] = "local"; $go_info["server"]["banner"] = "0"; $go_info["server"]["db_host"] = "localhost"; $go_info["server"]["db_name"] = "ispconfigdb"; $go_info["server"]["db_user"] = "root"; $go_info["server"]["db_password"] = "********"; $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"; $go_info["server"]["postfix_config"] = 1; // 1 = SENDMAIL-STYLE, 2 = POSTFIX-STYLE $go_info["server"]["smtp_restart"] = 1; // 1 = stop/start, 2 = restart $go_info["server"]["network_config"] = 1; // 0 = none, 1 = automatic
This is the output of netstat -tap: Code: rmmail:~ # 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 7525/mysqld tcp 0 0 *:sunrpc *:* LISTEN 3815/portmap tcp 0 0 *:hosts2-ns *:* LISTEN 8436/ispconfig_http tcp 0 0 *:ftp *:* LISTEN 8850/proftpd: (acce tcp 0 0 rmmail.rwhm.net:domain *:* LISTEN 8833/named tcp 0 0 localhost:domain *:* LISTEN 8833/named tcp 0 0 *:ipp *:* LISTEN 4371/cupsd tcp 0 0 *:smtp *:* LISTEN 17640/master tcp 0 0 localhost:953 *:* LISTEN 8833/named tcp 0 0 *:imaps *:* LISTEN 4201/couriertcpd tcp 0 0 *:pop3s *:* LISTEN 4142/couriertcpd tcp 0 0 *:pop3 *:* LISTEN 4144/couriertcpd tcp 0 0 *:imap *:* LISTEN 4187/couriertcpd tcp 0 0 *:www-http *:* LISTEN 4763/httpd2-prefork tcp 0 0 *:ssh *:* LISTEN 3902/sshd tcp 0 0 *:smtp *:* LISTEN 17640/master tcp 0 0 localhost:953 *:* LISTEN 8833/named tcp 0 0 *:https *:* LISTEN 4763/httpd2-prefork tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49745 TIME_WAIT - tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49747 TIME_WAIT - tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49746 TIME_WAIT - tcp 0 2112 rmmail.rwhm.net:ssh dyn-160-39-42-52.:49748 ESTABLISHED 12180/1 tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49737 TIME_WAIT - tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49736 TIME_WAIT - tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49741 TIME_WAIT - tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49740 TIME_WAIT - tcp 0 0 rmmail.rwhm.net:pop3 dyn-160-39-42-52.:49735 TIME_WAIT . . . and this is what is in the error log: Code: Fri Sep 8 09:48:52 2006] [notice] Apache/1.3.33 (Unix) PHP/5.0.4 mod_ssl/2.8.23 OpenSSL/0.9.8 configured -- resuming normal operations [Fri Sep 8 09:48:52 2006] [notice] Accept mutex: sysvsem (Default: sysvsem) [Fri Sep 8 09:54:07 2006] [error] mod_ssl: SSL handshake failed (server rwhm.net:81, client 160.39.42.219) (OpenSSL library error follows) [Fri Sep 8 09:54:07 2006] [error] OpenSSL: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate [Hint: Subject CN in certificate not server name or identical to CA!?] [Fri Sep 8 09:55:07 2006] [error] mod_ssl: SSL handshake failed (server rwhm.net:81, client 160.39.42.219) (OpenSSL library error follows) [Fri Sep 8 09:55:07 2006] [error] OpenSSL: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate [Hint: Subject CN in certificate not server name or identical to CA!?] [Fri Sep 8 09:55:48 2006] [error] mod_ssl: SSL handshake interrupted by system [Hint: Stop button pressed in browser?!] (System error follows) [Fri Sep 8 09:55:48 2006] [error] System: Connection reset by peer (errno: 104) [Fri Sep 8 09:55:55 2006] [error] mod_ssl: SSL handshake interrupted by system [Hint: Stop button pressed in browser?!] (System error follows) [Fri Sep 8 09:55:55 2006] [error] System: Connection reset by peer (errno: 104) [Fri Sep 8 09:56:06 2006] [error] mod_ssl: SSL handshake failed (server rwhm.net:81, client 160.39.42.219) (OpenSSL library error follows) [Fri Sep 8 09:56:06 2006] [error] OpenSSL: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate [Hint: Subject CN in certificate not server name or identical to CA!?] [Fri Sep 8 09:57:21 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 09:57:22 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 09:57:26 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 09:57:27 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 09:57:50 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 10:00:47 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 10:00:50 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 10:00:52 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 10:01:05 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 10:01:44 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 10:02:18 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 17:14:20 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 17:14:22 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 17:14:30 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 17:14:31 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 17:14:44 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Fri Sep 8 17:15:10 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:46:16 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:46:18 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:46:26 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:46:48 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:47:25 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:47:27 2006] [error] [client 160.39.42.219] File does not exist: /home/admispconfig/ispconfig/web/favicon.ico [Sat Sep 9 06:49:48 2006] [error] mod_ssl: SSL handshake failed (server rwhm.net:81, client 160.39.42.219) (OpenSSL library error follows) [Sat Sep 9 06:49:48 2006] [error] OpenSSL: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate [Hint: Subject CN in certificate not server name or identical to CA!?] ~ ~ ~
Something's wrong with ISPConfig's SSL certificate. Please make a new one as described here: http://www.howtoforge.com/forums/showpost.php?p=358&postcount=4
I followed the link and created a new certificate; however, when I login, I still don't see any of my sites. I can check SOME of the email accounts using webmail.
Yes. Then I logged in to ISPConfig, and the sites are still missing. What happens if I add sites (which already exist in the database) using ISPConfig? Will it overwrite what's there?
If the sites where missing in the ISPConfig interface, they are not in the database. But maybe they still exist on your server. I guess ISPConfig will overwrite your sites, but i've never tested it. All old usernames will be locked, yoe must remove them from the file /home/admispconfig/ispconfig/users first.
When I did the following, my sites were still there: Code: mysql -u root -p mysql> USE ispconfigdb; mysql> SELECT * FROM isp_isp_web WHERE 1; I renamed the database, re-installed ISPConfig, then replaced the new database with the renamed database. The sites are still in the database, but I don't see anything in ISPConfig.
They should have been correct in the SQL dump you imported/in your old database... It's hard to tell from here what's wrong with your system.
