[freeside] Output from freeside-daily

[Stephen Bechard]

It appears that the freeside-daily script is attempting
to vacuum the freeside database, which can only be done
by the owner of the database/tables. Try to following...

hostname$ psql freeside

Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

freeside=# \dt

            List of relations
         Name         | Type  |  Owner
----------------------+-------+----------
 agent                | table | freeside
 agent_type           | table | freeside
 cust_bill            | table | freeside
 cust_bill_event      | table | freeside
 cust_bill_pay        | table | freeside
 cust_bill_pkg        | table | freeside

<SNIP>

 h_cust_svc           | table | freeside
 h_cust_tax_exempt    | table | freeside
 h_domain_record      | table | freeside
 h_export_svc         | table | freeside
 h_msgcat             | table | freeside
freeside=#

If these tables are not owner by the user you
are running the script as it will not be able
to vacuum the database.

Hope this helps,
Steve


----- Original Message ----- 
From: "Timothy M. Butkiewicz" <tbutkiewicz at cyberMIND.biz>
To: <ivan-freeside at sisd.com>
Sent: Tuesday, December 03, 2002 10:52 PM
Subject: RE: [freeside] Output from freeside-daily



When running (below) I was running out of cron as user freeside.

....

When I run the cron as root I get the following:

Output from command /usr/bin/freeside-daily freeside ..

Not running uid freeside! at /usr/bin/freeside-daily line 19

....

When suing to freeside and running the script I get the following:
 su freeside
[freeside at snyder william]$ /usr/bin/freeside-daily freeside
NOTICE:  Skipping "pg_type" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_attribute" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_class" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_group" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_database" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_attrdef" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_trigger" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_inherits" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_index" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_operator" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_opclass" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_am" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_amop" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_amproc" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_language" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_largeobject" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_aggregate" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_ipl" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_inheritproc" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_description" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_listener" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_shadow" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_proc" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_relcheck" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_rewrite" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_statistic" --- only table owner can VACUUM it
NOTICE:  Skipping "part_svc" --- only table owner can VACUUM it
NOTICE:  Skipping "svc_acct_sm" --- only table owner can VACUUM it
NOTICE:  Skipping "cust_bill_event" --- only table owner can VACUUM it
NOTICE:  Skipping "radreply" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_type" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_attribute" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_class" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_group" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_database" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_attrdef" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_trigger" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_inherits" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_index" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_operator" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_opclass" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_am" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_amop" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_amproc" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_language" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_largeobject" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_aggregate" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_ipl" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_inheritproc" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_description" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_listener" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_shadow" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_proc" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_relcheck" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_rewrite" --- only table owner can VACUUM it
NOTICE:  Skipping "pg_statistic" --- only table owner can VACUUM it
NOTICE:  RegisterSharedInvalid: SI buffer overflow
NOTICE:  InvalidateSharedInvalid: cache state reset
NOTICE:  Skipping "part_svc" --- only table owner can VACUUM it
NOTICE:  Skipping "svc_acct_sm" --- only table owner can VACUUM it
NOTICE:  Skipping "cust_bill_event" --- only table owner can VACUUM it
NOTICE:  Skipping "radreply" --- only table owner can VACUUM it


+----------------------------
Timothy M. Butkiewicz
 Director of Office Technologies
 cyberM.I.N.D.
 877.373.6680 x 20
 269.373.6680 x 20
 www.cybermind.biz
 www.cybermind-usa.net 

-----Original Message-----
From: zeroneg [mailto:zeroneg at pop3.junct.com]
Sent: Tuesday, December 03, 2002 11:31 AM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] Output from freeside-daily


This might sound dumb, but what if you were to use 'su
freeside' and
then run the command.  Of course the 'freeside' item is the
user that
you setup for freeside.


Just a thought.

-Andrew Dawes, Sr. Engineer

> 
> Anyone have any idea what this might mean?
> 
> Output from command /usr/bin/freeside-daily freeside ..
> 
> NOTICE:  Skipping "pg_type" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_attribute" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_class" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_group" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_database" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_attrdef" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_trigger" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_inherits" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_index" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_operator" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_opclass" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_am" --- only table owner can VACUUM
> it
> NOTICE:  Skipping "pg_amop" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_amproc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_language" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_largeobject" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_aggregate" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_ipl" --- only table owner can VACUUM
> it
> NOTICE:  Skipping "pg_inheritproc" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_description" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_listener" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_shadow" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_proc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_relcheck" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_rewrite" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_statistic" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "part_svc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "svc_acct_sm" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "cust_bill_event" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "radreply" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_type" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_attribute" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_class" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_group" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_database" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_attrdef" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_trigger" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_inherits" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_index" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_operator" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_opclass" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_am" --- only table owner can VACUUM
> it
> NOTICE:  Skipping "pg_amop" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_amproc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_language" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_largeobject" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_aggregate" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_ipl" --- only table owner can VACUUM
> it
> NOTICE:  Skipping "pg_inheritproc" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_description" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_listener" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_shadow" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_proc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_relcheck" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_rewrite" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_statistic" --- only table owner can
> VACUUM it
> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  InvalidateSharedInvalid: cache state reset
> NOTICE:  Skipping "part_svc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "svc_acct_sm" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "cust_bill_event" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "radreply" --- only table owner can
> VACUUM it
> 
> 
> 
> +---------------------------- 
> Timothy M. Butkiewicz 
>  Director of Office Technologies 
>  cyberM.I.N.D. 
>  877.373.6680 x 20 
>  269.373.6680 x 20 
>  www.cybermind.biz 
>  www.cybermind-usa.net 
> 
> ----------------------------------------
> This mail sent through cyberMIND webMAIL
> webmail.cybermind-usa.net
>