<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" 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;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 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;}
p.m-2508669248340141847gmail-p1, li.m-2508669248340141847gmail-p1, div.m-2508669248340141847gmail-p1
{mso-style-name:m_-2508669248340141847gmail-p1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.m-2508669248340141847gmail-s1
{mso-style-name:m_-2508669248340141847gmail-s1;}
p.m-2508669248340141847gmail-p2, li.m-2508669248340141847gmail-p2, div.m-2508669248340141847gmail-p2
{mso-style-name:m_-2508669248340141847gmail-p2;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.m-2508669248340141847gmail-s2
{mso-style-name:m_-2508669248340141847gmail-s2;}
span.m-2508669248340141847gmail-s3
{mso-style-name:m_-2508669248340141847gmail-s3;}
p.m-2508669248340141847gmail-p3, li.m-2508669248340141847gmail-p3, div.m-2508669248340141847gmail-p3
{mso-style-name:m_-2508669248340141847gmail-p3;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.m-2508669248340141847gmail-s4
{mso-style-name:m_-2508669248340141847gmail-s4;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>It is possible that the DSN is incorrectly formatted for your version of Maria/MySql, try my format </span>"dbi:mysql:dbname=xxxxx" <span style='mso-fareast-language:EN-US'><o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:12.0pt;color:black'>From: </span></b><span style='font-size:12.0pt;color:black'>Faizul <9m2pju@gmail.com><br><b>Date: </b>Tuesday, 16 January 2024 at 14:41<br><b>To: </b>Phil Taylor <phil@m0vse.uk><br><b>Cc: </b>The DXSpider Support list <dxspider-support@tobit.co.uk><br><b>Subject: </b>Re: [Dxspider-support] Help on mysql for DX spider<o:p></o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'>yes i have already setup mariadb listening to default port which is 3306 and manually create database.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'>but it is not working. nothing written on the database table. even if i restarted dxspider or rebooted.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'><o:p> </o:p></span></p></div></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Tue, Jan 16, 2024 at 12:56 AM Phil Taylor <<a href="mailto:phil@m0vse.uk">phil@m0vse.uk</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>My (working) config is:<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>$dsn = "dbi:mysql:dbname=dxspider";<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>$dbuser = "username";<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>$dbpass = "password";<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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).<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Phil<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:12.0pt;color:black'>From: </span></b><span style='font-size:12.0pt;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><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'>Hello, </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'>i have already add </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'> </span><o:p></o:p></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:9.0pt;font-family:Menlo;color:#39C026'># the SQL database DBI dsn</span></span><o:p></o:p></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:9.0pt;font-family:Menlo;color:#38B9C7'>$dsn</span></span><span class=m-2508669248340141847gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'> = </span></span><span class=m-2508669248340141847gmail-s1><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'>"dbi:mysql:dxcluster:localhost:3306"</span></span><span class=m-2508669248340141847gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'>;</span></span><o:p></o:p></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:9.0pt;font-family:Menlo;color:#38B9C7'>$dbuser</span></span><span class=m-2508669248340141847gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'> = </span></span><span class=m-2508669248340141847gmail-s4><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'>"sysop"</span></span><span class=m-2508669248340141847gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'>;</span></span><o:p></o:p></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:9.0pt;font-family:Menlo;color:#38B9C7'>$dbpass</span></span><span class=m-2508669248340141847gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'> = </span></span><span class=m-2508669248340141847gmail-s1><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'>"password"</span></span><span class=m-2508669248340141847gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'>;</span></span><o:p></o:p></p><p class=m-2508669248340141847gmail-p2 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;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'><o:p> </o:p></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:9.0pt;font-family:Menlo;color:black'>but nothing happens. There is no content on mysql dxcluster database.</span></span><o:p></o:p></p><p class=m-2508669248340141847gmail-p2 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;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'><o:p> </o:p></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:9.0pt;font-family:Menlo;color:black'>Did I miss something ?</span><o:p></o:p></p><p class=m-2508669248340141847gmail-p2 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;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'><o:p> </o:p></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:9.0pt;font-family:Menlo;color:black'> </span><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>_______________________________________________ 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> <o:p></o:p></p></div></div></div></blockquote></div></div></body></html>