[Dxspider-support] Help on mysql for DX spider

[Phil Taylor]

It is possible that the DSN is incorrectly formatted for your version of Maria/MySql, try my format "dbi:mysql:dbname=xxxxx"  

 

From: Faizul <9m2pju at gmail.com>
Date: Tuesday, 16 January 2024 at 14:41
To: Phil Taylor <phil at m0vse.uk>
Cc: The DXSpider Support list <dxspider-support at tobit.co.uk>
Subject: Re: [Dxspider-support] Help on mysql for DX spider

 

yes i have already setup mariadb listening to default port which is 3306 and manually create database.

but it is not working. nothing written on the database table. even if i restarted dxspider or rebooted.

 

 

On Tue, Jan 16, 2024 at 12:56 AM Phil Taylor <phil at m0vse.uk> wrote:

My (working) config is:

 

$dsn = "dbi:mysql:dbname=dxspider";

$dbuser = "username";

$dbpass = "password";

 

Your config will rely on mysql listening on port 3306 (which it may or may not be doing?). Also the specified user must have permission to create tables etc. on the selected DB (which must be created first).

 

Phil

 

From: Dxspider-support <dxspider-support-bounces at tobit.co.uk> on behalf of Faizul via Dxspider-support <dxspider-support at tobit.co.uk>
Reply to: The DXSpider Support list <dxspider-support at tobit.co.uk>
Date: Monday, 15 January 2024 at 16:33
To: The DXSpider Support list <dxspider-support at tobit.co.uk>
Cc: Faizul <9m2pju at gmail.com>
Subject: [Dxspider-support] Help on mysql for DX spider

 

Hello, 

i have already add 

 

# the SQL database DBI dsn

$dsn = "dbi:mysql:dxcluster:localhost:3306";

$dbuser = "sysop";

$dbpass = "password";

 

but nothing happens. There is no content on mysql dxcluster database.

 

Did I miss something ?

 

 

_______________________________________________ Dxspider-support mailing list Dxspider-support at tobit.co.uk https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20240116/75f3a689/attachment-0001.htm>