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 !!