Stop GAMMU smsd (27)

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 …


MySQL and Null

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

Mysql Trigger Tutorial and Tools

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, …


Postfix and LOCK tables

just found error in /var/log/messages and when I try to backup postfix database. mail# mysqldump -upostfix -p postfix > postfix.sql Enter password: mysqldump: Got error: 1044: Access denied for user ‘postfix’@’localhost’ to database ‘postfix’ when using LOCK TABLES checking user privileges using information_schema mail# mysql -upostfix -p Enter password: Welcome to the MySQL monitor.  Commands …