Reply to thread

Message

<blockquote data-quote="The_Stig" data-source="post: 1139439" data-attributes="member: 12276">Sooooo...tried a bit around. Did get a bit further, but not working.What I have working so far is a simple php activating and deactivating it. Had to change the script I posted here, because this did not work (don't know why). This one works (and yes, I know, the if else isn't nice, but I don't know how to remove it ;-)[CODE]&lt;?php//Authentication$json = file_get_contents('http://IP:PORT/webapi/auth.cgi?api=SYNO.API.Auth&amp;method=Login&amp;version=3&amp;account=user&amp;passwd=PASSWORD&amp;session=SurveillanceStation&amp;format=sid');$obj = json_decode($json, true);$sid = $obj[&quot;data&quot;][&quot;sid&quot;];//GetList$json = file_get_contents('http://IP:PORT/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=List&amp;version=3&amp;_sid='.$sid);$obj = json_decode($json, true);$cam_activated = $obj[&quot;data&quot;][&quot;cameras&quot;][0][&quot;enabled&quot;];if($cam_activated == false){&nbsp; &nbsp; //Deactivate cam&nbsp; &nbsp; $json = file_get_contents('http://IP:PORT/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=Enable&amp;version=3&amp;cameraIds=2&amp;_sid='.$sid);&nbsp; &nbsp; echo &quot;&lt;div class=\&quot;centered\&quot;&gt;&lt;img src=\&quot;http://192.168.178.99:5000/on_icon.png\&quot; style=\&quot;width:auto;height:auto;\&quot; /&gt;&lt;/div&gt;&quot;;}else{&nbsp; &nbsp; //Deactivate cam&nbsp; &nbsp; $json = file_get_contents('http://IP:PORT/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=Enable&amp;version=3&amp;cameraIds=2&amp;_sid='.$sid);&nbsp; &nbsp; echo &quot;&lt;div class=\&quot;centered\&quot;&gt;&lt;img src=\&quot;https://externeAdresse:Port/off_icon.png\&quot; /&gt;&lt;/div&gt;&quot;;}?&gt;[/CODE]What I've done in php is this:[ATTACH=full]165543[/ATTACH]I guess some of the types are wrong?And I have this now as php script:[CODE]&lt;?php$httpformat=&quot;http&quot;; //hier angeben ob http oder https$port=&quot;5000&quot;; //port$loginname=&quot;administrator&quot;; //Loginname an der Surveillance Station$passwd=&quot;Password&quot;; //passwort an der Surveillance Station$ip=&quot;IP&quot;; //ip adresse der Surveillance station im LAN$cam_id=&quot;2&quot;; // Kamera ID mit script &quot;hole Kamera ID&quot; abfragen, später automatisieren// db$db_name = &quot;root&quot;;$db_pw = &quot;Password&quot;;$db_database = &quot;Surveillance&quot;;$db_table = &quot;user&quot;;$db_ip = &quot;127.0.0.1&quot;;// activate Surveillance$surveillance = true;// connect to db$connection = mysql_connect(db_ip, $db_user,$db_pw) or die (&quot;No connection. User or password is wrong&quot;);// select tablemysql_select_db($db_database) or die (&quot;The Database &quot;. $db_database .&quot; doesn't exist&quot;);// update table$query = &quot;UPDATE &quot;.$db_table.&quot; Set available = &quot;.mysql_real_escape_string($_GET['available']).&quot;, time = NOW() WHERE id = &quot;.mysql_real_escape_string($_GET['id']).&quot; AND pw='&quot;.mysql_real_escape_string($_GET['pw']).&quot;'&quot;;$update = mysql_query($query);if (!$update) {&nbsp; &nbsp; die('Error: ' . mysql_error());}// select info$query = &quot;SELECT available FROM &quot;.$db_table;$result = mysql_query($query);while($row = mysql_fetch_object($result)) {&nbsp;&nbsp; if ($row-&gt;available == true)&nbsp; &nbsp; $surveillance = false;}//Login an der Surveillance Station:$json = file_get_contents($httpformat.&quot;://&quot;.$ip.&quot;:&quot;.$port.&quot;/webapi/auth.cgi?api=SYNO.API.Auth&amp;method=Login&amp;version=3&amp; account=&quot;.$loginname.&quot;&amp;passwd=&quot;.$passwd.&quot;&amp;session= SurveillanceStation&amp;format=sid'&quot;);$obj = json_decode($json, true);$sid = $obj[&quot;data&quot;][&quot;sid&quot;];if ($surveillance) {//Kamera aktivieren:$json = file_get_contents($httpformat.&quot;://&quot;.$ip.&quot;:&quot;.$port.&quot;/webapi/_______________________________________________________entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=Enable&amp;version=3&amp;cameraIds=&quot;.$cam_id.&quot;&amp;_sid=&quot;.$sid);}else {//Kamera deaktivieren:}//Logout Surveillance Station:$out = file_get_contents($httpformat.&quot;://&quot;.$ip.&quot;:&quot;.$port.&quot;/webapi/auth.cgi?api=SYNO.API.Auth&amp;version=3&amp;method=Logout &amp;session=SurveillanceStation&quot;);?&gt;[/CODE]Getting from this php: &quot;Warning: mysql_connect(): php_network_getaddresses: gethostbyname failed. errno=0 in /volume1/web/alarm.php on line 18 Warning: mysql_connect(): php_network_getaddresses: gethostbyname failed. errno=0 in /volume1/web/alarm.php on line 18 No connection. User or password is wrong&quot;But root has access to this db. Checked this. Can you lead me further?</blockquote>

[QUOTE="The_Stig, post: 1139439, member: 12276"] Sooooo...tried a bit around. Did get a bit further, but not working. What I have working so far is a simple php activating and deactivating it. Had to change the script I posted here, because this did not work (don't know why). This one works (and yes, I know, the if else isn't nice, but I don't know how to remove it ;-) [CODE] <?php //Authentication $json = file_get_contents('http://IP:PORT/webapi/auth.cgi?api=SYNO.API.Auth&method=Login&version=3&account=user&passwd=PASSWORD&session=SurveillanceStation&format=sid'); $obj = json_decode($json, true); $sid = $obj["data"]["sid"]; //GetList $json = file_get_contents('http://IP:PORT/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&method=List&version=3&_sid='.$sid); $obj = json_decode($json, true); $cam_activated = $obj["data"]["cameras"][0]["enabled"]; if($cam_activated == false){ //Deactivate cam $json = file_get_contents('http://IP:PORT/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&method=Enable&version=3&cameraIds=2&_sid='.$sid); echo "<div class=\"centered\"><img src=\"http://192.168.178.99:5000/on_icon.png\" style=\"width:auto;height:auto;\" /></div>"; } else { //Deactivate cam $json = file_get_contents('http://IP:PORT/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&method=Enable&version=3&cameraIds=2&_sid='.$sid); echo "<div class=\"centered\"><img src=\"https://externeAdresse:Port/off_icon.png\" /></div>"; } ?> [/CODE] What I've done in php is this: [ATTACH=full]165543[/ATTACH] I guess some of the types are wrong? And I have this now as php script: [CODE] <?php $httpformat="http"; //hier angeben ob http oder https $port="5000"; //port $loginname="administrator"; //Loginname an der Surveillance Station $passwd="Password"; //passwort an der Surveillance Station $ip="IP"; //ip adresse der Surveillance station im LAN $cam_id="2"; // Kamera ID mit script "hole Kamera ID" abfragen, später automatisieren // db $db_name = "root"; $db_pw = "Password"; $db_database = "Surveillance"; $db_table = "user"; $db_ip = "127.0.0.1"; // activate Surveillance $surveillance = true; // connect to db $connection = mysql_connect(db_ip, $db_user,$db_pw) or die ("No connection. User or password is wrong"); // select table mysql_select_db($db_database) or die ("The Database ". $db_database ." doesn't exist"); // update table $query = "UPDATE ".$db_table." Set available = ".mysql_real_escape_string($_GET['available']).", time = NOW() WHERE id = ".mysql_real_escape_string($_GET['id'])." AND pw='".mysql_real_escape_string($_GET['pw'])."'"; $update = mysql_query($query); if (!$update) { die('Error: ' . mysql_error()); } // select info $query = "SELECT available FROM ".$db_table; $result = mysql_query($query); while($row = mysql_fetch_object($result)) { if ($row->available == true) $surveillance = false; } //Login an der Surveillance Station: $json = file_get_contents($httpformat."://".$ip.":".$port."/webapi/auth.cgi?api=SYNO.API.Auth&method=Login&version=3& account=".$loginname."&passwd=".$passwd."&session= SurveillanceStation&format=sid'"); $obj = json_decode($json, true); $sid = $obj["data"]["sid"]; if ($surveillance) { //Kamera aktivieren: $json = file_get_contents($httpformat."://".$ip.":".$port."/webapi/_______________________________________________________entry.cgi?api=SYNO.SurveillanceStation.Camera&method=Enable&version=3&cameraIds=".$cam_id."&_sid=".$sid); }else { //Kamera deaktivieren: } //Logout Surveillance Station: $out = file_get_contents($httpformat."://".$ip.":".$port."/webapi/auth.cgi?api=SYNO.API.Auth&version=3&method=Logout &session=SurveillanceStation"); ?> [/CODE] Getting from this php: "Warning: mysql_connect(): php_network_getaddresses: gethostbyname failed. errno=0 in /volume1/web/alarm.php on line 18 Warning: mysql_connect(): php_network_getaddresses: gethostbyname failed. errno=0 in /volume1/web/alarm.php on line 18 No connection. User or password is wrong" But root has access to this db. Checked this. Can you lead me further? [/QUOTE]

Verification