root@SERVER:/var/lib# l /var/lib | grep mysql
drwx------ 12 mysql mysql 4,0K Jan 2 06:59 mysql
root@SERVER:/var/lib# l /var/run/ | grep mysql
drwxr-xr-x 2 mysql root 80 Jan 2 06:59 mysqld
root@SERVER:/var/lib# l /var/run/mysqld/mysqld.sock
srwxrwxrwx 1 mysql mysql 0 Jan 2 06:59 /var/run/mysqld/mysqld.sock[client]
.....
socket = /var/run/mysqld/mysqld.sock
......
[mysqld]
....
socket = /var/run/mysqld/mysqld.sock
....[MySQL]
....
; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
; http://php.net/mysql.default-port
mysql.default_port =
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysql.default-socket
mysql.default_socket =
....
Wie immer im error.log vom webserver. Evtl. muss man in der index.php mal auf E_ALL stellen.
[0:0] processing rule '*:*' '^' '^' '/var/tmp/infoframe/refresh.sh "action=call&event=$EVENT&src_name=$(urlencode "$SOURCE_NAME")&src_address=$(urlencode "$SOURCE_ADDRESS")&dst_name=$(urlencode "$DEST_NAME")&dst_address=$(urlencode "$DEST_ADDRESS")&duration=$DURATION"'
[0:0] event 'in:request' matches pattern '*:*'
[0:0] parameter SOURCE='********' matches pattern '^'
[0:0] parameter DEST='**********' matches pattern '^'
[0:0] SUCCEEDED
[0:0] ACTION: '/var/tmp/infoframe/refresh.sh "action=call&event=$EVENT&src_name=$(urlencode "$SOURCE_NAME")&src_address=$(urlencode "$SOURCE_ADDRESS")&dst_name=$(urlencode "$DEST_NAME")&dst_address=$(urlencode "$DEST_ADDRESS")&duration=$DURATION"'
Connecting to 192.168.178.20 (192.168.178.20:80)
tmp.jpg 100% |*******************************| 65 0:00:00 ETA
Connecting to 192.168.178.20 (192.168.178.20:80)
tmp.jpg 100% |*******************************| 65 0:00:00 ETA
Connecting to 192.168.178.20 (192.168.178.20:80)
tmp.jpg 100% |*******************************| 65 0:00:00 ETA
Connecting to 192.168.178.29:5050 (192.168.178.29:5050)
wget: can't connect to remote host (192.168.178.29): Connection refused
Connecting to 192.168.178.29:5050 (192.168.178.29:5050)
wget: can't connect to remote host (192.168.178.29): Connection refused
Connecting to 192.168.178.29:5050 (192.168.178.29:5050)
wget: can't connect to remote host (192.168.178.29): Connection refused
[0:0] action failed with an exit status of 1ich glaube nicht, der Fehler kommt doch erst in der refresh.sh.
#!/bin/sh
# refresh infoframe image
# config
localpath="/var/tmp/infoframe"
serverscript="http://root:[email protected]/infoframe/index.php"
samsung_ip_address="192.168.178.29"
samsung_rss_id="143560439"
# try 3 times to download picture until error is displayed
tries=1
while true
do
# download new picture
wget "$serverscript?$1" -O $localpath/tmp.jpg
# do some checks (error/warning string in file? downloaded file should be at least 10k of size?)
# if error occured we do a next try
err=0
warn=0
filesize=0
if [ -f $localpath/tmp.jpg ]
then
err=`grep -i 'error' $localpath/tmp.jpg | wc -l`
warn=`grep -i 'warning' $localpath/tmp.jpg | wc -l`
filesize=`du $localpath/tmp.jpg | cut -f1`
fi
# process checking result
if [ $err == 0 ] && [ $warn == 0 ] && [ $filesize -ge 10 ]
then
mv $localpath/tmp.jpg $localpath/info.jpg
break
else
if [ $tries -ge 3 ]
then
date +%d-%m-%Y_%H-%M-%S >> $localpath/download.log
echo "*** ERROR OR WARNING FOUND: filesize= $filesize ***" >> $localpath/download.log
rm $localpath/tmp.jpg 2> /dev/null
cp $localpath/error.jpg $localpath/info.jpg
break
else
# just wait some seconds, then try again
tries=$(expr $tries + 1)
sleep 5
fi
fi
done
# Samsung SPF-83v specific tasks
# ===============================
# disable and enable picture cache for this rss feed to make immediately refresh possible
wget -s "http://$samsung_ip_address:5050/configuration/storage.htm?CheckRssNameId=$samsung_rss_id&Checked=false"
wget -s "http://$samsung_ip_address:5050/configuration/storage.htm?CheckRssNameId=$samsung_rss_id&Checked=true"
# force samsung picture frame to immediately refresh picture by simulate clicking on "next" in web interface
wget -s "http://$samsung_ip_address:5050/configuration/photo_frame.htm?next"filesize=`du $localpath/tmp.jpg | cut -f1`filesize=`du -b $localpath/tmp.jpg | cut -f1`private function addCall($type, $name, $address, $duration) {
if ($name == "")
$name = 'Unbekannt';
$query = "INSERT INTO if_calls (id, type, timestamp, name, address, duration) VALUES (NULL, $type, CURRENT_TIMESTAMP, '$name', '$address', $duration)";
// [...]
}$query = "INSERT INTO if_calls (id, type, timestamp, name, address, duration) VALUES (NULL, $type, CURRENT_TIMESTAMP, '".mysql_real_escape_string($name)."', '".mysql_real_escape_string($address)."', $duration)";
