Operating system name and version: Fedora 12
Version of smsd: smstools-3.1.3-7.fc12.i686
Smsd installed from: package repository
Name and model of a modem / phone: Huawei Technologies Co., Ltd. E620 USB Modem
Interface: USB

Hi!
I'm trying to use mysmsd script to store all events in a MySQL database. I created the following script (as keke suggested in this post):
cat mysmsd #!/bin/bash # This is an example script that logs all events into an SQL database # You need a MYSQL database as described in the documentation. # Please read the documentation before using this script. SQL_HOST=localhost SQL_USER="smsd" SQL_PASSWORD="<super_secret_passwd>" SQL_DATABASE=smsd SQL_TABLE=sms_log DATE=`date +"%Y-%m-%d %H:%M:%S"` #Extract data from the SMS file FROM=`formail -zx From: < $2 | sed 's/"//g'` TO=`formail -zx To: < $2` #Remove plus sign, spaces, minus and short number prefix TO=`echo "$TO" | sed 's/ //g' | sed 's/+//g' | sed 's/s//g' | sed 's/-//g'` SUBJECT=`formail -zx Subject: < $2` SENT=`formail -zx Sent: < $2` TEXT=`sed -e '1,/^$/ d' < $2` TEXTSQL=$(echo "$TEXT" | sed 's/\\/\\\\/g' | sed 's/\"/\\\"/g') #Set some SQL parameters if [ "$SQL_PASSWORD" != "" ]; then SQL_ARGS="-p$SQL_PASSWORD"; else SQL_ARGS=""; fi SQL_ARGS="-h $SQL_HOST -u $SQL_USER $SQL_ARGS -D $SQL_DATABASE -s -e" #Insert a new entry into the SQL table if [ "$1" = "FAILED" ] || [ "$1" = "SENT" ]; then mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,sender,receiver,msgid,text) values (\"$1\",\"$DATE\",\"$FROM\",\"$TO\",\"$3\",\"$TEXTSQL\");"; elif [ "$1" = "RECEIVED" ]; then mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,received,sender,receiver,text) values (\"RECEIVED\",\"$SENT\",\"$DATE\",\"$FROM\",\"$SUBJECT\",\"$TEXTSQL\");"; elif [ "$1" = "REPORT" ]; then #Extract more data from the status report file DISCHARGE=`sed -e 1,/SMS\ STATUS/d < $2 | formail -zx Discharge_timestamp:` MSGID=`sed -e 1,/SMS\ STATUS/d < $2 | formail -zx Message_id:` STATUS=`sed -e 1,/SMS\ STATUS/d < $2 | formail -zx Status: | cut -f1 -d,` if [ "$MSGID" != "" ]; then ID=`mysql $SQL_ARGS "select id from $SQL_TABLE where receiver=\"$FROM\" and type=\"SENT\" and msgid=\"$MSGID\" order by id desc limit 1;"` mysql $SQL_ARGS "update $SQL_TABLE set received=\"$DISCHARGE\",status=\"$STATUS\" where id=\"$ID\";" fi fi

I made it executable:
-rwxr-xr-x. 1 root root 1948 28.10. 17:12 mysmsd

And added eventhandler to /etc/smsd.conf:
devices = GSM1 logfile = /var/spool/sms/smsd.log infofile = /var/run/smsd/smsd.running pidfile = /var/run/smsd/smsd.pid loglevel = 5 checkhandler = /var/spool/sms/ucsautoconvert eventhandler = /usr/local/bin/mysmsd outgoing = /var/spool/sms/outgoing checked = /var/spool/sms/checked failed = /var/spool/sms/failed incoming = /var/spool/sms/incoming sent = /var/spool/sms/sent whitelist = /var/spool/sms/whitelist [GSM1] device = /dev/ttyUSB0 incoming = yes report = yes

However it doesn't work as expected
It saves nothing into the database and when I try to run it manually it responds with this message:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'smsd'

What's wrong with it? Or is it just me?
TIA

Forgot to mention that user smsd is created and granted all necessary permissions onto smsd DB.

You could re-check everything, including the name of DB.

However, as the error is "user ''@'localhost'" instead of "user 'smsd'@'localhost'", your MySQL installation probably is broken and re-installation is required.

Have you tried the eventhandler with root account for MySQL?

With a quick view I cannot see what is causing the failure

keke wrote

...your MySQL installation probably is broken and re-installation is required.

Perkele! What a windoze approach it is!

keke wrote

Have you tried the eventhandler with root account for MySQL?

Yep, I did. It works flawlessly.

keke wrote

With a quick view I cannot see what is causing the failure

Anyway, thanks for the help keke! Your replies are quick and meaningful and your software rocks!

With any combination of incorrect username, incorrect password, missing user and missing permissions I did not get the similar error message than you got. I always got username in the message. Because in your case the username is not shown, you could try googling with  "Access denied for user ''@'localhost' to database" . Include quotation marks in the search. Lot of results are found, but with fast viewing I did not find any simple or universal solution. Hopefully you have better luck...