...
| Code Block |
|---|
CREATE DATABASE conftest; CREATE TABLE page_data (entry_id integer NOT NULL, page_group character varying(255) NOT NULL, sip_uri character varying(255) NOT NULL, page_timeout timestamp without time zone NOT NULL); CREATE USER conftest WITH PASSWORD 'password123'; GRANT ALL PRIVILEGES ON DATABASE conftest to conftest; |
Here is an example of the data that should be entered in this database:
entry_id | page_group | sip_uri | page_timeout |
|---|---|---|---|
1 | 3402 | 7001@sipx.domain.tld | 2011-05-10 14:19:30 |
2 | 3402 | 7002@sipx.domain.tld | 2011-05-10 14:19:30 |
3 | 3402 | 7003@sipx.domain.tld | 2011-05-10 14:19:30 |
Now you need to allow conftest to log in to the database. To do this you will need to set a password on the posgresql user:
...