asterisk2billing.org
http://forum.asterisk2billing.org/

Problems with Postgresql
http://forum.asterisk2billing.org/viewtopic.php?f=21&t=10938
Page 1 of 1

Author:  eureur.de [ Mon Sep 22, 2014 9:55 am ]
Post subject:  Problems with Postgresql

Hello,

I have installed a2blling with postgre nad had some problems with sql injection...
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_authid" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_database" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_tablespace" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_pltemplate" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_auth_members" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_shdepend" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_shdescription" --- only superuser can vacuum it
psql:a2billing-schema-v1.4.0.sql:2805: WARNING: skipping "pg_db_role_setting" --- only superuser can vacuum it

I am not sure where those tables must be done, I am able to do it myself but where?

And second problem I think related with above... I can't login to admin page. And main point I cant' catch error. Apache writes nothing in log, postgre writes nochting as well. One think I can see in Browser PP_intro.php and connection failed.... php-pgsql and other relations already controlled and everythik are there, Many time rebooted.

Thank you for any help

Ok now I can something see undera2billing.conf debug mode... >>>> Bug in My_to_Pg: didn't process match in $mytopg[0] /var/www/system/common/lib/Class.MytoPg.php:117

Solution: change this file from new version.

Author:  jroper [ Sun Sep 28, 2014 9:56 am ]
Post subject:  Re: Problems with Postgresql

Hi

We are not supporting PostgreSQL in A2Billing at the moment, we would advise using MySQL.

Joe

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/