SMSEagle NPE-9300-GPRS/3G, User Manual

Page: 89 / 107

Page
89
Connecting directly to SMSEagle database
SMSEagle’s database operates on PostgreSQL database engine. It is possible to connect to the database
from external application using the following credentials:
P
OSTGRE
SQL
DATABASE CREDENTIALS
Host: IP address of your SMSEagle
Database name: smseagle
User: smseagleuser
Password: postgreeagle
Injecting short SMS using SQL
The simplest example is short text message (limited to 160 chars):
INSERT INTO outbox (
DestinationNumber,
TextDecoded,
CreatorID,
Coding,
Class,
SenderID
) VALUES (
'1234567',
'This is a SQL test message',
'Program',
'Default_No_Compression',
-1,
'smseagle1'
);
INSERT INTO user_outbox (
id_outbox,
id_user
) SELECT CURRVAL(pg_get_serial_sequence('outbox','ID')), 1;
In the above example the message will belong to user with id_user 1 (default 'admin'). You can find
id_user values for other users in table public."user".