broadbandvoice@comcast.net
2007-Feb-24 20:22 UTC
[asterisk-users] ERROR: relation "cc_ui_authen" does not exist
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. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070224/195c6d68/attachment.htm
broadbandvoice@comcast.net
2007-Feb-25 19:24 UTC
[asterisk-users] ERROR: relation "cc_ui_authen" does not exist
Skipped content of type multipart/alternative-------------- next part -------------- An embedded message was scrubbed... From: broadbandvoice@comcast.net Subject: [asterisk-users] ERROR: relation "cc_ui_authen" does not exist Date: Sun, 25 Feb 2007 03:23:33 +0000 Size: 820 Url: http://lists.digium.com/pipermail/asterisk-users/attachments/20070225/921dabf8/attachment.eml