#1  
Old 9th September 2010, 17:59
edude03 edude03 is offline
Junior Member
 
Join Date: Sep 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't login after setup.

I followed the perfect server guide to setup ISPConfig on CentOS 5.5 x64. I deviated slightly in the mySQL setup because I already have a dedicated mySQL server that I use for all my databases.

I created a new user called "ispconfig" and gave it all privileges for the host that ispconfig is installed on. The install completed successfully and I can see that it created the database and tables on the mySQL server however whenever I try an login It fails (using admin & admin).

When I look at the error log I see a message that says

Quote:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ispconfig'@'myip' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73, referer: http://web01.mydomain.org:8080/
I tried connection to the DB server from that host and I am able to connect (using mysql -h mydbserver -u ispconfig -p).

Where else could this problem lie?

Thanks.
Reply With Quote
Sponsored Links
  #2  
Old 9th September 2010, 18:42
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,384 Times in 4,231 Posts
Default

If "myip" is not 127.0.0.1 then you entered a wrong IP address during ispconfig installation or the "localhost" line in /etc/hosts points to a wrong IP. Ensure that you entered "localhost" as hostname of the mysql server as you installed ispconfig and that the "localhost" line in /etc/hosts has the IP 127.0.0.1 and no other IP address. Also ensure that you used the mysql user "root" when you install the system, ispconfig has to be bale to create the database and users that it requires. Using a existing oor non root user will cause the setup to fail.

To fix the problems, uninstall ispconfig, install a local mysql server and reinstall ispconfig.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.

Last edited by till; 9th September 2010 at 18:45.
Reply With Quote
  #3  
Old 9th September 2010, 22:37
edude03 edude03 is offline
Junior Member
 
Join Date: Sep 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, that works, however is there any reason I can't use an external server for ISPConfig?
Reply With Quote
  #4  
Old 10th September 2010, 07:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,384 Times in 4,231 Posts
 
Default

Mainly performance reasons. You can use external database servers e.g. for the client databases for the websites but using a external db as main database for ispconfig makes not much sense as it is simply too slow as services like the mail setup and dns are connected to it.
__________________
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Webmail problems with only one domain? compner Installation/Configuration 14 16th February 2010 16:59
rpmbuild -ta courier-imap-4.4.1.tar.bz2 fails joek168 Installation/Configuration 9 2nd April 2009 00:46
dovecot problem sojic Server Operation 21 23rd March 2008 18:22
Problems with Email, courierpop3login: LOGIN FAILED, Ub. 6.06 Perf. Setup+IspC. make-fun Installation/Configuration 3 29th February 2008 10:47
Mail not block oversize in mailbox metaldrummer Installation/Configuration 6 17th December 2007 17:09


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


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