Android Question [SOLVED]How i will connect to my MariaDB database using MSMariadb (getting Sub NOT FOUND: 'mysql_sta

[Magma]

Hi there - i am trying to connect to my Mariadb sql database... but..

I am getting this :
Sub NOT FOUND: 'mysql_status
not Connected to Database

Maybe didn;t understand well.. i am using the following to connect:

Sub Process_Globals
'These global variables will be declared once when the application starts.
'These variables can be accessed from all modules.
Dim db As MSMaria
end sub

and at activity_create :

db.Initialize("MySQL","192.168.168.3:3036","root","mypass","nameofdatabase") 'MySQL is just a name for sub i believe...


Sub testButton1_Click
db.ExecuteASync("INSERT INTO tracking SET carid='" & carid & "', lat=11, lng=22, speed=33;","")
'tracking is a name of table...
End Sub

Where am i wrong ?




events has the example are the following (ive just copy-paste them):

Sub MySQL_ExecResult(meta As Map)
   Log(meta)
End Sub
Sub MySQL_BatchResult(batch As Map)
   Log(batch)
End Sub
Sub MySQL_QueryResult(data As List, meta As Map)
   'Dim m As Map = meta
   Log("MySQL_QueryResult("&meta&")")
   For i=0 To data.Size-1
     'Log("r:"&data.Get(i))
   Next
End Sub
Sub MySQL_ListTables(tables As List, ms As Long)
   Log("MySQL_ListTables("&ms&"ms)")
   For i=0 To tables.Size-1
     'Log("Table "&tables.Get(i))
   Next
End Sub

 

[DonManfred]

Please use CODE TAGS when posting code
I already said that you need to add the missing event, right?
Why you did not add is manually? You are aware that you CAN DO this?

 

[Magma]

Add mysql_status ---> just that ?

 

[Peter Simpson]

Sub NOT FOUND

This is what the missing sub looks like...

You should type Sub > Space > Tab and select what event that you want to use from the list...

Sub Query_Status(Connected As Boolean, ReConnecting As Boolean, RetriesLeft As Int)

End Sub

 

[DonManfred]

Add the event like any other event you add manually
sub + space + TAB msmaria + TAB

 

[Magma]

Ok i ve understand that i must add mysql_status sub.... because i ve the same name with example (query name)...

But why i am not connected at my db... is at 192.168.168.3:3306 the host ?

 

[DonManfred]

(query name).

use the Eventname like in MySQL.Initialize method (i suggest to go again over the beginners guide and get familar with the language)

 

[Magma]

db.Initialize("MySQL","192.168.168.3:3036","root","mypass","nameofdatabase") 'MySQL is just a name for sub i believe...

it's ok with event name but i am not connected to my db ... i want to connect through my lan... (already test with heidisql at other pc - works)

 

[DonManfred]

Again: use code tags when posting code!

db.Initialize("MySQL","192.168.168.3:3036","root","mypass","nameofdatabase") 'MySQL is the PREFIX of ALL Events of the Lib

->

Sub MySQL_Status(Connected As Boolean, ReConnecting As Boolean, RetriesLeft As Int)
End Sub

Please note that the IP is only accessible from the local network.

 

[Magma]

I said (before) is ok now with the event.

But getting this at log:

Raising.. mysql_status
not Connected to Database
** Activity (main) Resume **
Connected = false

Is it ok to writing the port with the host... ?

 

[Magma]

That was... was the port...

 

[DonManfred]

Is it ok to writing the port with the host... ?

Yes. The Database must accept connections from outside localhost (make sure to not have #skip_networking aktive in MySQL Config.

 

[DonManfred]

That was... was the port...

3306 is the default; not 3036

 

[Magma]

That was my "little" st*pid problem... fast writing can lost your mind...

 

[RenewMe]

Hi, DonManfred from where is it possible to download your MariaDb libray please ?

 

[DonManfred]

from where is it possible to download your MariaDb libray please ?

Nowhere. It isn´t further developed.

The suggested way to connect to any Database is jrdc2.