View Single Post
Old 10th November 2011, 00:50
denpark denpark is offline
HowtoForge Supporter
Join Date: Nov 2011
Location: silicon valley
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts

Falko - Thanks for the reply. While I didn't see any obvious mistakes in the details,..there were a few things that I observed. Please see below.

Originally Posted by falko View Post

Are your database details in /usr/local/ispconfig/server/lib/ and /usr/local/ispconfig/interface/lib/ correct?

here is what i am look at in 'usr/local/ispconfig/server/lib/'

starting at line 63

$conf['db_type'] = 'mysql';
$conf['db_host'] = 'localhost';
$conf['db_database'] = 'dbispconfig';
$conf['db_user'] = 'ispconfig';
$conf['db_password'] = '~';
$conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")
$conf['db_new_link'] = false;
$conf['db_client_flags'] = 0;

here is what i observed:
i looked at the user table of the running mysql instance db and at the user table for the ispconfig entry. I see that in the ispconfig entry, all the *_priv columns are set to 'N'.

Question --
1) Could that be the problem?
2) How to remedy?
3) where in the setup did I go wrong for it to be this way?

4) is the mysql user that is set in the config -- 'ispconfig' the correct user? I see that root user and the sys maintenance users are the only ones where the _priv columns are set to 'Y'.

Thanks in advance,
System Info
  • ISP Config v3.0.4
  • Operating system: Oneiric Ubuntu Server 11.10
  • Kernel: 3.0.0-12-server
  • Processor: Dual Core AMD Athlon(tm) 4450B; 2.3 GHz, 2x512K Cache, x86_64
  • Memory: 4.0 GB
Reply With Quote