Topic: TWIG mysql installation problem

[Jakob Strebel]

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

[Dan Brown]

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.

[Jakob Strebel]

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

[Dan Brown]

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).