FWMARIADB 127.0.0.1 connection fail *Solved*

Post Reply
User avatar
dutch
Posts: 1395
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

FWMARIADB 127.0.0.1 connection fail *Solved*

Post 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.
Imageimage hosting free

The connection other url has no problem.

Thank you in advance.
Last edited by dutch on Fri Sep 07, 2018 11:17 pm, edited 2 times in total.
Regards,
Dutch

FWH 19.01 / 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)
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: FWMARIADB 127.0.0.1 connection fail

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

: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
User avatar
dutch
Posts: 1395
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: FWMARIADB 127.0.0.1 connection fail

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

:wink:
Regards,
Dutch

FWH 19.01 / 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)
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: FWMARIADB 127.0.0.1 connection fail

Post by fraxzi »

Hi Dutch,

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

Image

:)
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
User avatar
dutch
Posts: 1395
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: FWMARIADB 127.0.0.1 connection fail

Post 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.
Regards,
Dutch

FWH 19.01 / 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)
Post Reply