User Manual

139 | SMSEagle NXS-9700-3G | User’s Manual
POSTGRESQL DATABASE CREDENTIALS
Host: IP address of your device
Database name: smseagle
EXTRAS
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:
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;
Password: postgreeagle
User: smseagleuser