<div dir="ltr"><div class="gmail_default" style="font-family:trebuchet ms,sans-serif;font-size:small">nothings work</div><div class="gmail_default" style="font-family:trebuchet ms,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:trebuchet ms,sans-serif;font-size:small">
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Menlo;color:rgb(47,180,29)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"># the SQL database DBI dsn</span></p>
<p class="gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Menlo;color:rgb(159,160,28)"><span class="gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(46,174,187)">$dsn</span><span class="gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> = </span><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">"dbi:mysql:dbname=dxcluster"</span><span class="gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">;</span></p>
<p class="gmail-p3" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Menlo;color:rgb(46,174,187)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">$dbuser</span><span class="gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> = </span><span class="gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(159,160,28)">"sysop"</span><span class="gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">;</span></p>
<p class="gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Menlo;color:rgb(159,160,28)"><span class="gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(46,174,187)">$dbpass</span><span class="gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> = </span><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">"password"</span><span class="gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">;</span></p>
<p class="gmail-p4" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:16px"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<p class="gmail-p5" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures">1;</span></p></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jan 17, 2024 at 1:37 AM Phil Taylor <<a href="mailto:phil@m0vse.uk">phil@m0vse.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg6542317720908909027"><div lang="EN-GB" style="overflow-wrap: break-word;"><div class="m_6542317720908909027WordSection1"><p class="MsoNormal"><span>It is possible that the DSN is incorrectly formatted for your version of Maria/MySql, try my format </span>"dbi:mysql:dbname=xxxxx" <span><u></u><u></u></span></p><p class="MsoNormal"><span><u></u> <u></u></span></p><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(181,196,223);padding:3pt 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:12pt;color:black">From: </span></b><span style="font-size:12pt;color:black">Faizul <<a href="mailto:9m2pju@gmail.com" target="_blank">9m2pju@gmail.com</a>><br><b>Date: </b>Tuesday, 16 January 2024 at 14:41<br><b>To: </b>Phil Taylor <<a href="mailto:phil@m0vse.uk" target="_blank">phil@m0vse.uk</a>><br><b>Cc: </b>The DXSpider Support list <<a href="mailto:dxspider-support@tobit.co.uk" target="_blank">dxspider-support@tobit.co.uk</a>><br><b>Subject: </b>Re: [Dxspider-support] Help on mysql for DX spider<u></u><u></u></span></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif">yes i have already setup mariadb listening to default port which is 3306 and manually create database.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif">but it is not working. nothing written on the database table. even if i restarted dxspider or rebooted.<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif"><u></u> <u></u></span></p></div></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Tue, Jan 16, 2024 at 12:56 AM Phil Taylor <<a href="mailto:phil@m0vse.uk" target="_blank">phil@m0vse.uk</a>> wrote:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm"><div><div><div><p class="MsoNormal">My (working) config is:<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">$dsn = "dbi:mysql:dbname=dxspider";<u></u><u></u></p><p class="MsoNormal">$dbuser = "username";<u></u><u></u></p><p class="MsoNormal">$dbpass = "password";<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">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).<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Phil<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(181,196,223);padding:3pt 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:12pt;color:black">From: </span></b><span style="font-size:12pt;color:black">Dxspider-support <<a href="mailto:dxspider-support-bounces@tobit.co.uk" target="_blank">dxspider-support-bounces@tobit.co.uk</a>> on behalf of Faizul via Dxspider-support <<a href="mailto:dxspider-support@tobit.co.uk" target="_blank">dxspider-support@tobit.co.uk</a>><br><b>Reply to: </b>The DXSpider Support list <<a href="mailto:dxspider-support@tobit.co.uk" target="_blank">dxspider-support@tobit.co.uk</a>><br><b>Date: </b>Monday, 15 January 2024 at 16:33<br><b>To: </b>The DXSpider Support list <<a href="mailto:dxspider-support@tobit.co.uk" target="_blank">dxspider-support@tobit.co.uk</a>><br><b>Cc: </b>Faizul <<a href="mailto:9m2pju@gmail.com" target="_blank">9m2pju@gmail.com</a>><br><b>Subject: </b>[Dxspider-support] Help on mysql for DX spider</span><u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif">Hello, </span><u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif">i have already add </span><u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif"> </span><u></u><u></u></p></div><div><p class="m_6542317720908909027m-2508669248340141847gmail-p1" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_6542317720908909027m-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(57,192,38)"># the SQL database DBI dsn</span></span><u></u><u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_6542317720908909027m-2508669248340141847gmail-s2"><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)">$dsn</span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black"> = </span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)">"dbi:mysql:dxcluster:localhost:3306"</span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">;</span></span><u></u><u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p3" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_6542317720908909027m-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)">$dbuser</span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black"> = </span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s4"><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)">"sysop"</span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">;</span></span><u></u><u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_6542317720908909027m-2508669248340141847gmail-s2"><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)">$dbpass</span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black"> = </span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)">"password"</span></span><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">;</span></span><u></u><u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin-right:0cm;margin-bottom:12pt;margin-left:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><u></u> <u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_6542317720908909027m-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">but nothing happens. There is no content on mysql dxcluster database.</span></span><u></u><u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin-right:0cm;margin-bottom:12pt;margin-left:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><u></u> <u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-size:9pt;font-family:Menlo;color:black">Did I miss something ?</span><u></u><u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin-right:0cm;margin-bottom:12pt;margin-left:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><u></u> <u></u></p><p class="m_6542317720908909027m-2508669248340141847gmail-p2" style="margin:0cm;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-size:9pt;font-family:Menlo;color:black"> </span><u></u><u></u></p></div></div><p class="MsoNormal">_______________________________________________ Dxspider-support mailing list <a href="mailto:Dxspider-support@tobit.co.uk" target="_blank">Dxspider-support@tobit.co.uk</a> <a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a> <u></u><u></u></p></div></div></div></blockquote></div></div></div>
</div></blockquote></div>