<html><body>
<DIV>This is related to asterisk database and in the process of installing a2billing,</DIV>
<DIV> </DIV>
<DIV><FONT size=2> 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 <BR><BR>a2billing=> SELECT * FROM cc_ui_authen; <BR>ERROR: relation "cc_ui_authen" does not exist <BR><BR><BR>I am suppose to get this: <BR>a2billing=> SELECT * FROM cc_ui_authen; <BR>userid | login | password | groupid | perms | confaddcust | name | direction | zipcode | state | phone | fax | datecreation <BR>--------+-------+------------+---------+-------+-------------+------+-----------+---------+-------+-------+-----+------------------------------- <BR>2 | admin | mypassword | 0 | 1023 | | | | | | | | 2005-02-27 04:14:05.391501+02 <BR>1 | root | myroot | 0 | 1023 | | | | | | | | 2005-02-27 03:33:27.691314+02 <BR>(2 rows) <BR><BR>made changes to pg_hba.conf <BR>made sure that it ends with <BR><BR>local all all trust <BR>host all all 127.0.0.1 255.255.255.255 trust <BR>host all all localip 255.255.255.255 tr
ust <BR><BR><BR>made changes also under connection section <BR>in postgresql.conf <BR>added: <BR><BR>#tcpip_socket = True <BR>port = 5432 <BR><BR><BR>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.</FONT></DIV></body></html>