[asterisk-users] ERROR: relation "cc_ui_authen" does not exist

broadbandvoice at comcast.net broadbandvoice at comcast.net
Sat Feb 24 20:22:49 MST 2007


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


More information about the asterisk-users mailing list