FWMARIADB 127.0.0.1 connection fail *Solved*

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

FWMARIADB 127.0.0.1 connection fail *Solved*
Posted: Fri Sep 07, 2018 04:38 AM

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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 04:47 AM

Hi Dutch,

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

:wink:

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 05:12 AM

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 (fw): Select all Collapse

#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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 05:59 AM

Hi Dutch,

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

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: FWMARIADB 127.0.0.1 connection fail
Posted: Fri Sep 07, 2018 11:13 PM

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.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

FiveTech Support Forums

Continue the discussion