Fröling: [ANNOUNCE] p4d - Visualisierung und Einstellung der S-3200 via COM1

root@HeizSV:~# cd /usr/src/linux-p4d
root@HeizSV:/usr/src/linux-p4d# make -s
root@HeizSV:/usr/src/linux-p4d# make -s install
root@HeizSV:/usr/src/linux-p4d#
root@HeizSV:/usr/src/linux-p4d# cd
root@HeizSV:~# p4d -v
Version 0.2.30-GIT9bc3c71
root@HeizSV:~# p4d -n -t
Read 8 option from /etc/p4d/p4d.conf
Info: Calling mysql_library_init()
Dictionary '/etc/p4d/p4d.dat' loaded
Info: No One-Wire sensors found, path '/sys/bus/w1/devices' not exist (No such file or directory)
Opening '/dev/ttyUSB0' succeeded!
Try conneting to database
Checking database connection ...
Calling mysql_init(2638)
SQL client character now 'utf8'
Checking table structure and indices ...
Checking table 'config'
Initialy creating table 'config'
create table config(owner VARCHAR(40), name VARCHAR(40), inssp INT(11), updsp INT(11), value VARCHAR(100), PRIMARY KEY(owner DESC, name DESC)) ENGINE InnoDB;
Checking table 'errors'
Initialy creating table 'errors'
create table errors(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), time1 DATETIME comment 'time gekommen', time4 DATETIME comment 'time gegangen', time2 DATETIME comment 'time quittiert', number INT(10), info INT(10), state VARCHAR(10), text VARCHAR(100), mailcnt INT(11), PRIMARY KEY(id DESC)) ENGINE InnoDB;
Checking table 'hmsysvars'
Initialy creating table 'hmsysvars'
create table hmsysvars(id INT(11) unsigned, inssp INT(11), updsp INT(11), name VARCHAR(100), type INT(1) unsigned, unit VARCHAR(10), visible INT(1) unsigned, min VARCHAR(100), max VARCHAR(100), time DATETIME, value VARCHAR(100), address INT(4) unsigned, atype VARCHAR(2), PRIMARY KEY(id DESC)) ENGINE InnoDB;
create index idxaddress on hmsysvars(address);
Checking table 'jobs'
Initialy creating table 'jobs'
create table jobs(id INT(11) unsigned not null auto_increment, inssp INT(10), updsp INT(10), requestat DATETIME, doneat DATETIME, state VARCHAR(1), command VARCHAR(100), address INT(4) unsigned, result VARCHAR(100), data VARCHAR(100), PRIMARY KEY(id DESC)) ENGINE InnoDB;
create index idxstate on jobs(state);
create index idxrequestat on jobs(requestat);
Checking table 'menu'
Initialy creating table 'menu'
create table menu(id INT(4) unsigned not null auto_increment, inssp INT(10), updsp INT(10), parent INT(5) unsigned, child INT(5) unsigned, type INT(1) unsigned, address INT(4) unsigned, title VARCHAR(100), state VARCHAR(1), unit VARCHAR(5), value VARCHAR(100), unknown1 INT(4), unknown2 INT(4), PRIMARY KEY(id DESC)) ENGINE InnoDB;
Checking table 'samples'
Initialy creating table 'samples'
create table samples(address INT(4) unsigned, type VARCHAR(2), aggregate VARCHAR(1), time DATETIME, inssp INT(10), updsp INT(10), value FLOAT(14,2), text VARCHAR(50), samples INT(3), PRIMARY KEY(address DESC, type DESC, aggregate DESC, time DESC)) ENGINE InnoDB;
create index idxtime on samples(time);
create index idxtype on samples(type);
Checking table 'schemaconf'
Initialy creating table 'schemaconf'
create table schemaconf(address INT(4) unsigned, type VARCHAR(2), inssp INT(10), updsp INT(10), state VARCHAR(1), kind VARCHAR(20), color VARCHAR(10), showunit INT(1), showtext INT(1), bg INT(2), fontsize INT(2), aleft INT(2), xpos INT(11), ypos INT(11), link VARCHAR(100), PRIMARY KEY(address DESC, type DESC)) ENGINE InnoDB;
Checking table 'scripts'
Initialy creating table 'scripts'
create table scripts(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), name VARCHAR(100), visible VARCHAR(1) comment '\'Y\'es, \'N\'o', path VARCHAR(100), PRIMARY KEY(id DESC)) ENGINE InnoDB;
create index idxpath on scripts(path);
Checking table 'sensoralert'
Initialy creating table 'sensoralert'
create table sensoralert(id INT(11) unsigned not null auto_increment, inssp INT(10), updsp INT(10), kind VARCHAR(1), subid INT(11) unsigned, lgop INT(11) unsigned, address INT(4) unsigned, type VARCHAR(2), state VARCHAR(1), min INT(10), max INT(10), rangem INT(10), delta INT(10), maddress VARCHAR(100), msubject VARCHAR(100), mbody TEXT, lastalert INT(10), maxrepeat INT(10), PRIMARY KEY(id DESC)) ENGINE InnoDB;
Checking table 'smartconfig'
Initialy creating table 'smartconfig'
create table smartconfig(address INT(4) unsigned, type VARCHAR(2), inssp INT(10), updsp INT(10), state VARCHAR(1), kind VARCHAR(20), color VARCHAR(10), showunit INT(1), showtext INT(1), bg INT(2), fontsize INT(2), aleft INT(2), xpos INT(11), ypos INT(11), link VARCHAR(100), PRIMARY KEY(address DESC, type DESC)) ENGINE InnoDB;
Checking table 'timeranges'
Initialy creating table 'timeranges'
create table timeranges(address INT(4) unsigned, from1 VARCHAR(5), to1 VARCHAR(5), from2 VARCHAR(5), to2 VARCHAR(5), from3 VARCHAR(5), to3 VARCHAR(5), from4 VARCHAR(5), to4 VARCHAR(5), PRIMARY KEY(address DESC)) ENGINE InnoDB;
Checking table 'valuefacts'
Initialy creating table 'valuefacts'
create table valuefacts(address INT(4) unsigned, type VARCHAR(2), inssp INT(10), updsp INT(10), state VARCHAR(1), unit VARCHAR(5), factor INT(4), name VARCHAR(100), title VARCHAR(100), usrtitle VARCHAR(100), res1 INT(4), PRIMARY KEY(address DESC, type DESC)) ENGINE InnoDB;
Closing mysql connection and calling mysql_thread_end(2638)
Checking table structure and indices succeeded
Calling mysql_init(2638)
Connection to database established
Storing 'user' with value 'p4'
Storing 'passwd' with value '141785a8765705819f5495b2c539c7b9'
Storing 'mail' with value ''
Storing 'htmlMail' with value ''
Storing 'mailScript' with value '/usr/local/bin/p4d-mail.sh'
Storing 'stateMailStates' with value '0,1,3,19'
Storing 'stateMailTo' with value ''
Storing 'errorMailTo' with value ''
Storing 'tsync' with value ''
Storing 'maxTimeLeak' with value ''
Info: Script path '/etc/p4d/scripts.d' not exists - 'No such file or directory'
Checking state ...
... got (5) 'Feuer aus'
State changed to 'Feuer Aus'
Reading values ...
Processed 0 samples, state is 'Feuer Aus'
Updating error list
Updating error list done
Info: Found (0) pending errors
Checking state ...
... got (5) 'Feuer aus'
Checking state ...
... got (5) 'Feuer aus'

Read 8 option from /etc/p4d/p4d.conf
Info: Calling mysql_library_init()
Dictionary '/etc/p4d/p4d.dat' loaded
Info: No One-Wire sensors found, path '/sys/bus/w1/devices' not exist (No such file or directory)
Opening '/dev/ttyUSB0' succeeded!
Try conneting to database
Checking database connection ...
Calling mysql_init(903)
SQL client character now 'utf8'
Checking table structure and indices ...
Checking table 'config'
Checking table 'errors'
Checking table 'hmsysvars'
Checking table 'jobs'
Checking table 'menu'
Checking table 'samples'
Checking table 'schemaconf'
Checking table 'scripts'
Checking table 'sensoralert'
Checking table 'smartconfig'
Checking table 'timeranges'
Checking table 'valuefacts'
Closing mysql connection and calling mysql_thread_end(903)
Checking table structure and indices succeeded
Calling mysql_init(903)
Connection to database established
Info: Script path '/etc/p4d/scripts.d' not exists - 'No such file or directory'
Processing WEBIF job 207 'updatemenu:0x0000/'