<html><head></head><body> <div><br></div><div dir="auto">Hi Mike,</div><div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">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</div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">73, Uli </div> <div><br></div><div><br></div>Am Sonntag, 17. März 2024 um 13:52, Mike G3YPP <<a class="" href="mailto:Am Sonntag, 17. März 2024 um 13:52, Mike G3YPP <<a href=">mike@g3ypp.uk</a>> schrieb:<blockquote type="cite" class="protonmail_quote"> <style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><div class="WordSection1"><p class="MsoNormal">Hi Uli, </p><p class="MsoNormal">Many thanks for your help. This was the first time that I had tried the one-off install script from GitHub.<br>It did not install libdbd-mysql-perl:amd64.</p><p class="MsoNormal">I installed that – but DXSpider still did not create the database or table in MariaDb</p><p class="MsoNormal">Once I created that manually – by exporting from my operational node – everything started to work fine.</p><p class="MsoNormal">My new node is now working as I would expect.</p><p class="MsoNormal"> </p><p class="MsoNormal">Many thanks for your help. </p><p class="MsoNormal"> </p><p class="MsoNormal">Regards</p><p class="MsoNormal">Mike G3YPP</p><p class="MsoNormal">Sysop for MX0NCA-2</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal">Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows</p><p class="MsoNormal"> </p><div style="mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p style="border:none;padding:0cm" class="MsoNormal"><b>From: </b><a href="mailto:rhaen@pkgbox.de">Ulrich Habel</a><br><b>Sent: </b>17 March 2024 00:51<br><b>To: </b><a href="mailto:mike@g3ypp.uk">mike@g3ypp.uk</a><br><b>Subject: </b>Fwd: [Dxspider-support] Using MariaDB with Debian 12 - Help please</p></div><p class="MsoNormal"> </p><p class="MsoNormal">Sorry, I maybe just replied to the wrong person - there you go</p><p class="MsoNormal"> </p><p class="MsoNormal">73, Uli / DO7HBL</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal">> </p><p class="MsoNormal">> </p><p class="MsoNormal">> </p><p class="MsoNormal">>> Am 16.03.2024 um 16:45 schrieb Iain Philipps via Dxspider-support <dxspider-support@tobit.co.uk>:</p><p class="MsoNormal">>> </p><p class="MsoNormal">>> 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.</p><p class="MsoNormal">>> Yes, the lines in DXVars.pm are set up. But has Maria 10.11 changed the syntax I wonder?</p><p class="MsoNormal">> </p><p class="MsoNormal">> Iain,</p><p class="MsoNormal">> </p><p class="MsoNormal">> 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.</p><p class="MsoNormal">> </p><p class="MsoNormal">> spider/local/DXVars.pm:</p><p class="MsoNormal">> </p><p class="MsoNormal">> # MySQL Section</p><p class="MsoNormal">> $dsn = "dbi:mysql:database=dxcluster;host=localhost";</p><p class="MsoNormal">> $dbuser = "dxcluster";</p><p class="MsoNormal">> $dbpass = "<secret>";</p><p class="MsoNormal">> </p><p class="MsoNormal">> </p><p class="MsoNormal">> Packages:</p><p class="MsoNormal">> </p><p class="MsoNormal">> ii libdbi-perl:amd64 1.643-4</p><p class="MsoNormal">> libdbd-mysql-perl:amd64 4.050-5+b1 </p><p class="MsoNormal">> libdbd-mariadb-perl 1.22-1+b1 </p><p class="MsoNormal">> ii libmariadb3:amd64 1:10.11.6-0+deb12u1 amd64 MariaDB database client library</p><p class="MsoNormal">> ii mariadb-client 1:10.11.6-0+deb12u1 amd64 MariaDB database client binaries</p><p class="MsoNormal">> ii mariadb-client-core 1:10.11.6-0+deb12u1 amd64 MariaDB database core client binaries</p><p class="MsoNormal">> ii mariadb-common 1:10.11.6-0+deb12u1 all MariaDB common configuration files</p><p class="MsoNormal">> ii mariadb-server 1:10.11.6-0+deb12u1 amd64 MariaDB database server binaries</p><p class="MsoNormal">> ii mariadb-server-core 1:10.11.6-0+deb12u1 amd64 MariaDB database core server files</p><p class="MsoNormal">> </p><p class="MsoNormal">> </p><p class="MsoNormal">> Regards,</p><p class="MsoNormal">> Uli</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal"> </p></div></blockquote></body></html>