That message show up when I install gammu from source in Ubuntu server 8.04 : root@dns:/home/edpteam# gammu –smsd MYSQL smsdrc Unknown SMSD service type (“MYSQL”) After dig in mailing list I have clue to install mysql library : apt-get install libmysqlclient15-dev apt-get install libmysqlclient15-dev Reading package lists… Done Building dependency tree Reading state information… Done […]

C:\gammu2>gammu –smsd MYSQL smsdrc Log filename is “smsdlog” Stop GAMMU smsd (27) Fri 2008/06/06 11:06:10 : Stop GAMMU smsd (27) Fri 2008/06/06 11:06:53 : Start GAMMU smsd Fri 2008/06/06 11:06:53 : PIN code is “1234” Fri 2008/06/06 11:06:53 : commtimeout=1, sendtimeout=10, receivefrequency=0, resetfrequency=0 Fri 2008/06/06 11:06:53 : deliveryreport = no Fri 2008/06/06 11:06:53 : phoneid […]

Just for my own record, dealing with Null type field. Checking with : select * from tablename where field1=”  -> this one not work select * from tablename where field1=’Null’ -> same too is null is the answer select * from tablename where field1 is null Save my day, thanks to St4r 🙂

Deal with gammu and mysql make learn more about mysql feature in mysql 5.0 called trigger. Books always good to start with so I choose MySQL Stored Procedure Programming book to start with but others might help to for someone looking for practical solution in cookbook form etc : High Performance MySQL: Optimization, Backups, Replication, […]