[Dxspider-support] Using MariaDB with Debian 12 - Help please

[U. Habel]

Hi Mike,

Same here - I guess it’s just the way it works. The table isn’t created automagically and I also had to create the table myself using the code from the appropriate Perl module (mysql.pm)? After that the database is running fine ever since then.

I’ve created a documentation for the installation and created an Ansible playbook to install the spider - always wanted to contribute to the wiki. Good reminder - thanks

73, Uli

Am Sonntag, 17. März 2024 um 13:52, Mike G3YPP <[mike at g3ypp.uk](mailto:Am Sonntag, 17. März 2024 um 13:52, Mike G3YPP <<a href=)> schrieb:

> Hi Uli,
>
> Many thanks for your help. This was the first time that I had tried the one-off install script from GitHub.
> It did not install libdbd-mysql-perl:amd64.
>
> I installed that – but DXSpider still did not create the database or table in MariaDb
>
> Once I created that manually – by exporting from my operational node – everything started to work fine.
>
> My new node is now working as I would expect.
>
> Many thanks for your help.
>
> Regards
>
> Mike G3YPP
>
> Sysop for MX0NCA-2
>
> Sent from [Mail](https://go.microsoft.com/fwlink/?LinkId=550986) for Windows
>
> From: [Ulrich Habel](mailto:rhaen at pkgbox.de)
> Sent: 17 March 2024 00:51
> To: mike at g3ypp.uk
> Subject: Fwd: [Dxspider-support] Using MariaDB with Debian 12 - Help please
>
> Sorry, I maybe just replied to the wrong person - there you go
>
> 73, Uli / DO7HBL
>
>>
>
>>
>
>>
>
>>> Am 16.03.2024 um 16:45 schrieb Iain Philipps via Dxspider-support <dxspider-support at tobit.co.uk>:
>
>>>
>
>>> I just can’t get DXSpider to connect to the database. I can connect to the database over the network using ODBC so I guess this is a localhost type issue. I just can’t find it.
>
>>> Yes, the lines in DXVars.pm are set up. But has Maria 10.11 changed the syntax I wonder?
>
>>
>
>> Iain,
>
>>
>
>> I run the same setup as you - and it works flawlessly. My config is below. Have you setup the use dxcluster correctly? Aka, as "dxcluster"@localhost? As you can see I am running a mariadb server; however I am still running the mysql perl client. I wasn’t keen to switch to the new driver so far. Please also ensure to have the libraries installed as below (dbi + dbd). So no issues here.
>
>>
>
>> spider/local/DXVars.pm:
>
>>
>
>> # MySQL Section
>
>> $dsn = "dbi:mysql:database=dxcluster;host=localhost";
>
>> $dbuser = "dxcluster";
>
>> $dbpass = "<secret>";
>
>>
>
>>
>
>> Packages:
>
>>
>
>> ii libdbi-perl:amd64 1.643-4
>
>> libdbd-mysql-perl:amd64 4.050-5+b1
>
>> libdbd-mariadb-perl 1.22-1+b1
>
>> ii libmariadb3:amd64 1:10.11.6-0+deb12u1 amd64 MariaDB database client library
>
>> ii mariadb-client 1:10.11.6-0+deb12u1 amd64 MariaDB database client binaries
>
>> ii mariadb-client-core 1:10.11.6-0+deb12u1 amd64 MariaDB database core client binaries
>
>> ii mariadb-common 1:10.11.6-0+deb12u1 all MariaDB common configuration files
>
>> ii mariadb-server 1:10.11.6-0+deb12u1 amd64 MariaDB database server binaries
>
>> ii mariadb-server-core 1:10.11.6-0+deb12u1 amd64 MariaDB database core server files
>
>>
>
>>
>
>> Regards,
>
>> Uli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20240317/6a16e747/attachment.htm>