HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=15)
-   -   initial admin login incorrect (http://www.howtoforge.com/forums/showthread.php?t=161)

mgburr 31st July 2005 00:40
initial admin login incorrect
 
I installed ISPconfig and finally worked some issues around on Slackware 10.1. Had to trick the installer to make it think it was mandrake 8.1. After installing and checking the original web pages they were o.k. Went to port :81 and got the login page. I tried the initial admin:admin login and keep getting an error with the username. I restarted ispconfig and the mysql d-base server. both start without errors. What I would like to know is there a .htpaccess or .htpasswrd file that can correct that issue or do I need to re-create the mysql dbase file and re-install the system?.

Thank-you.
Mike

falko 31st July 2005 00:48
Can you check if the ISPConfig database has been created and if it contains tables? My guess is that your database is empty...

mgburr 31st July 2005 01:28
I manually created a database. It has no entries. is there a listing of what tables etc that needs to be created. or a "dummy" database that I can copy/import??
Mike

Tribal-Dolphin 31st July 2005 07:37
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.

falko 31st July 2005 11:16
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>', '');

mgburr 31st July 2005 17:08
O.k. I was able to get the tables re-created. after manually creating the isp_server database I did the mysql -uroot -p***** < db_ispsconfig.sql isp_server. That created all the necessary tables. re-started the apache server and the mysql server. Still back at square 1. Found the user admin in the isp_server/sys_user table, viewed the data, then deleted the pasword. restarted the mysqld and still can't verify the user with a null password. i'm using the http vice https access, and operating from the local machine.

Mike

falko 31st July 2005 19:49
Try to put the md5 string of a password into sys_user instead of a null password.

mgburr 31st July 2005 21:16
Still not working. used echo test | md5sum and returned a valid md5hash for the word test. dropped that into the user file for admin and it still doesn't recognize either the password or the user. Almost like the script won't allow the validation of the user with the user database

Mike

falko 31st July 2005 22:37
Quote:
Originally Posted by mgburr
Still not working. used echo test | md5sum and returned a valid md5hash for the word test. dropped that into the user file for admin and it still doesn't recognize either the password or the user. Almost like the script won't allow the validation of the user with the user database

Mike
Does ISPConfig connect to the right database? Please check that in /home/admispconfig/ispconfig/lib/config.inc.php.

mgburr 31st July 2005 22:55
Thank-You,
took me a few to figure it out. was an issue with the database, and also the user that was allowed to access the mysql service. fixed both of those and now it works. Now you can say it works on a Slackware installation. Although it took some tweaking.

Mike


All times are GMT +2. The time now is 22:20.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.