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
  #11  
Old 31st August 2008, 07:00
reason8 reason8 is offline
Senior Member
 
Join Date: Aug 2008
Posts: 141
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
Sponsored Links
  #12  
Old 31st August 2008, 09:57
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,484
Thanks: 813
Thanked 5,255 Times in 4,121 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
  #13  
Old 31st August 2008, 11:08
reason8 reason8 is offline
Senior Member
 
Join Date: Aug 2008
Posts: 141
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
  #14  
Old 31st August 2008, 11:12
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,484
Thanks: 813
Thanked 5,255 Times in 4,121 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
  #15  
Old 31st August 2008, 23:14
reason8 reason8 is offline
Senior Member
 
Join Date: Aug 2008
Posts: 141
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
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/
I removed the directories but when ispconfig install asks me mysql password, its not allowing me to login. I think it is still remembering the old password. Obviously all of mysql was not removed when I deleted /var/lib/mysql.

I even tried to change the sql password in another login and its not accepting that either.
Reply With Quote
  #16  
Old 1st September 2008, 00:02
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,484
Thanks: 813
Thanked 5,255 Times in 4,121 Posts
Default

You should only remove the ispconfig database from /var/lib/mysql/, nothing more and this has nothing to do with the mysql password.

You can set a new mysql password e.g. with the mysqladmin command.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #17  
Old 1st September 2008, 00:14
reason8 reason8 is offline
Senior Member
 
Join Date: Aug 2008
Posts: 141
Thanks: 2
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by till View Post
You should only remove the ispconfig database from /var/lib/mysql/, nothing more and this has nothing to do with the mysql password.

You can set a new mysql password e.g. with the mysqladmin command.
That is the only db that I removed. Changing the sql pw did not work. So I wiped everything clean and restarting. Thanks.
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 15:30.


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