<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><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></head><body lang=EN-GB link=blue vlink="#954F72" style='word-wrap:break-word'><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><o:p> </o:p></p><p class=MsoNormal>Many thanks for your help. </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards</p><p class=MsoNormal>Mike G3YPP</p><p class=MsoNormal>Sysop for MX0NCA-2</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows</p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='border:none;padding:0cm'><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><o:p> </o:p></p><p class=MsoNormal>Sorry, I maybe just replied to the wrong person - there you go</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>73, Uli / DO7HBL</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></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><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>