Figured out myself, just sharing to help others I have fixed the tables problem in the postgresql database the parameter tcpip_socket is no longer used in version 8.0 soforget about that. it has been replaced by listen_address. and we only want postgres to listen on the localhost so the setting as it is fine now.
-------------- Original message -------------- From: [EMAIL PROTECTED] 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 tr ust 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.
--- Begin Message ---_______________________________________________ --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
--- End Message ---
_______________________________________________ --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
