Android Question [SOLVED] Issues when try to connect to MySQL Database

[GMan]

After running well on anther server i tried to move my databases to a new server.
After changing the depeneding parts, following error came up:

LogCat connected to: X562XXDH78170698
--------- beginning of system
Abfrage OK: Daten geholt
Response from server: Connection refused
main_jobdone (java line: 1091)
java.lang.RuntimeException: JSON Array expected.
    at anywheresoftware.b4a.objects.collections.JSONParser.NextArray(JSONParser.java:62)
    at tricon.amigo.com.main._jobdone(main.java:1091)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:179)
    at anywheresoftware.b4a.keywords.Common$5.run(Common.java:996)
    at android.os.Handler.handleCallback(Handler.java:815)
    at android.os.Handler.dispatchMessage(Handler.java:104)
    at android.os.Looper.loop(Looper.java:207)
    at android.app.ActivityThread.main(ActivityThread.java:5741)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:789)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:679)
java.lang.RuntimeException: JSON Array expected.

Connection refused - but all datas are correct.

Anone an idea what happened / how can i solve this ?
Whats about the rigths of the files on the server ? Does they matter ?

 

[DonManfred]

i tried to move my databases to a new server

and the new server is configured to allow connections from "outside"? I mean does it have NOT set skip-networking to allow connection from outside?
https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_skip-networking

 

[GMan]

Thx DonManfred for the hint - do you have the specified part/MySQL order (on this large side) ?
i got lost when reading all the parts (i am not that MySQL profi)

 

[DonManfred]

do you have the specified part/MySQL order (on this large side) ?

i do not understand

 

[GMan]

The side is full of commands etc. - which one i have to look for ?
And how can i check it on the server - is that listed in the MySQL Adminpage ?

 

[DonManfred]

https://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
See Steps 2 and 3

 

[GMan]

These are the PHP-Settings of the site:

Allgemeine Einstellungen
include_path
.:/opt/plesk/php/5.6/share/pear (Standard)
session.save_path
/var/lib/php5/sessions (Standard)
mail.force_extra_parameters
open_basedir
{WEBSPACEROOT}{/}{:}{TMP}{/}
error_reporting
E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
display_errors
off (Standard)
log_errors
on (Standard)
allow_url_fopen
on
file_uploads
on (Standard)
short_open_tag
off (Standard)

is this

allow_url_fopen
on

the depending one ?

P.S.: maybe it may be helpful if Erel put the sample db (description) in the archiv ?

 

[DonManfred]

These are the PHP-Settings of the site

Why is the php configuration relevant here? The error happens in the mysql-connection or not?
You need to check the MYSQL config. adapt it and restart the mysql-database.

 

[GMan]

Thougth, that the error may be an PHP-error becaus the php script does not connect ;-)
as the server is not "mine" - how can i get access to the config file(s) ?

 

[DonManfred]

as the server is not "mine" - how can i get access to the config file(s) ?

Contact the site admin. Looks like it is not alowed which is the standard. Usually a connection is only allowed from localhost (say, php on the same server for ex.).

Thougth, that the error may be an PHP-error becaus the php script does not connect ;-)

So. What about giving us MORE INFORMATIONS about the REAL SITUATION instead of let us fish for something which may be wrong.

 

[GMan]

Contact the site admin. Looks like it is not alowed which is the standard. Usually a connection is only allowed from localhost (say, php on the same server for ex.).

Already done - the Server must be upgraded, some EUR more each month.

So. What about giving us MORE INFORMATIONS about the REAL SITUATION instead of let us fish for something which may be wrong.

If you dont know what the problem can be you can't give further information, because you dont KNOW

 

[GMan]

Upgraded - works fine