[freeside] fs-setup - (*Sigh*) - Fixed but now another issue

[Randall Lucas]

Hi Deepak,

1. You REALLY don't want to set your postgres up like that.  Just set 
it up for md5.

2. The sequence already exists.  You've probably already run that 
script.  DROP DATABASE freeside / CREATE DATABASE freeside to start it 
over.

Randall



On Thursday, July 10, 2003, at 09:13 AM, Lal, Deepak (Contractor) wrote:

> Quick update:
>
>  
>
> The previous problem fixed as follows:
>
>  
>
> Seemingly the client was trying to connect to the server as 127.0.0.1, 
> which is the locahost. But somehow the "local" entry in pg_hba.conf 
> was not sufficent. I had to add "host all 127.0.0.1 255.255.255.255 
> trust" entry to
>
> ph_hba.conf.
>
>  
>
> in addition, I had to start the postmaster with the "-i" option.
>
>  
>
> It worked and created all tables for user "freeside"
>
>  
>
> But I had also a user "dlal" created. Now when I do
>
>  
>
> bin/fs-setup dlal, I get the following error:
>
>  
>
>  
>
> 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' DBD::Pg::db do failed: 
> ERROR:  Relation 'h_cust_bill_historynum_seq' already exists at 
> bin/fs-setup line 234. CREATE error: ERROR:  Relation 
> 'h_cust_bill_historynum_seq' already exists doing statement: CREATE 
> TABLE h_cust_bill (
>
>   historynum serial NOT NULL  ,
>
>   history_date int   ,
>
>   history_user varchar(80) NOT NULL  ,
>
>   history_action varchar(80) NOT NULL  ,
>
>   invnum int NOT NULL  ,
>
>   custnum int NOT NULL  ,
>
>   _date int   ,
>
>   charged decimal(10,2) NOT NULL  ,
>
>   printed int NOT NULL  ,
>
>   closed char(1)   ,
>
>   PRIMARY KEY (historynum)
>
> )
>
>  
>
>  
>
>  
>
> Any suggestions ???
>
>  
>
> Thanks
>
>  
>
> Deepak
>
>  
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 5063 bytes
Desc: not available
Url : http://420.am/pipermail/freeside-users/attachments/20030710/e90ea58e/attachment.bin