Re: Gammu-smsd with postgres startup problem

Michal Čihař <[email protected]> Thu, 28 May 2015 19:14:31 +0200

Newsgroups	gmane.linux.drivers.gammu
Message-ID	<[email protected]>

Hi

Dne Thu, 28 May 2015 16:58:46 +0200
Alessandro Vercelli <[email protected]> napsal(a):

> 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

You don't have configured which database to use here:

http://wammu.eu/docs/manual/smsd/config.html#option-Database

> Thu 2015/05/28 16:40:07 gammu-smsd[3402]: Error connecting to database: FATAL:  database "sms" does not exist

...and Gammu falls back to default database name, which is sms.

> 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:

So set database = template1.

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com

------------------------------------------------------------------------------

_______________________________________________
Gammu-users mailing list - https://lists.sourceforge.net/lists/listinfo/gammu-users

signature.asc (application/pgp-signature, 819 B)