Gammu-smsd with postgres startup problem

Alessandro Vercelli <[email protected]>
Newsgroups gmane.linux.drivers.gammu
Message-ID <[email protected]>
Hello everybody,
I'm new to gammu and, trying to build a test environment, I got some problem in starting gammu service.

First, my environment:
- Gammu version 1.31.90
- Os: Linux Raspbian 7
- Gammu backend: PostgreSQL 9.1

This is my /etc/gammu-smsdrc:

# Configuration file for Gammu SMS Daemon

# Gammu library configuration, see gammurc(5)
[gammu]
# Please configure this!
port = /dev/ttyUSB0
connection = at115200

# Debugging
logformat = textall

# SMSD configuration, see gammu-smsdrc(5)
[smsd]
debuglevel = 255
logfile = /var/log/smsd.log
# Postgres backend
service = sql
driver = native_pgsql
host = localhost

# Increase for debugging information
#debuglevel = 0

# Paths where messages are stored
inboxpath = /domox/gammu/spool/inbox/
outboxpath = /domox/gammu/spool/outbox/
sentsmspath = /domox/gammu/spool/sent/
errorsmspath = /domox/gammu/spool/error/

The database has been built using pgsql.sql script; the error is in starting gammu-smsd service (command: /etc/init.d/gammu-smsd start - or restart), in log file I find:

Thu 2015/05/28 16:40:07 gammu-smsd[3401]: Using SQL service
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: Configuring Gammu SMSD...
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: SHM token: 0xffffffffce00b8bb (-838813509)
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: Warning: No PIN code in /etc/gammu-smsdrc file
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: CommTimeout=30, SendTimeout=30, ReceiveFrequency=0, ResetFrequency=0, HardResetFrequency=0
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: checks: CheckSecurity=1, CheckBattery=1, CheckSignal=1
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: mode: Send=1, Receive=1
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: deliveryreport = no
Thu 2015/05/28 16:40:07 gammu-smsd[3401]: phoneid =
Thu 2015/05/28 16:40:07 gammu-smsd[3402]: Error connecting to database: FATAL:  database "sms" does not exist
Thu 2015/05/28 16:40:07 gammu-smsd[3402]: Initialisation failed, stopping Gammu smsd: Unknown error. (UNKNOWN[27])

Unexpectedly, the service is trying to work with a database named "sms" but the gammu tables are located in publich schema of template1 db:
postgres=# \dt
              List of relations
 Schema |       Name       | Type  |  Owner
--------+------------------+-------+----------
 public | daemons          | table | postgres
 public | gammu            | table | postgres
 public | inbox            | table | postgres
 public | outbox           | table | postgres
 public | outbox_multipart | table | postgres
 public | pbk              | table | postgres
 public | pbk_groups       | table | postgres
 public | phones           | table | postgres
 public | sentitems        | table | postgres
(9 rows)


Many thanks for the help,
Alessandro


------------------------------------------------------------------------------
_______________________________________________
Gammu-users mailing list - https://lists.sourceforge.net/lists/listinfo/gammu-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.