<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;}
@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;}
p.gmail-p1, li.gmail-p1, div.gmail-p1
{mso-style-name:gmail-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.gmail-s1
{mso-style-name:gmail-s1;}
p.gmail-p2, li.gmail-p2, div.gmail-p2
{mso-style-name:gmail-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.gmail-s2
{mso-style-name:gmail-s2;}
span.gmail-s3
{mso-style-name:gmail-s3;}
p.gmail-p3, li.gmail-p3, div.gmail-p3
{mso-style-name:gmail-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.gmail-s4
{mso-style-name:gmail-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="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>My (working) config is:<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>$dsn = "dbi:mysql:dbname=dxspider";<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>$dbuser = "username";<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>$dbpass = "password";<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>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></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Phil<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'>Dxspider-support <dxspider-support-bounces@tobit.co.uk> on behalf of Faizul via Dxspider-support <dxspider-support@tobit.co.uk><br><b>Reply to: </b>The DXSpider Support list <dxspider-support@tobit.co.uk><br><b>Date: </b>Monday, 15 January 2024 at 16:33<br><b>To: </b>The DXSpider Support list <dxspider-support@tobit.co.uk><br><b>Cc: </b>Faizul <9m2pju@gmail.com><br><b>Subject: </b>[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><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'>Hello, <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Trebuchet MS",sans-serif'>i have already add <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><p class=gmail-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=gmail-s1><span style='font-size:9.0pt;font-family:Menlo;color:#39C026'># the SQL database DBI dsn</span></span><span style='font-size:9.0pt;font-family:Menlo;color:#39C026'><o:p></o:p></span></p><p class=gmail-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=gmail-s2><span style='font-size:9.0pt;font-family:Menlo;color:#38B9C7'>$dsn</span></span><span class=gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'> = </span></span><span class=gmail-s1><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'>"dbi:mysql:dxcluster:localhost:3306"</span></span><span class=gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'>;</span></span><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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=gmail-s1><span style='font-size:9.0pt;font-family:Menlo;color:#38B9C7'>$dbuser</span></span><span class=gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'> = </span></span><span class=gmail-s4><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'>"sysop"</span></span><span class=gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'>;</span></span><span style='font-size:9.0pt;font-family:Menlo;color:#38B9C7'><o:p></o:p></span></p><p class=gmail-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=gmail-s2><span style='font-size:9.0pt;font-family:Menlo;color:#38B9C7'>$dbpass</span></span><span class=gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'> = </span></span><span class=gmail-s1><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'>"password"</span></span><span class=gmail-s3><span style='font-size:9.0pt;font-family:Menlo;color:black'>;</span></span><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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'><br><br></span><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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=gmail-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><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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'><br><br></span><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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'><br><br></span><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p><p class=gmail-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><span style='font-size:9.0pt;font-family:Menlo;color:#AAAB25'><o:p></o:p></span></p></div></div><p class=MsoNormal>_______________________________________________ Dxspider-support mailing list Dxspider-support@tobit.co.uk https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support <o:p></o:p></p></div></body></html>