Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 31st July 2005, 00:40
mgburr mgburr is offline
Junior Member
 
Join Date: Jul 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 31st July 2005, 00:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Can you check if the ISPConfig database has been created and if it contains tables? My guess is that your database is empty...
__________________
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
  #3  
Old 31st July 2005, 01:28
mgburr mgburr is offline
Junior Member
 
Join Date: Jul 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 31st July 2005, 07:37
Tribal-Dolphin Tribal-Dolphin is offline
Member
 
Join Date: Jul 2005
Location: Rives - Isère - FRANCE
Posts: 50
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
Reply With Quote
  #5  
Old 31st July 2005, 11:16
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 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
  #6  
Old 31st July 2005, 17:08
mgburr mgburr is offline
Junior Member
 
Join Date: Jul 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #7  
Old 31st August 2008, 07:00
reason8 reason8 is offline
Senior Member
 
Join Date: Aug 2008
Posts: 136
Thanks: 2
Thanked 0 Times in 0 Posts
Default Login problems

Hello and good day.
I just installed ISPConfig on OpenSUSE 11.0 with all components per the installation page. I am having a problem logging into the admin page. It is not taking the login credentials of "username: admin and password:admin".
I have noticed that when I boot my server, I received a warning stating:
Warning: mysql_fetch_aray(): 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 not up and running!"


What could be the problem? I chose SSL for login and have added the https:// to access the site.

Thanks!

Reason
Reply With Quote
  #8  
Old 31st August 2008, 09:57
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

ISPConfig is not correctly installed on your system, please run:

/root/ispconfig/uninstall

to delete it.

Before you install it again, make sure that:

1) No database with the same name exists already that you choose for ispconfig. The installer will create the database itself.
2) That you use the mysql user "rot" to install ispconfig.
3) That the mysql password does not contain any special chars.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 31st August 2008, 11:08
reason8 reason8 is offline
Senior Member
 
Join Date: Aug 2008
Posts: 136
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
ISPConfig is not correctly installed on your system, please run:

/root/ispconfig/uninstall

to delete it.

Before you install it again, make sure that:

1) No database with the same name exists already that you choose for ispconfig. The installer will create the database itself.
2) That you use the mysql user "rot" to install ispconfig.
3) That the mysql password does not contain any special chars.
The problem was that I created a mysql pw using the non a-z and A-Z convention. I was trying to create a strong password. I changed the pw in mysql and was able to get past the admin login but received an error of indicating the config.inc.php file had errors in them.

Now I am trying to uninstall and it is giving me this error:

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!


I have reinstalled and reconfigured this multiple times already but am willing to give it another shot but how can I uninstall and reinstall with out wiping th e OS if it wont uninstall? Thanks for the help!
Reply With Quote
  #10  
Old 31st August 2008, 11:12
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Run:

/etc/init.d/ispconfig_server stop
rm -rf /root/ispconfig
rm -rf /home/admispconfig

then delete the directory that is named like the ispconfig mysql database in /var/lib/mysql/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 07:07.


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