#1  
Old 16th May 2011, 10:40
menganito menganito is offline
Junior Member
 
Join Date: May 2011
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
Unhappy Can't login (w/ remote MySQL)

I've installed ISPConfig3 according to http://www.howtoforge.com/perfect-se...64-ispconfig-3, but using two servers: one for web+mail and the other one just contains MySQL.

After installation, I try to log in but I can't it: "Username or Password wrong".
I can connect remotely to MySQL server:

Code:
# mysql -u dbispconfig -p -h 10.0.24.102
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 93
Server version: 5.1.56 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| dbispconfig        |
| mysql              |
+--------------------+
3 rows in set (0.00 sec)
I didn't change any config.inc.php settings:

Code:
# grep db_ /usr/local/ispconfig/server/lib/config.inc.php
$conf['db_type'] = 'mysql';
$conf['db_host'] = '10.0.24.102';
$conf['db_database'] = 'dbispconfig';
$conf['db_user'] = 'dbispconfig';
$conf['db_password'] = 'a65f36082652d86d2032320e04464c73';
$conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")
define('DB_TYPE',$conf['db_type']);
define('DB_HOST',$conf['db_host']);
define('DB_DATABASE',$conf['db_database']);
define('DB_USER',$conf['db_user']);
define('DB_PASSWORD',$conf['db_password']);
define('DB_CHARSET',$conf['db_charset']);
My mysql_clientdb.conf:

Code:
<?php

$clientdb_host                  = '10.0.24.102';
$clientdb_user                  = 'dbispconfig';
$clientdb_password              = '*****';

?>
Any idea to solve it will be appreciated.

Thanks

Last edited by menganito; 16th May 2011 at 11:24. Reason: Added mysql_clientdb.conf
Reply With Quote
Sponsored Links
  #2  
Old 16th May 2011, 12:50
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,505
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
Default

You enterd wrong mysql details while you installed ispconfig. The mysql server of a ispconfig 3 install is defined by its hostname (and not IP address) and the hostname of the local mysql server should be localhost. Thats a system requirement for ispconfig, please see multiserver guides. ISPConfig needs the local mysql database for its own settings and to replicate data.

To fix this, uninstall ISPConfig by using the uninstall.php script which can be found in the install folder and then reinstall ispconfig. When the installer asks you for the hostname of the mysql server, enter "localhost" as the installer suggests.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
menganito (16th May 2011)
  #3  
Old 16th May 2011, 15:39
menganito menganito is offline
Junior Member
 
Join Date: May 2011
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Ok,

I'll install ISPConfig as usual way and then a separated MySQL server, managed via PHPMyadmin.

Thanks.
Reply With Quote
  #4  
Old 16th May 2011, 15:43
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,505
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
 
Default

Quote:
I'll install ISPConfig as usual way and then a separated MySQL server, managed via PHPMyadmin.
I wont recommend that as it does not make much sense to set it up that way. ISPConfig can manage your external mysql server, you just installed ispconfig the wrong way. Please see multiserver setup guide, the guide explains how to install ispconfig with a dedicated mysl server.

http://www.howtoforge.com/installing...th-ispconfig-3
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
menganito (16th May 2011)
Reply

Bookmarks

Tags
connect, error, login, mysql, remote

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
MySQL Error Nolan Installation/Configuration 12 16th February 2011 02:15
Unable to login to MYSQL as root sellotape General 3 2nd December 2010 15:41
Login failed on irtual Users And Domains With Postfix, Courier, MySQL And SquirrelMai dennis00 HOWTO-Related Questions 13 1st May 2009 17:40
emails stopped, ispconfig no login w mysql error Turbanator General 1 2nd February 2009 20:53
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13


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


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