Page 1 of 1
FWMARIADB 127.0.0.1 connection fail *Solved*
Posted: Fri Sep 07, 2018 4:38 am
by 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.
Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 4:47 am
by fraxzi
Hi Dutch,
I use FWH1805/06 with localhost (127.0.0.1) without a glitch in my test environment ...
Just letting you know.
Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 5:12 am
by 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
#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
fraxzi wrote:Hi Dutch,
I use FWH1805/06 with localhost (127.0.0.1) without a glitch in my test environment ...
Just letting you know.
Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 5:59 am
by fraxzi
Hi Dutch,
No Issue here... I only changed the query and connection parameters to match with my test..
Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 11:13 pm
by 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.
