Android Question [Solved]Unable to connect to MySQL-Database on local net.

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #2

opus said:

The File is found (when using it without the "php" in the starting line, the code of the php-file is returned)

Click to expand...

Are you sure the webserver is able to run php scripts?
Sounds like the webserver does not know the extension and does not know what to do. So it is returning the file (as you are requesting the file)

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #3

The Server did run the test using an index.php containing:

B4X:

<?php
Echo "Something";
?>

I did get "Something" when "pointing" the browser the IP of the server

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #4

Ok, then the problem seems the php script...
If you use your browser with the php-url giving the right parameters...

Does it wok in your browser?

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #5

DonManfred said:

Ok, then the problem seems the php script...
If you use your browser with the php-url giving the right parameters...

Click to expand...

?? php-url??
The code line in the b4a example expects beside the ""http://192.168.178.43/countries3.php" the "query" ,whic holds the SQL-String, whow would I put that in the browser??

Sorry, stupid am I!

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #6

I narrowed it down to the connection,
having an Echo before each different line in the PHP file and run just the file from the browser, I got all feedbacks before the "..mysql_connect....".

??

 

Last edited: Feb 6, 2016

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #7

opus said:

before the "..mysql_connect....".

Click to expand...

then you should output the error if the connection can not be established!?

PHP:

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('connection error: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #8

Funny, nothing (new) in the mysql_error.log.
Last entry was:

B4X:

 160206 20:09:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.44-0+debu8u1-log' socket: '/var/run/mysqld/mysqld.sock' port:3306 (Raspbian)

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #9

post your php file (and use code tags)

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #10

B4X:

<?php
Echo "Start";
$databasehost = "localhost";
$databaseusername = "root";
$databasepassword = "opus";
$databasename = "openhab";
Echo "Before Connect";
$con = mysql_connect($databasehost,$databaseusername,$databasepassword);
Echo "After Conect";
mysql_select_db($databasename) or die(mysql_error());

$query = file_get_contents("php://input");
$sth = mysql_query($query);

if (mysql_errno())
{
header("HTTP/1.1 500 Internal Server Error");
echo $query.'\n';
echo mysql_error();
}
else
{
$rows = array();
while($r = mysql_fetch_assoc($sth))
{
$rows[] = $r;
}
print json_encode($rows);
}
?>

Using a browser I only get "StartBefore Connect", in my understanding the connection isn't even tried.

??

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #11

I already said this. Check te connection; if it is not ok log the error...
Last try to help

B4X:

$con = mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #12

@DonManfred:
I'm sorry, the last listing posted was not the one I changed according your suggestion. During all those test, I got mixed up what to post.
The outcome of the test with your suggestion is in my Post#8.
And THANK YOU for the help given so far.
When it comes to MySQL I'm a beginner, I'm sorry for that.
As I see it no connection is made or even tried (no entry in errorlog). When connection to the database from the device on which the database is everything works fine.
In my understanding (which could be wrong) the connection using this php-script would also be done locally. Is that correct?

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #13

add this right after your $con= line

B4X:

if (!$con)  {  die('Could not connect: ' . mysql_error()); }

and tell us the error you get

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #14

Thanks sorex, thats what DonManfred already said. Me stupid didn't put that in the posted listing. I tried that already.
It looks like I'm missing MySQL-Functions in PHP. I'm searching to install those.
Will report back.

Lots of things to learn for me in this one!

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #15

sorex said:

and tell us the error you get

Click to expand...

I already told him :-/

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #16

opus said:

g MySQL-Functions in PHP.

Click to expand...

What version of php are you using?

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #17

I guess you are using PHP 5.5+

This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.

Click to expand...

PHP:

$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'my_db');

/*
* This is the "official" OO way to do it,
* BUT $connect_error was broken until PHP 5.2.9 and 5.3.0.
*/
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}

https://www.google.de/?gws_rd=ssl#q=php deprecated mysql_connect()

http://php.net/manual/en/migration55.deprecated.php

 

Last edited: Feb 6, 2016

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #18

the method you use is outdated but still included in mosts install.

if not then you should use the mysqli methods.

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Feb 6, 2016

• #19

maybe it helps finding the problem

PHP:

<?php
error_reporting(E_ALL); // Add this line in the beginning of your php so see problems based on the code

 

Upvote 0

opus

Active Member

Licensed User

Longtime User

• Feb 6, 2016

• #20

That's it:
"Call to unidentified function mysql_connect().."

Should I use an older PHP-Version or use these "mysqli methods"?

 

Upvote 0