<div dir="ltr"><div class="gmail_default" style="font-family:trebuchet ms,sans-serif;font-size:small"><div class="gmail_default">yes i have already setup mariadb listening to default port which is 3306 and manually create database.</div><div class="gmail_default">but it is not working. nothing written on the database table. even if i restarted dxspider or rebooted.</div><div class="gmail_default"><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 16, 2024 at 12:56 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="msg-2508669248340141847"><div lang="EN-GB" style="overflow-wrap: break-word;"><div class="m_-2508669248340141847WordSection1"><p class="MsoNormal"><span>My (working) config is:<u></u><u></u></span></p><p class="MsoNormal"><span><u></u> <u></u></span></p><p class="MsoNormal"><span>$dsn = "dbi:mysql:dbname=dxspider";<u></u><u></u></span></p><p class="MsoNormal"><span>$dbuser = "username";<u></u><u></u></span></p><p class="MsoNormal"><span>$dbpass = "password";<u></u><u></u></span></p><p class="MsoNormal"><span><u></u> <u></u></span></p><p class="MsoNormal"><span>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></span></p><p class="MsoNormal"><span><u></u> <u></u></span></p><p class="MsoNormal"><span>Phil<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">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<u></u><u></u></span></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, <u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-size:12pt;font-family:"Trebuchet MS",sans-serif">i have already add <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><p class="m_-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_-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(57,192,38)"># the SQL database DBI dsn</span></span><span style="font-size:9pt;font-family:Menlo;color:rgb(57,192,38)"><u></u><u></u></span></p><p class="m_-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_-2508669248340141847gmail-s2"><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)">$dsn</span></span><span class="m_-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black"> = </span></span><span class="m_-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_-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">;</span></span><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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_-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)">$dbuser</span></span><span class="m_-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black"> = </span></span><span class="m_-2508669248340141847gmail-s4"><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)">"sysop"</span></span><span class="m_-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">;</span></span><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)"><u></u><u></u></span></p><p class="m_-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_-2508669248340141847gmail-s2"><span style="font-size:9pt;font-family:Menlo;color:rgb(56,185,199)">$dbpass</span></span><span class="m_-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black"> = </span></span><span class="m_-2508669248340141847gmail-s1"><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)">"password"</span></span><span class="m_-2508669248340141847gmail-s3"><span style="font-size:9pt;font-family:Menlo;color:black">;</span></span><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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"><br><br></span><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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_-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><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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"><br><br></span><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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"><br><br></span><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></p><p class="m_-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><span style="font-size:9pt;font-family:Menlo;color:rgb(170,171,37)"><u></u><u></u></span></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>