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 […]
Category: Database
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 […]
Reset MySQL password in FreeBSD
Just another post for my archive 🙂 One our sandbox accidently delete root account with host ‘localhost’. We need to recover the account by grant new root account back into system. The steps are : 1. Turn off mysql service sandbox# /usr/local/etc/rc.d/mysql-server stop 2. Run mysql with skip grant table mode sandbox# mysqld_safe –skip-grant-tables & […]
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, […]