[Dxspider-support] Help on mysql for DX spider

[Faizul]

nothings work

# the SQL database DBI dsn

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

$dbuser = "sysop";

$dbpass = "password";


1;

On Wed, Jan 17, 2024 at 1:37 AM Phil Taylor <phil at m0vse.uk> wrote:

> 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/20240117/b9c8e8f2/attachment.htm>