Are you accessing this server locally (not really any need for https if that is the case), or using a fully formed domain name address to do it (e.g. your diskstation is being served up to the internet with an https domain name?)
Have you tried accessing it from another network?
Thank you Tim,
Regards/opowoj
Hello everybody,
my problem is still unsolved: The access to a mysql-database is no longer working from my apps since I changed the domain from http to https. Meanwhile I could avoid the above mentioned error message (Error 301 Movement Permanently) by changing the URL variable from http to https. But there is still no response from my mysql database hosted on my server.
I think, that the solution should be found in the mysql.php (updated from Taifun and adopted by me):
/CONFIG****/
//DATABSE DETAILS//
//$servername = "localhost:/run/mysqld/mysqld10.sock"; falsch!
$servername = "localhost";
$username = "root";
$password = "1August2";
$dbname = "android";
$port = "3307";
$socket = "/run/mysqld/mysqld10.sock";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname, $port, $socket);// Check connection
if (!$conn) {
die("Die Verbindung hat nicht geklappt: " . mysqli_connect_error());
}
//echo "Die Verbindung war erfolgreich!";
/*
$DB_ADDRESS="";
$DB_USER="";
$DB_PASS="";
$DB_NAME="";
/
//SETTINGS//
//This code is something you set in the APP so random people cant use it.
$SQLKEY="bovistwobist";
/CONFIG***/ Rest of program is untouched
I changed the “http” in this php program into “https”, but was not successful. Perhaps Taifun has any idea??
Thank you in advance/opowoj
this returns "page not found"... therefore check your URL... a correct URL returns "Bad request"...
Taifun
Hi Taifun,
thank you for your reply. Meanwhile I changed my Wordpress adress to "https://retslop-subdom5a.synology.me/wp-content/uploads/PHP_SQL-Tests/mysql_neu.php" and indeed, this URL returns "Bad request"... What does this mean?? The adress is correct....
But this does not solve my problem. Before I changed to https, the apps worked with http....
My test app does not report "Bad request". It just does not pick up foto from the database...
opowoj
Which means, the URL is correct...
It returns Bad request if the URL is opened in a browser without providing a sql key.. see also the php script...
Taifun
thank you Taifun.
I beg your pardon, but I don't know, how to open a URL in a browser with providing a sql key. I upload the structure of one of my mysql tables:
In the app blocks I refer to the field "num" which is a key. How shall a change my request? I upload the query block:
I use a URL only to define the adress for the php file. In this php file I defined a sqlkey (see above) in the config part.I use this key in the blocks, see upload: 
What do I wrong or what should I do further??
Regards/opowoj
The php script is to be used by your app and not in a Browser... the Browser test is only to check, if the URL is correct... and Bad request means, it is correct... just continue with your tests in your app
Taifun
Hi Taifun,
meanwhile I continued testing and finally with my simpliest app, I got the following error message:HathaYogaApp_Error_Variables_Block.pdf (1.1 MB) Do you see the wrong detail?
Addition: TABLEIDV3 has 2 fields: Num and Foto; Foto has the structure: https://retslop-subdom5a.synology.me/wp-content/uploads/HiSlider/Papa/YogaÜbungen/dataimages/Papas Yoga-Übungen_01
Thanks in advance/opowoj
My research meanwhile gets the following results:
I can locate my error 1103 by the following:
I hope, that these remarks give any hint for further testing suggestion.....
regards/opowoj
error 1103 unable to post or put
that error appears always or only sometimes?
for the latter see these threads
https://community.appinventor.mit.edu/search?q=error%201103%20unable%20to%20post%20or%20put
Taifun
Thank you Taifun! That error appears always (but only in MITAI2 with sql access) See my last statements...
opowoj
Is it possible, that my domain certificate makes the error?
It is issued
for "retslop-subdom5a.synology.me" and for "retslop-subdom5a.synology.me:443/5001"
(but the 2nd adress is not found!!)
and not for "retslop-subdom5a.synology.me/wp-content/uploads/PHP_SQL-Tests/"
(but I can open "retslop-subdom5a.synology.me/wp-content/uploads/PHP_SQL-Tests/Videos/db_select_videos.html" from an AI2 app, see the upload here 
opowoj
I have no problem in adressing any PHP or HTML file from AI2 (see no 13) , i.e. to open a mysql database. If I continue in PHP, the Select operator works too. So it does not sound logic very much, to be a server problem....
I added "mysqli_set_charset($conn, "utf8");" before the connection statement. But no effect on the query...
Which sounds like a server issue then...
Probably your server is not able to accept Post requests anymore? You might want to ask your Web host support...
Taifun
Hi Taifun,
the server is my own server (hosted on my Synology NAS called Webstation). It is able to accept Post requests from Windows with HTML and PHP, but no longer from AI2. Please see my remarks beginning with 9/18 from Jul 31.
opowoj
sorry, I do not know the answer to your problem
Taifun
15 posts were split to a new topic: Cannot parse text argument to "list from csv table" as CSV-formatted table
according to @opowoj the solution to the problem was
meanwhile I got my Wordpress installation on my host repaired (where I host the mysql.php from Taifun).
closing this thread...
Taifun
