FWMARIADB 127.0.0.1 connection fail *Solved*

[dutch]

I've used 1805 to connect 127.0.0.1 without problem. After I update FWH1806 and connect to 127.0.0.1. It has got an error as picture.
image hosting free

The connection other url has no problem.

Thank you in advance.

[fraxzi]

Hi Dutch,

I use FWH1805/06 with localhost (127.0.0.1) without a glitch in my test environment ...
Just letting you know.

[dutch]

Dear Fraxzi,

This is my samples testlost.prg. It works on 1805 and doesn't work for 1806. Could you try in yours localhost.

Code: Select all  Expand view

#include 'fivewin.ch'

static oCn

function main
local oDlg, oBtn

DEFINE DIALOG oDlg FROM 0, 0 TO 400, 400 PIXEL

@  10, 10 BUTTON oBtn PROMPT 'Read Db' SIZE 50, 50 PIXEL ACTION ConnDb()

ACTIVATE DIALOG oDlg CENTER

return nil

Procedure ConnDb
local oRs
WaitPeriod(5000)
do while WaitPeriod()
   TRY
      oRs := Db():rowset('select * from formty')
   CATCH
      MsgWait('connection lost',,3) 
   END
   if valtype( oRs ) = 'U'  
      // oCn := Db(.T.)
   else
      exit
   end
end

XBROWSER oRs
oRs:End()

return

*------------*
Function Db(lConn)
default lConn := .F.
 
if oCn == nil .or. oCn:Ping() = .F. .or. lConn
   MsgRun( "Connecting to Server", "CLOUD SERVER", ;
      { || oCn   := maria_Connect(  {'127.0.0.1', 'data', 'root', 'password', 3306 } ) } )

endif
return oCn

Hi Dutch,

I use FWH1805/06 with localhost (127.0.0.1) without a glitch in my test environment ...
Just letting you know.

[fraxzi]

Hi Dutch,

No Issue here... I only changed the query and connection parameters to match with my test..

[dutch]

Dear Frazxi,

Thank you so much for your help testing. I found this issue, it is MySql in my laptop is old version (MySql 5.1). It is working well after reinstall new version. The FWH1806 has new MESSAGE, LOCALE config in maria_connect(). That why it does effect with old MySql 5.1.

Thanks once again.