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