assistance needed

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

Quote:

echo "GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd)

Whilst you have used single-quotes (') in your post here, I think perhaps when you entered it at the Bash prompt you instead used back-ticks (`). That would account for the errors you're receiving, ie:

Code:

# with single-quotes
$ echo "'GRANT ...'"
'GRANT ...'

# with back-ticks
$ echo "`GRANT ...`"
bash: GRANT: command not found

ramindia · **Joined:** Thu Aug 09, 2007 8:42 am **Posts:** 53

Is mysql running

use mysql -u root -p
asks for the password

in the mysql command level

run the below and see, if you can success

Quote:

GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser'@'localhost' IDENTIFIED BY 'a2billing' WITH GRANT OPTION;" | mysql -ppassw0rd)

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

Many thanks for your walk thourgh

i actually did a fresh installation of centos with Asterisk + a2billing i`m still managing my database its a dilemma

cheers

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

someone gimme a hand here i`v followed the guide up till this point where it stops saying permission denied

Code:

 psql -d a2billing -f /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql -U a2billinguser -W

then it asks for a password, right after the message below pops up !

Code:

/root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql: Permission denied

Any help would appreciate it.

stavros · **Posted:** Tue Jul 14, 2009 6:32 pm

ahmy501 wrote:

someone gimme a hand here i`v followed the guide up till this point where it stops saying permission denied

Code:

 psql -d a2billing -f /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql -U a2billinguser -W

You need to chose either MySQL or Postgres; you don't need to install both. Earlier in this thread you were using MySQL. Unless you've changed your mind on using MySQL, you don't need to use the Postgres instructions.

Quote:

then it asks for a password, right after the message below pops up !

Code:

/root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql: Permission denied

If you want Postgres to read files directly, it must have permission to read them. It's often easier to use

Code:

cat   
/root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql | psql -d a2billing  -U a2billinguser -W -f -

This way, only the user you run the command as needs read-access to the file.

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

Thanks Stavros for the reply

i still can`t import data schema to my database its giving the same error

Code:

[root@localhost ~]# su postgres
bash-3.2$ psql -d a2billing -f /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql | psql -d a2billing  -U a2billinguser -W -f -
could not change directory to "/root"
Password for user a2billinguser: could not change directory to "/root"
/root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql: Permission denied

i`m trying to break it down well the error message is readable (couldn`t change directory to root)

do you think i have to change directories !

cheers

stavros · **Posted:** Tue Jul 14, 2009 11:52 pm

ahmy501 wrote:

Thanks Stavros for the reply

You didn't specify, so I shall presume you've ditched MySQL and made a conscious choice to use Postgres for this install.

Quote:

$ psql -d a2billing -f /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql | psql ...

You're piping the output of one psql command into another psql command. That will never work!

Quote:

Code:

[root@localhost ~]# su postgres

do you think i have to change directories !

Previously I mentioned permissions, and this continues to be the problem. When you 'su postgres' you become the postgres user, and therefore you relinquish access to files owned by root. There's no need to su to postgres to be able to use Postgres.

What are the results of my previous suggestion (without doing 'su postgres' first):

Code:

cat /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql | psql -da2billing  -Ua2billinguser -W -f -

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

Thanks Stavros ,

yeah i shifted to postgres and the rsult of your command is . .

Code:

bash-3.2$ cat /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql | psql -da2billing  -Ua2billinguser -W -f -
cat: /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql: Permission denied
could not change directory to "/root"
Password for user a2billinguser: 
bash-3.2$

i assumed that all went on the right path and continued to verify it it asked for a password and again im` left there as a user only.

i should be getting the result below

Code:

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)

stavros · **Posted:** Wed Jul 15, 2009 11:59 am

ahmy501 wrote:

Code:

bash-3.2$ cat /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql | psql -da2billing  -Ua2billinguser -W -f -
cat: /root/Desktop/a2billing_1.3.4/a2billing-pgsql-schema.sql: Permission denied
could not change directory to "/root"
Password for user a2billinguser: 
bash-3.2$

Perhaps you missed the most critical part of my previous suggestions: "(without doing 'su postgres' first)"

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

hey Stavros thanks but i missed up loads of things decided to reinstall centos :mrgreen:

dunno what happened to these commands here , they are not doing any action i`v tried to change the asterisk-1.2 to the version that i want to install still nothin is happenin !! i was trying to download compile the sources but FTPs from Digium aren`t working too !!

Code:

# svn checkout http://svn.digium.com/svn/asterisk/branches/1.2 asterisk-1.2
# svn checkout http://svn.digium.com/svn/zaptel/branches/1.2 zaptel-1.2
# svn checkout http://svn.digium.com/svn/libpri/branches/1.2 libpri-1.2

stavros · **Posted:** Wed Jul 15, 2009 2:14 pm

It seems like a local problem. I just checked out libpri using your command with no problems.

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

everything is running smooth now except when i try to install postgres by using apt-get i get the following error

Code:

bash: apt-get: command not found

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

ok back to where i was again

i`v installed everything correctly with no errors but when i try to import data schema i get to input my password then i get this

Code:

bash-3.2$ psql -d a2billing -f /usr/src/a2billing/a2billing-pgsql-schema.sql -U a2billinguser -W
Password for user a2billinguser: ***
psql: FATAL:  Ident authentication failed for user "a2billinguser"

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

i think i managed i configured the pg_hba.conf to all trust but if i set them according to the guide postgres fails to restart !

Giude conf

Code:

local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all xxxxxxxxx 255.255.255.255 trust

my conf

Code:

local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

dunno if this would do the trick

now i`m getting this

Code:

-bash-3.2$ psql -d a2billing -f /usr/src/a2billing/Database/psql/a2billing-pgsql-schema.sql -U a2billinguser -W
Password for user a2billinguser: ***
/usr/src/a2billing/Database/psql/a2billing-pgsql-schema.sql: No such file or directory

its frustrating man

ahmy501 · **Joined:** Tue Jun 30, 2009 11:37 pm **Posts:** 14

after long hours of frustration i figured that the directory of where a2billing base was in a different location , Stavros can you please verify if my setup is correct

after entering the command to import data schema

Original code

Code:

psql -d a2billing -f /usr/src/a2billing/a2billing-pgsql-schema.sql -U a2billinguser -W

changed it to :

Code:

psql -d a2billing -f /usr/src/a2billing/DataBase/psql-pgsql-schema-v1.3.0sql -U a2billinguser -W

i got the following explusion

Code:

INSERT 17417 1
INSERT 17418 1
INSERT 17419 1
INSERT 17420 1
INSERT 17421 1
INSERT 17422 1
INSERT 17423 1
INSERT 17424 1
INSERT 17425 1
INSERT 17426 1
INSERT 17427 1
INSERT 17428 1
INSERT 17429 1
INSERT 17430 1
INSERT 17431 1
INSERT 17432 1
INSERT 17433 1
INSERT 17434 1
INSERT 17435 1
INSERT 17436 1
INSERT 17437 1
INSERT 17438 1
INSERT 17439 1
INSERT 17440 1
INSERT 17441 1
INSERT 17442 1
INSERT 17443 1
INSERT 17444 1
INSERT 17445 1
INSERT 17446 1
INSERT 17447 1
INSERT 17448 1
INSERT 17449 1
INSERT 17450 1
INSERT 17451 1
INSERT 17452 1
INSERT 17453 1
INSERT 17454 1
INSERT 17455 1
INSERT 17456 1
INSERT 17457 1
INSERT 17458 1
INSERT 17459 1
INSERT 17460 1
INSERT 17461 1
INSERT 17462 1
INSERT 17463 1
INSERT 17464 1
INSERT 17465 1
INSERT 17466 1
INSERT 17467 1
INSERT 17468 1
INSERT 17469 1
INSERT 17470 1
INSERT 17471 1
INSERT 17472 1
INSERT 17473 1
INSERT 17474 1
INSERT 17475 1
INSERT 17476 1
INSERT 17477 1
INSERT 17478 1
INSERT 17479 1
INSERT 17480 1
INSERT 17481 1
INSERT 17482 1
INSERT 17483 1
INSERT 17484 1
INSERT 17485 1
INSERT 17486 1
INSERT 17487 1
INSERT 17488 1
INSERT 17489 1
INSERT 17490 1
INSERT 17491 1
INSERT 17492 1
INSERT 17493 1
INSERT 17494 1
INSERT 17495 1
INSERT 17496 1
INSERT 17497 1
INSERT 17498 1
INSERT 17499 1
INSERT 17500 1
INSERT 17501 1
INSERT 17502 1
INSERT 17503 1
INSERT 17504 1
INSERT 17505 1
INSERT 17506 1
INSERT 17507 1
INSERT 17508 1
INSERT 17509 1
INSERT 17510 1
INSERT 17511 1
INSERT 17512 1
INSERT 17513 1
INSERT 17514 1
INSERT 17515 1
INSERT 17516 1
INSERT 17517 1
INSERT 17518 1
INSERT 17519 1
INSERT 17520 1
INSERT 17521 1
INSERT 17522 1
INSERT 17523 1
INSERT 17524 1
INSERT 17525 1
INSERT 17526 1
INSERT 17527 1
INSERT 17528 1
INSERT 17529 1
INSERT 17530 1
INSERT 17531 1
INSERT 17532 1
INSERT 17533 1
INSERT 17534 1
INSERT 17535 1
INSERT 17536 1
INSERT 17537 1
INSERT 17538 1
INSERT 17539 1
INSERT 17540 1
INSERT 17541 1
INSERT 17542 1
INSERT 17543 1
INSERT 17544 1
INSERT 17545 1
INSERT 17546 1
INSERT 17547 1
INSERT 17548 1
INSERT 17549 1
INSERT 17550 1
INSERT 17551 1
INSERT 17552 1
INSERT 17553 1
INSERT 17554 1
INSERT 17555 1
INSERT 17556 1
INSERT 17557 1
INSERT 17558 1
INSERT 17559 1
INSERT 17560 1
INSERT 17561 1
INSERT 17562 1
INSERT 17563 1
INSERT 17564 1
INSERT 17565 1
INSERT 17566 1
INSERT 17567 1
INSERT 17568 1
INSERT 17569 1
INSERT 17570 1
INSERT 17571 1
INSERT 17572 1
INSERT 17573 1
INSERT 17574 1
INSERT 17575 1
INSERT 17576 1
INSERT 17577 1
INSERT 17578 1
INSERT 17579 1
INSERT 17580 1
INSERT 17581 1
INSERT 17582 1
INSERT 17583 1
INSERT 17584 1
INSERT 17585 1
INSERT 17586 1
INSERT 17587 1
INSERT 17588 1
INSERT 17589 1
INSERT 17590 1
INSERT 17591 1
INSERT 17592 1
INSERT 17593 1
INSERT 17594 1
INSERT 17595 1
INSERT 17596 1
INSERT 17597 1
INSERT 17598 1
INSERT 17599 1
INSERT 17600 1
INSERT 17601 1
INSERT 17602 1
INSERT 17603 1
INSERT 17604 1
INSERT 17605 1
INSERT 17606 1
INSERT 17607 1
INSERT 17608 1
INSERT 17609 1
INSERT 17610 1
INSERT 17611 1
INSERT 17612 1
INSERT 17613 1
INSERT 17614 1
INSERT 17615 1
INSERT 17616 1
INSERT 17617 1
INSERT 17618 1
INSERT 17619 1
INSERT 17620 1
INSERT 17621 1
INSERT 17622 1
INSERT 17623 1
INSERT 17624 1
INSERT 17625 1
INSERT 17626 1
INSERT 17627 1
INSERT 17628 1
INSERT 17629 1
INSERT 17630 1
INSERT 17631 1
INSERT 17632 1
INSERT 17633 1
INSERT 17634 1
INSERT 17635 1
INSERT 17636 1
INSERT 17637 1
INSERT 17638 1
INSERT 17639 1
INSERT 17640 1
INSERT 17641 1
INSERT 17642 1
INSERT 17643 1
INSERT 17644 1
INSERT 17645 1
INSERT 17646 1
INSERT 17647 1
INSERT 17648 1
INSERT 17649 1
INSERT 17650 1
INSERT 17651 1
INSERT 17652 1
INSERT 17653 1
INSERT 17654 1
INSERT 17655 1
INSERT 17656 1
INSERT 17657 1
INSERT 17658 1
INSERT 17659 1
INSERT 17660 1
INSERT 17661 1
INSERT 17662 1
INSERT 17663 1
INSERT 17664 1
INSERT 17665 1
INSERT 17666 1
INSERT 17667 1
INSERT 17668 1
INSERT 17669 1
INSERT 17670 1
INSERT 17671 1
INSERT 17672 1
INSERT 17673 1
INSERT 17674 1
INSERT 17675 1
INSERT 17676 1
INSERT 17677 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1648: NOTICE:  CREATE TABLE will create implicit sequence "cc_alarm_id_seq" for serial column "cc_alarm.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1650: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_alarm_pkey" for table "cc_alarm"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1657: NOTICE:  CREATE TABLE will create implicit sequence "cc_alarm_report_id_seq" for serial column "cc_alarm_report.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1659: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_alarm_report_pkey" for table "cc_alarm_report"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1687: NOTICE:  CREATE TABLE will create implicit sequence "cc_callback_spool_id_seq" for serial column "cc_callback_spool.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1690: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_callback_spool_pkey" for table "cc_callback_spool"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1692: NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index "cc_callback_spool_uniqueid_key" for table "cc_callback_spool"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1703: NOTICE:  CREATE TABLE will create implicit sequence "cc_server_manager_id_seq" for serial column "cc_server_manager.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1705: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_server_manager_pkey" for table "cc_server_manager"
ALTER TABLE
INSERT 17737 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1713: NOTICE:  CREATE TABLE will create implicit sequence "cc_server_group_id_seq" for serial column "cc_server_group.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1715: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_server_group_pkey" for table "cc_server_group"
ALTER TABLE
INSERT 17749 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1734: NOTICE:  CREATE TABLE will create implicit sequence "cc_invoices_id_seq" for serial column "cc_invoices.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1737: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_invoices_pkey" for table "cc_invoices"
ALTER TABLE
CREATE INDEX
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1746: NOTICE:  CREATE TABLE will create implicit sequence "cc_invoice_history_id_seq" for serial column "cc_invoice_history.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1748: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_invoice_history_pkey" for table "cc_invoice_history"
ALTER TABLE
CREATE INDEX
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1760: NOTICE:  CREATE TABLE will create implicit sequence "cc_package_offer_id_seq" for serial column "cc_package_offer.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1772: NOTICE:  CREATE TABLE will create implicit sequence "cc_card_package_offer_id_seq" for serial column "cc_card_package_offer.id"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1791: NOTICE:  CREATE TABLE will create implicit sequence "cc_subscription_fee_id_seq" for serial column "cc_subscription_fee.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1793: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_subscription_fee_pkey" for table "cc_subscription_fee"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1819: NOTICE:  CREATE TABLE will create implicit sequence "cc_outbound_cid_group_id_seq" for serial column "cc_outbound_cid_group.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1821: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_outbound_cid_group_pkey" for table "cc_outbound_cid_group"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1830: NOTICE:  CREATE TABLE will create implicit sequence "cc_outbound_cid_list_id_seq" for serial column "cc_outbound_cid_list.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1832: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_outbound_cid_list_pkey" for table "cc_outbound_cid_list"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1846: NOTICE:  CREATE TABLE will create implicit sequence "cc_payment_methods_id_seq" for serial column "cc_payment_methods.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1848: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_payment_methods_pkey" for table "cc_payment_methods"
ALTER TABLE
INSERT 17852 1
INSERT 17853 1
INSERT 17854 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1875: NOTICE:  CREATE TABLE will create implicit sequence "cc_payments_id_seq" for serial column "cc_payments.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1878: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_payments_pkey" for table "cc_payments"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1885: NOTICE:  CREATE TABLE will create implicit sequence "cc_payments_status_id_seq" for serial column "cc_payments_status.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1887: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_payments_status_pkey" for table "cc_payments_status"
ALTER TABLE
INSERT 17875 1
INSERT 17876 1
INSERT 17877 1
INSERT 17878 1
INSERT 17879 1
INSERT 17880 1
INSERT 17881 1
INSERT 17882 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1909: NOTICE:  CREATE TABLE will create implicit sequence "cc_configuration_configuration_id_seq" for serial column "cc_configuration.configuration_id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1911: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_configuration_id_pkey" for table "cc_configuration"
ALTER TABLE
INSERT 17895 1
INSERT 17896 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1916: WARNING:  nonstandard use of \' in a string literal
LINE 1: ...', 'Transaction mode used for processing orders', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17897 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1917: WARNING:  nonstandard use of \' in a string literal
LINE 1: ... 'Transaction method used for processing orders', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17898 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1918: WARNING:  nonstandard use of \' in a string literal
LINE 1: ...Authorize.Net e-mail a receipt to the customer?', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17899 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1919: WARNING:  nonstandard use of \' in a string literal
LINE 1: ... 'Do you want to accept Authorize.net payments?', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17900 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1921: WARNING:  nonstandard use of \' in a string literal
LINE 1: ... 'True', 'Do you want to accept PayPal payments?','tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17901 1
INSERT 17902 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1923: WARNING:  nonstandard use of \' in a string literal
LINE 1: ...he currency to use for credit card transactions', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17903 1
INSERT 17904 1
INSERT 17905 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1927: WARNING:  nonstandard use of \' in a string literal
LINE 1: ...e default currency for the payment transactions', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17906 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1928: WARNING:  nonstandard use of \' in a string literal
LINE 1: ...e default language for the payment transactions', 'tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17907 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1929: WARNING:  nonstandard use of \' in a string literal
LINE 1: ...', 'Do you want to accept moneybookers payments?','tep_cfg_s...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').
INSERT 17908 1
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1942: NOTICE:  CREATE TABLE will create implicit sequence "cc_epayment_log_id_seq" for serial column "cc_epayment_log.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1944: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_epayment_log_pkey" for table "cc_epayment_log"
ALTER TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1957: NOTICE:  CREATE TABLE will create implicit sequence "cc_system_log_id_seq" for serial column "cc_system_log.id"
CREATE TABLE
psql:/usr/src/a2billing/DataBase/psql/a2billing-pgsql-schema-v1.3.0.sql:1959: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "cc_system_log_pkey" for table "cc_system_log"
ALTER TABLE

and when i try to verify it with

Code:

psql -d a2billing -U a2billinguser -W

i end up simply in
a2billing-#
with no verification !!

provided by Star2Billing S.L.

assistance needed

Who is online