iOS Question Why does b4i refuse to establish connection to MySql server?

[jkhazraji]

Why does b4i refuse to establish connection to MySql server? whether remote one or local host, by using the iHttp and iHttpUtils libraries?
..what is wrong?

Process_Globals
.
.
.

Dim iJob As HttpJob
End Sub

Sub connect()
.
.
iJob.Initialize("MyJob",Me)
.
.
  
  iJob.Download2("https://192.168.0.21/DBDir/phpfile.php",Array As String( "key1","val1",  "key2","val1","key3","val3") )
    iJob.GetRequest.SetContentType("text/plain")
End sub

Sub JobDone(Job as HttpJob)
 
    If Job.Success Then

    Dim res As String
     res = Job.GetString
    Dim parser As JSONParser
    parser.Initialize(res)
    Select Job.JobName
            Case "MyJob"
             Dim NAMES As List= parser.NextArray 'returns a list with maps
                For i = 0 To NAMES.Size - 1
                    Dim m As Map
                    m = NAMES.Get(i)
           
             '.....
           log(m.Get("index"))
             Next
   End Select
    Else
        Log("Error ocurred:" & Job.ErrorMessage)
        
    End If
    Job.Release
 .
 .

End Sub

 

[imbault]

Your code doesn't show your issue with your DB, just show a call to your php web service or something like that...
Hard to help you

 

[jkhazraji]

Your code doesn't show your issue with your DB, just show a call to your php web service or something like that...
Hard to help you

Thanks for your reply @imbault
I am making a GET request to the phpfile.php. As the following in a web broswer:
localhost/dir/phpfile.php?key1=val1&key2=val2&key3=val3

 

[OliverA]

You may have a typo either in your program or your example line for accessing it with the browser:

iJob.Download2("https://192.168.0.21/DBDir/phpfile.php"

localhost/dir/phpfile.php?key1=val1&key2=val2&key3=val3

/DBDir/phpfile.php vs /dir/phpfile.php

1) If it is in the program, then change that first and see what happens.
2) If it is in the browser line (and we assume here the program URL is the correct one), then what error is logged with

Log("Error ocurred:" & Job.ErrorMessage)

To re-iterate what @imbault said, you are not accessing MySQL with your program, you are accessing a PHP script that may be accessing a MySQL DB in the background.

 

[jkhazraji]

1. I am accessing MySql through the php file from inside the program by the use of WAMP localhost server on windows 10.
2. I managed to have successful connection by the same method using b4a.
3.

Log("Error ocurred:" & Job.ErrorMessage)

gave the error: 'unknown error, code 0'.
4. I mentioned 'localhost/dir/phpfile.php?key1=val1&key2=val2&key3=val3' just as an example of web browser.
5. I made sure I do not have any typo.
With all of that mentioned, I can not access the DB by establishing connection with MySql through iHttpUtils and iHttp of B4i.

 

[OliverA]

iJob.GetRequest.SetContentType("text/plain")

Why are you setting the content type of the GET request?

 

[jkhazraji]

Why are you setting the content type of the GET request?

It makes no difference..I commented the following line, but no response

'iJob.GetRequest.SetContentType("text/plain")

 

[OliverA]

Just noticed the https. Is the server properly set up? If not, it could be that iOS is bouncing your connection. iOS is a lot stricter in that regard.

 

[jkhazraji]

Just noticed the https. Is the server properly set up? If not, it could be that iOS is bouncing your connection. iOS is a lot stricter in that regard.

I noticed it as well and corrected it to http:// but to no avail

 

[OliverA]

Silly question(s): is your phone on the same network? Is its IP address in the same network as the server you're trying to reach? Can you, on the same device, access the site via Safari?

 

[jkhazraji]

Silly question(s): is your phone on the same network? Is its IP address in the same network as the server you're trying to reach? Can you, on the same device, access the site via Safari?

Yes for all.

 

[OliverA]

Ok try https://httpbin.org/get as the URL and see if you can get a job success. Just modify the code to log a success or failure. Before that could try to "clean" the project and re-run it as is before changing code. Are you using the bridge or how are you installing the app, just curious.

 

[Erel]

Can you post the logs?

Try to disable ATS:

#ATSEnabled: False

 

[jkhazraji]

Can you post the logs?

Try to disable ATS:

#ATSEnabled: False

If I connect to local host the log error message is: unknown error
If to a remote server, it tells me that it is unsecured connection and not allowed by the app policy

 

[jkhazraji]

I disabled the App Transport Security

#ATSEnabled: False

Although, It did not work

 

[Erel]

If I connect to local host the log error message is: unknown error

How can you connect to the local host? The local host is the iPhone itself.

If to a remote server, it tells me that it is unsecured connection and not allowed by the app policy

Disabling ATS will solve it.

 

[jkhazraji]

If I enable SSL on my remote server, will it work?

How can you connect to the local host? The local host is the iPhone itself.

Disabling ATS will solve it.

I mean a PC Windows localhost by activating WAMP program. On this server the MySql DB resides.
It did not.

 

[Erel]

If I enable SSL on my remote server, will it work?

It is not needed. If you want me to help you please only answer my questions.

I mean a PC Windows localhost by activating WAMP program.

This is not localhost.

Is this the pc link http://192.168.0.21/DBDir/phpfile.php (not https)?

Is WAMP working on port 80?

Have you opened port 80 in Windows firewall for incoming connections?

 

[jkhazraji]

I was able to operate the same code on b4a without any errors.
First, on the address : 192.168.0.21:80 activating localhost
Then I initialized a HttpJob(MyJob) and used it as

 MyJob.Download("http://192.168.0.21/MyChatApp/server.php?message=getdata&sender=&recep=") 
'Or 
MyJob.Download("http://www.mysite.com/MyChatApp/server.php?message=getdata&sender=&recep=")

from inside b4a
and it worked fine
but the same code after suitable modification did not work in b4i.

 

[Erel]

I'm sorry but I cannot further help you. You are not answering my questions and after 20 posts it is still unclear what you tried and how each attempt failed.
If you like you can start a new thread and post the relevant and accurate information, including the answers to my questions.