This is related to asterisk database and in the process of installing a2billing,
am still in the install stages and not able to logon but know what the
problem. When I create the database and try to verify it, this what I get
a2billing=> SELECT * FROM cc_ui_authen;
ERROR: relation "cc_ui_authen" does not exist
I am suppose to get this:
a2billing=> SELECT * FROM cc_ui_authen;
userid | login | password | groupid | perms | confaddcust | name | direction |
zipcode | state | phone | fax | datecreation
--------+-------+------------+---------+-------+-------------+------+-----------+---------+-------+-------+-----+-------------------------------
2 | admin | mypassword | 0 | 1023 | | | | | | | | 2005-02-27 04:14:05.391501+02
1 | root | myroot | 0 | 1023 | | | | | | | | 2005-02-27 03:33:27.691314+02
(2 rows)
made changes to pg_hba.conf
made sure that it ends with
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all localip 255.255.255.255 trust
made changes also under connection section
in postgresql.conf
added:
#tcpip_socket = True
port = 5432
I also commented out #tcpip_socket = True becuase the postgres will not start
when its set to true. But that is not the problem, problem is not being able to
verify the database.
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users