Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Jakob Strebel on February 24, 2003, 10:41:23 PM

Title: TWIG mysql installation problem
Post by: Jakob Strebel on February 24, 2003, 10:41:23 PM

Hello Listreaders,
I installed TWIG 2.4.0 on my SME server 5.5. Starting with the test.php3 gives me the following result:
Both IMAP test run ok.
But the SQL test fails with the following message:

Test #1

This SQL test will try and connect to:

Server type: mysql
Server name: localhost
Server port:  
Database name: twig
Database table: twig_global_prefs

If sql is not compiled in to php will generate an undefined function error.


Test result: Error: Access denied for user: 'www@localhost' (Using password: NO)Failed

I see a suspicious empty field for the Server port.

Can anybody point me in the right direction how to hunt and fix the bug.

Thanks
jakob strebel

Title: Re: TWIG mysql installation problem
Post by: Dan Brown on February 24, 2003, 10:52:54 PM

There's no bug, you just need a database user and password.  The twig docs should explain this.  The empty port field is not a problem.

Title: Re: TWIG mysql installation problem
Post by: Jakob Strebel on February 25, 2003, 11:14:55 AM

Dan,
thanks for your quick response.

> There's no bug, you just need a database user and password.

I am wondering where TWIG takes "www" as the username? I cant find this name in the config file.

> The twig docs should explain this.  The empty port field is
> not a problem.

Thanks and best regards

Title: Re: TWIG mysql installation problem
Post by: Dan Brown on February 25, 2003, 05:07:34 PM

Since you haven't entered a username and password, it takes the username it's running as.  Since the web server runs as the user "www", that's what it tries to use for mysql (and fails).