[freeside-users] Problems with new freeside installation
Dan Roberts
dan at eastsierra.net
Mon Nov 21 13:03:30 PST 2005
Here's complete output frm freeside-setup:
freeside at parkerpeak:/usr/local/src/freeside-1.5.7$ freeside-setup dan
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_bill_historynum_seq" for serial column "h_cust_bill.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_bill_pkey" for table "h_cust_bill"
NOTICE: CREATE TABLE will create implicit sequence
"cust_bill_pkg_detail_detailnum_seq" for serial column
"cust_bill_pkg_detail.detailnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_bill_pkg_detail_pkey" for table "cust_bill_pkg_detail"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_pay_void_historynum_seq" for serial column
"h_cust_pay_void.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_pay_void_pkey" for table "h_cust_pay_void"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_svc_historynum_seq" for serial column "h_part_svc.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_svc_pkey" for table "h_part_svc"
NOTICE: CREATE TABLE will create implicit sequence
"cust_refund_refundnum_seq" for serial column "cust_refund.refundnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_refund_pkey" for table "cust_refund"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_external_historynum_seq" for serial column
"h_svc_external.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_external_pkey" for table "h_svc_external"
NOTICE: CREATE TABLE will create implicit sequence
"rate_detail_ratedetailnum_seq" for serial column
"rate_detail.ratedetailnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"rate_detail_pkey" for table "rate_detail"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_credit_historynum_seq" for serial column "h_cust_credit.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_credit_pkey" for table "h_cust_credit"
NOTICE: CREATE TABLE will create implicit sequence
"h_acct_snarf_historynum_seq" for serial column "h_acct_snarf.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_acct_snarf_pkey" for table "h_acct_snarf"
NOTICE: CREATE TABLE will create implicit sequence
"cust_svc_svcnum_seq" for serial column "cust_svc.svcnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_svc_pkey" for table "cust_svc"
NOTICE: CREATE TABLE will create implicit sequence
"h_rate_historynum_seq" for serial column "h_rate.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_rate_pkey" for table "h_rate"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_domain_historynum_seq" for serial column "h_svc_domain.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_domain_pkey" for table "h_svc_domain"
NOTICE: CREATE TABLE will create implicit sequence "rate_ratenum_seq"
for serial column "rate.ratenum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"rate_pkey" for table "rate"
NOTICE: CREATE TABLE will create implicit sequence
"part_export_option_optionnum_seq" for serial column
"part_export_option.optionnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_export_option_pkey" for table "part_export_option"
NOTICE: CREATE TABLE will create implicit sequence
"session_sessionnum_seq" for serial column "session.sessionnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"session_pkey" for table "session"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_svc_column_historynum_seq" for serial column
"h_part_svc_column.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_svc_column_pkey" for table "h_part_svc_column"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_forward_historynum_seq" for serial column "h_svc_forward.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_forward_pkey" for table "h_svc_forward"
NOTICE: CREATE TABLE will create implicit sequence
"cust_main_county_taxnum_seq" for serial column "cust_main_county.taxnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_main_county_pkey" for table "cust_main_county"
NOTICE: CREATE TABLE will create implicit sequence
"svc_acct_pop_popnum_seq" for serial column "svc_acct_pop.popnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_acct_pop_pkey" for table "svc_acct_pop"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_credit_bill_historynum_seq" for serial column
"h_cust_credit_bill.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_credit_bill_pkey" for table "h_cust_credit_bill"
NOTICE: CREATE TABLE will create implicit sequence
"h_agent_type_historynum_seq" for serial column "h_agent_type.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_agent_type_pkey" for table "h_agent_type"
NOTICE: CREATE TABLE will create implicit sequence
"cust_bill_pay_billpaynum_seq" for serial column "cust_bill_pay.billpaynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_bill_pay_pkey" for table "cust_bill_pay"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_www_historynum_seq" for serial column "h_svc_www.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_www_pkey" for table "h_svc_www"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_svc_historynum_seq" for serial column "h_cust_svc.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_svc_pkey" for table "h_cust_svc"
NOTICE: CREATE TABLE will create implicit sequence
"export_svc_exportsvcnum_seq" for serial column "export_svc.exportsvcnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"export_svc_pkey" for table "export_svc"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_tax_exempt_historynum_seq" for serial column
"h_cust_tax_exempt.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_tax_exempt_pkey" for table "h_cust_tax_exempt"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_referral_historynum_seq" for serial column
"h_part_referral.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_referral_pkey" for table "h_part_referral"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_pay_refund_historynum_seq" for serial column
"h_cust_pay_refund.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_pay_refund_pkey" for table "h_cust_pay_refund"
NOTICE: CREATE TABLE will create implicit sequence
"h_reg_code_pkg_historynum_seq" for serial column
"h_reg_code_pkg.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_reg_code_pkg_pkey" for table "h_reg_code_pkg"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_www_pkey" for table "svc_www"
NOTICE: CREATE TABLE will create implicit sequence "queue_jobnum_seq"
for serial column "queue.jobnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"queue_pkey" for table "queue"
NOTICE: CREATE TABLE will create implicit sequence
"agent_type_typenum_seq" for serial column "agent_type.typenum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"agent_type_pkey" for table "agent_type"
NOTICE: CREATE TABLE will create implicit sequence
"cust_credit_bill_creditbillnum_seq" for serial column
"cust_credit_bill.creditbillnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_credit_bill_pkey" for table "cust_credit_bill"
NOTICE: CREATE TABLE will create implicit sequence
"part_pkg_pkgpart_seq" for serial column "part_pkg.pkgpart"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_pkg_pkey" for table "part_pkg"
NOTICE: CREATE TABLE will create implicit sequence
"cust_pay_batch_paybatchnum_seq" for serial column
"cust_pay_batch.paybatchnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_pay_batch_pkey" for table "cust_pay_batch"
NOTICE: CREATE TABLE will create implicit sequence
"h_pkg_svc_historynum_seq" for serial column "h_pkg_svc.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_pkg_svc_pkey" for table "h_pkg_svc"
NOTICE: CREATE TABLE will create implicit sequence
"clientapi_session_field_fieldnum_seq" for serial column
"clientapi_session_field.fieldnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"clientapi_session_field_pkey" for table "clientapi_session_field"
NOTICE: CREATE TABLE will create implicit sequence
"clientapi_session_sessionnum_seq" for serial column
"clientapi_session.sessionnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"clientapi_session_pkey" for table "clientapi_session"
NOTICE: CREATE TABLE will create implicit sequence
"cust_main_invoice_destnum_seq" for serial column
"cust_main_invoice.destnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_main_invoice_pkey" for table "cust_main_invoice"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_broadband_historynum_seq" for serial column
"h_svc_broadband.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_broadband_pkey" for table "h_svc_broadband"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_refund_historynum_seq" for serial column "h_cust_refund.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_refund_pkey" for table "h_cust_refund"
NOTICE: CREATE TABLE will create implicit sequence
"h_nas_historynum_seq" for serial column "h_nas.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_nas_pkey" for table "h_nas"
NOTICE: CREATE TABLE will create implicit sequence
"h_queue_depend_historynum_seq" for serial column
"h_queue_depend.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_queue_depend_pkey" for table "h_queue_depend"
NOTICE: CREATE TABLE will create implicit sequence
"h_rate_detail_historynum_seq" for serial column "h_rate_detail.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_rate_detail_pkey" for table "h_rate_detail"
NOTICE: CREATE TABLE will create implicit sequence
"reg_code_codenum_seq" for serial column "reg_code.codenum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"reg_code_pkey" for table "reg_code"
NOTICE: CREATE TABLE will create implicit sequence
"h_addr_block_historynum_seq" for serial column "h_addr_block.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_addr_block_pkey" for table "h_addr_block"
NOTICE: CREATE TABLE will create implicit sequence
"part_referral_refnum_seq" for serial column "part_referral.refnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_referral_pkey" for table "part_referral"
NOTICE: CREATE TABLE will create implicit sequence
"cust_pay_paynum_seq" for serial column "cust_pay.paynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_pay_pkey" for table "cust_pay"
NOTICE: CREATE TABLE will create implicit sequence
"pkg_svc_pkgsvcnum_seq" for serial column "pkg_svc.pkgsvcnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"pkg_svc_pkey" for table "pkg_svc"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"acct_snarf_pkey" for table "acct_snarf"
NOTICE: CREATE TABLE will create implicit sequence
"h_port_historynum_seq" for serial column "h_port.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_port_pkey" for table "h_port"
NOTICE: CREATE TABLE will create implicit sequence
"virtual_field_vfieldnum_seq" for serial column "virtual_field.vfieldnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"virtual_field_pkey" for table "virtual_field"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_virtual_field_pkey" for table "part_virtual_field"
NOTICE: CREATE TABLE will create implicit sequence
"h_queue_historynum_seq" for serial column "h_queue.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_queue_pkey" for table "h_queue"
NOTICE: CREATE TABLE will create implicit sequence
"reg_code_pkg_codepkgnum_seq" for serial column "reg_code_pkg.codepkgnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"reg_code_pkg_pkey" for table "reg_code_pkg"
NOTICE: CREATE TABLE will create implicit sequence
"router_routernum_seq" for serial column "router.routernum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"router_pkey" for table "router"
NOTICE: CREATE TABLE will create implicit sequence
"queue_arg_argnum_seq" for serial column "queue_arg.argnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"queue_arg_pkey" for table "queue_arg"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_virtual_field_historynum_seq" for serial column
"h_part_virtual_field.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_virtual_field_pkey" for table "h_part_virtual_field"
NOTICE: CREATE TABLE will create implicit sequence "agent_agentnum_seq"
for serial column "agent.agentnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"agent_pkey" for table "agent"
NOTICE: CREATE TABLE will create implicit sequence
"h_radius_usergroup_historynum_seq" for serial column
"h_radius_usergroup.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_radius_usergroup_pkey" for table "h_radius_usergroup"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_domain_pkey" for table "svc_domain"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_main_historynum_seq" for serial column "h_cust_main.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_main_pkey" for table "h_cust_main"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_forward_pkey" for table "svc_forward"
NOTICE: CREATE TABLE will create implicit sequence
"domain_record_recnum_seq" for serial column "domain_record.recnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"domain_record_pkey" for table "domain_record"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_main_invoice_historynum_seq" for serial column
"h_cust_main_invoice.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_main_invoice_pkey" for table "h_cust_main_invoice"
NOTICE: CREATE TABLE will create implicit sequence
"h_session_historynum_seq" for serial column "h_session.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_session_pkey" for table "h_session"
NOTICE: CREATE TABLE will create implicit sequence
"rate_prefix_prefixnum_seq" for serial column "rate_prefix.prefixnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"rate_prefix_pkey" for table "rate_prefix"
NOTICE: CREATE TABLE will create implicit sequence
"part_pop_local_localnum_seq" for serial column "part_pop_local.localnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_pop_local_pkey" for table "part_pop_local"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_acct_pop_historynum_seq" for serial column
"h_svc_acct_pop.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_acct_pop_pkey" for table "h_svc_acct_pop"
NOTICE: CREATE TABLE will create implicit sequence
"part_bill_event_eventpart_seq" for serial column
"part_bill_event.eventpart"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_bill_event_pkey" for table "part_bill_event"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_pkg_historynum_seq" for serial column "h_cust_pkg.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_pkg_pkey" for table "h_cust_pkg"
NOTICE: CREATE TABLE will create implicit sequence
"addr_block_blocknum_seq" for serial column "addr_block.blocknum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"addr_block_pkey" for table "addr_block"
NOTICE: CREATE TABLE will create implicit sequence "msgcat_msgnum_seq"
for serial column "msgcat.msgnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"msgcat_pkey" for table "msgcat"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_pop_local_historynum_seq" for serial column
"h_part_pop_local.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_pop_local_pkey" for table "h_part_pop_local"
NOTICE: CREATE TABLE will create implicit sequence
"cust_credit_refund_creditrefundnum_seq" for serial column
"cust_credit_refund.creditrefundnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_credit_refund_pkey" for table "cust_credit_refund"
NOTICE: CREATE TABLE will create implicit sequence
"h_agent_historynum_seq" for serial column "h_agent.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_agent_pkey" for table "h_agent"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_svc_router_historynum_seq" for serial column
"h_part_svc_router.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_svc_router_pkey" for table "h_part_svc_router"
NOTICE: CREATE TABLE will create implicit sequence
"h_queue_arg_historynum_seq" for serial column "h_queue_arg.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_queue_arg_pkey" for table "h_queue_arg"
NOTICE: CREATE TABLE will create implicit sequence
"queue_depend_dependnum_seq" for serial column "queue_depend.dependnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"queue_depend_pkey" for table "queue_depend"
NOTICE: CREATE TABLE will create implicit sequence
"cust_bill_pkg_billpkgnum_seq" for serial column "cust_bill_pkg.billpkgnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_bill_pkg_pkey" for table "cust_bill_pkg"
NOTICE: CREATE TABLE will create implicit sequence "port_portnum_seq"
for serial column "port.portnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"port_pkey" for table "port"
NOTICE: CREATE TABLE will create implicit sequence
"h_reg_code_historynum_seq" for serial column "h_reg_code.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_reg_code_pkey" for table "h_reg_code"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_credit_refund_historynum_seq" for serial column
"h_cust_credit_refund.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_credit_refund_pkey" for table "h_cust_credit_refund"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_pkg_historynum_seq" for serial column "h_part_pkg.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_pkg_pkey" for table "h_part_pkg"
NOTICE: CREATE TABLE will create implicit sequence
"h_domain_record_historynum_seq" for serial column
"h_domain_record.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_domain_record_pkey" for table "h_domain_record"
NOTICE: CREATE TABLE will create implicit sequence
"type_pkgs_typepkgnum_seq" for serial column "type_pkgs.typepkgnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"type_pkgs_pkey" for table "type_pkgs"
NOTICE: CREATE TABLE will create implicit sequence
"cust_bill_event_eventnum_seq" for serial column "cust_bill_event.eventnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_bill_event_pkey" for table "cust_bill_event"
NOTICE: CREATE TABLE will create implicit sequence
"cust_credit_crednum_seq" for serial column "cust_credit.crednum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_credit_pkey" for table "cust_credit"
NOTICE: CREATE TABLE will create implicit sequence "nas_nasnum_seq" for
serial column "nas.nasnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"nas_pkey" for table "nas"
NOTICE: CREATE TABLE will create implicit sequence
"part_export_exportnum_seq" for serial column "part_export.exportnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_export_pkey" for table "part_export"
NOTICE: CREATE TABLE will create implicit sequence
"h_router_historynum_seq" for serial column "h_router.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_router_pkey" for table "h_router"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_pay_historynum_seq" for serial column "h_cust_pay.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_pay_pkey" for table "h_cust_pay"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_export_historynum_seq" for serial column "h_part_export.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_export_pkey" for table "h_part_export"
NOTICE: CREATE TABLE will create implicit sequence
"h_virtual_field_historynum_seq" for serial column
"h_virtual_field.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_virtual_field_pkey" for table "h_virtual_field"
NOTICE: CREATE TABLE will create implicit sequence
"cust_bill_invnum_seq" for serial column "cust_bill.invnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_bill_pkey" for table "cust_bill"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_pkg_option_historynum_seq" for serial column
"h_part_pkg_option.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_pkg_option_pkey" for table "h_part_pkg_option"
NOTICE: CREATE TABLE will create implicit sequence
"part_pkg_option_optionnum_seq" for serial column
"part_pkg_option.optionnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_pkg_option_pkey" for table "part_pkg_option"
NOTICE: CREATE TABLE will create implicit sequence
"h_msgcat_historynum_seq" for serial column "h_msgcat.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_msgcat_pkey" for table "h_msgcat"
NOTICE: CREATE TABLE will create implicit sequence
"cust_tax_exempt_exemptnum_seq" for serial column
"cust_tax_exempt.exemptnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_tax_exempt_pkey" for table "cust_tax_exempt"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_bill_pay_historynum_seq" for serial column
"h_cust_bill_pay.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_bill_pay_pkey" for table "h_cust_bill_pay"
NOTICE: CREATE TABLE will create implicit sequence
"cust_main_custnum_seq" for serial column "cust_main.custnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_main_pkey" for table "cust_main"
NOTICE: CREATE TABLE will create implicit sequence
"h_rate_prefix_historynum_seq" for serial column "h_rate_prefix.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_rate_prefix_pkey" for table "h_rate_prefix"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_pay_void_pkey" for table "cust_pay_void"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_acct_pkey" for table "svc_acct"
NOTICE: CREATE TABLE will create implicit sequence
"radius_usergroup_usergroupnum_seq" for serial column
"radius_usergroup.usergroupnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"radius_usergroup_pkey" for table "radius_usergroup"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_export_option_historynum_seq" for serial column
"h_part_export_option.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_export_option_pkey" for table "h_part_export_option"
NOTICE: CREATE TABLE will create implicit sequence
"part_svc_svcpart_seq" for serial column "part_svc.svcpart"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_svc_pkey" for table "part_svc"
NOTICE: CREATE TABLE will create implicit sequence
"prepay_credit_prepaynum_seq" for serial column "prepay_credit.prepaynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"prepay_credit_pkey" for table "prepay_credit"
NOTICE: CREATE TABLE will create implicit sequence
"h_type_pkgs_historynum_seq" for serial column "h_type_pkgs.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_type_pkgs_pkey" for table "h_type_pkgs"
NOTICE: CREATE TABLE will create implicit sequence
"cust_pkg_pkgnum_seq" for serial column "cust_pkg.pkgnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_pkg_pkey" for table "cust_pkg"
NOTICE: CREATE TABLE will create implicit sequence
"h_rate_region_historynum_seq" for serial column "h_rate_region.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_rate_region_pkey" for table "h_rate_region"
NOTICE: CREATE TABLE will create implicit sequence
"h_part_bill_event_historynum_seq" for serial column
"h_part_bill_event.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_part_bill_event_pkey" for table "h_part_bill_event"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_bill_pkg_detail_historynum_seq" for serial column
"h_cust_bill_pkg_detail.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_bill_pkg_detail_pkey" for table "h_cust_bill_pkg_detail"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_main_county_historynum_seq" for serial column
"h_cust_main_county.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_main_county_pkey" for table "h_cust_main_county"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_external_pkey" for table "svc_external"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_bill_event_historynum_seq" for serial column
"h_cust_bill_event.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_bill_event_pkey" for table "h_cust_bill_event"
NOTICE: CREATE TABLE will create implicit sequence
"part_svc_column_columnnum_seq" for serial column
"part_svc_column.columnnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_svc_column_pkey" for table "part_svc_column"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"svc_broadband_pkey" for table "svc_broadband"
NOTICE: CREATE TABLE will create implicit sequence
"rate_region_regionnum_seq" for serial column "rate_region.regionnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"rate_region_pkey" for table "rate_region"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_pay_batch_historynum_seq" for serial column
"h_cust_pay_batch.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_pay_batch_pkey" for table "h_cust_pay_batch"
NOTICE: CREATE TABLE will create implicit sequence
"h_cust_bill_pkg_historynum_seq" for serial column
"h_cust_bill_pkg.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_cust_bill_pkg_pkey" for table "h_cust_bill_pkg"
NOTICE: CREATE TABLE will create implicit sequence
"h_export_svc_historynum_seq" for serial column "h_export_svc.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_export_svc_pkey" for table "h_export_svc"
NOTICE: CREATE TABLE will create implicit sequence
"part_svc_router_svcrouternum_seq" for serial column
"part_svc_router.svcrouternum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"part_svc_router_pkey" for table "part_svc_router"
NOTICE: CREATE TABLE will create implicit sequence
"h_prepay_credit_historynum_seq" for serial column
"h_prepay_credit.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_prepay_credit_pkey" for table "h_prepay_credit"
NOTICE: CREATE TABLE will create implicit sequence
"h_svc_acct_historynum_seq" for serial column "h_svc_acct.historynum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"h_svc_acct_pkey" for table "h_svc_acct"
NOTICE: CREATE TABLE will create implicit sequence
"cust_pay_refund_payrefundnum_seq" for serial column
"cust_pay_refund.payrefundnum"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"cust_pay_refund_pkey" for table "cust_pay_refund"
DBD::Pg::st execute failed: ERROR: column "oid" does not exist
DBD::Pg::st execute failed: ERROR: relation "cust_main_county" does not
exist
ERROR: relation "cust_main_county" does not exist
--Anyone have idea why this happens? sorry I'm not very good at perl
and can't seem to figure this one out on my own
> Ivan, thanks, yes you are correct, the message matches errors logged by
> postgresql. But I believe I'm following your instructions carefully. I
> have only one database to connect to.
>
> After re-examination I believe the problem is occurring during 'make
> install-docs.' During the process, several messages occur saying
> 'cannot resolve perl_function ...' then the error 'no rule to make
> httemplate/*/*/*/*/* needed by masondocs.' The make then fails, and
> exits before creating handler.pl and masondocs.
>
> If I run 'make install-docs' a second time, there is success creating
> masondocs and handler.pl.
>
> But then when 'freeside-setup' is then run, however, I get the error
> 'cust_main_county' does not exist.
>
> After that is when I can bring up the web interface but none of the
> cgi's will execute, as I wrote before.
>
> This sequence is repeatable. After several tries I have gotten pretty
> accomplished at getting Apache,Postgres and all of the perl modules
> installed smoothly on my system but Freeside still won't install.
>
> Any help is appreciated, I am really eager to get this software working
> -- thanks, Dan
>
>
>
> I've re-tried the installation several times; started with a clean
> reformatted hard drive at least three times (even tried installing
> Debian once but got the same result so I went back to slackware. I've
> gotten pretty good at getting all the perl modules &etc to install
> smoothly and the database seems to be created ok.
>
> > On Wed, Nov 16, 2005 at 10:03:51PM +0530, Shivkumar wrote:
> > > I think its in the mailing list somewhere that you have to
downgrade to
> > > HTML::Mason 1.28
> >
> > Only for RT (fixed in CVS and will be in 1.5.8).
> >
> > The error below is coming from Postgres and seems to indicate that the
> > database doesn't exist at all, Perhaps freeside-setup wasn't run or
the
> > connection settings are pointing to the wrong database.
> >
> > --
> > _ivan
> >
> >
> > > Dan Roberts said the following:
> > >
> > > >Hello
> > > >I have been trying for some time to get a freeside 1.5.7 installation
> > > >running. Here's my lates effort:
> > > >
> > > >A freshly formatted hard drive with a clean install of Slackware
10.2.
> > > >Apache_1.3.33 with mod_ssl-2.8.24/openssl-0.9.8a and mod_perl-1.29,
> > > >running as a separate instance of httpd under the user freeside.
> > > >Postgresql-8.1.0 with DBD-Pg-1.43 ok.
> > > >DBI-1.48 and all other perl modules and dependencies carefully
> installed.
> > > >HTML::Mason version 1.3101
> > > >
> > > >After completing all of the installation procedures I can log in
to the
> > > >web browser, go to the configuration page.
> > > >
> > > >But, when I try to access any .cgi pages (such as the next step
in the
> > > >Administration instructions which is "View/Edit Service
> definitions," an
> > > >error message is returned:
> > > >
> > > >*****************************************************************
> > > >System error
> > > >error: ERROR: relation "part_virtual_field" does not exist
> > > >at /usr/lib/perl5/site_perl/5.8.7/FS/Record.pm line 1536
> > > >FS::Record::virtual_fields('FS::part_svc') called at
> > > >/usr/lib/perl5/site_perl/5.8.7/FS/Record.pm line 228
> > > >FS::Record::qsearch('part_svc', 'HASH(0x9b649cc)') called at
> > > >/var/www/freeside/browse/part_svc.cgi line 12
> > > >HTML::Mason::Commands::__ANON__() called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
> > >
>
>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9c61d48)')
> > > >called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line
> 1255
> > > >eval {...} called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
> > > >HTML::Mason::Request::comp('undef', 'undef') called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 916
> > >
>
>HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9c42548)')
> > > >called at /var/www/freeside/autohandler line 1
> > > >HTML::Mason::Commands::__ANON__() called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
> > >
>
>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9c42104)')
> > > >called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line
> 1250
> > > >eval {...} called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
> > > >HTML::Mason::Request::comp('undef', 'undef', 'undef') called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 461
> > > >eval {...} called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 461
> > > >eval {...} called at
> > > >/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 413
> > >
>
>HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9c42548)')
> > > >called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm
> > > >line 167
> > >
>
>HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9c42548)')
> > > >called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm
> > > >line 817
> > >
>
>HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x87a48e8)',
> > > >'Apache=SCALAR(0x9aac87c)') called at
> /usr/local/etc/freeside/handler.pl
> > > >line 306
> > > >eval {...} called at /usr/local/etc/freeside/handler.pl line 306
> > > >HTML::Mason::handler('Apache=SCALAR(0x9aac87c)') called at
> /dev/null line 0
> > > >eval {...} called at /dev/null line 0
> > > >context:
> > > >...
> > > >266: # or simply report the caller's package (croak() and carp()),
> > > >respectively.
> > > >267: # confess() and croak() die, carp() and cluck() warn.
> > > >268:
> > > >269: sub croak { die shortmess @_ }
> > > >270: sub confess { die longmess @_ }
> > > >271: sub carp { warn shortmess @_ }
> > > >272: sub cluck { warn longmess @_ }
> > > >273:
> > > >274: 1;
> > > >...
> > > >code stack: /usr/lib/perl5/5.8.7/Carp.pm:270
> > > >/usr/lib/perl5/site_perl/5.8.7/FS/Record.pm:1536
> > > >/usr/lib/perl5/site_perl/5.8.7/FS/Record.pm:228
> > > >/var/www/freeside/browse/part_svc.cgi:12
> > > >/var/www/freeside/autohandler:1
> > > >*****************************************************************
> > > >
> > > >other .cgi pages return similar errors, mostly starting with the
> > > >phrase-- relation "part_virtual_field" does not exist.
> > > >
> > > >Can you offer any help with this? Much appreciated
> > > >
> > _______________________________________________
> > freeside-users mailing list
> > freeside-users at sisd.com
> > http://420.am/cgi-bin/mailman/listinfo/freeside-users
> >
> >
>
> --
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>
>
--
More information about the freeside-users
mailing list