[Devel] [ openser-Bugs-1522182 ] Postgres errors during installation

[SourceForge.net]

Bugs item #1522182, was opened at 2006-07-14 01:11
Message generated for change (Comment added) made by klaus_darilion
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1522182&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: core
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Submitted By: Norman Brandinger (goestelecom)
Assigned to: Nobody/Anonymous (nobody)
Summary: Postgres errors during installation

Initial Comment:
During a new database installation using
openser_postgresql.sh create, the following errors are
generated:

ERROR:  syntax error at or near "(" at character 84
LINE 5:   id bigint(20) NOT NULL auto_increment,
                   ^
ERROR:  relation "sip_trace" does not exist
ERROR:  relation "sip_trace" does not exist
ERROR:  relation "sip_trace" does not exist
ERROR:  relation "sip_trace" does not exist
INSERT 0 1
ERROR:  relation "admin_privileges" does not exist
ERROR:  relation "admin_privileges" does not exist
ERROR:  role "openser" already exists
ERROR:  role "openserro" already exists
ERROR:  relation "active_sessions" does not exist
ERROR:  relation "active_sessions" does not exist

Regards,
Norm

----------------------------------------------------------------------

>Comment By: Klaus Darilion (klaus_darilion)
Date: 2006-07-14 16:42

Message:
Logged In: YES 
user_id=1318360

Where is the mentioned patch2?


----------------------------------------------------------------------

Comment By: Norman Brandinger (goestelecom)
Date: 2006-07-14 06:04

Message:
Logged In: YES 
user_id=1372252

The attached patch2 appears to resolve these errors as well
as the issue in item 1522180.

----------------------------------------------------------------------

Comment By: Norman Brandinger (goestelecom)
Date: 2006-07-14 01:15

Message:
Logged In: YES 
user_id=1372252

A review of the logs showed a couple of additional errors. 
Below are the last few log messages showing all of the errors:


CREATE TABLE
ERROR:  syntax error at or near "(" at character 97
LINE 5:   id bigint(20) NOT NULL auto_increment,
                   ^
ERROR:  syntax error at or near "(" at character 217
LINE 9:   INDEX ip_addr (src_ip)
                        ^
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
index "speed_dial_pkey" for table "speed_dial"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
index "gw_pkey" for table "gw"
CREATE TABLE
CREATE INDEX
NOTICE:  CREATE TABLE will create implicit sequence
"gw_grp_grp_id_seq" for serial column "gw_grp.grp_id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
index "gw_grp_pkey" for table "gw_grp"
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE FUNCTION
CREATE FUNCTION
ERROR:  syntax error at or near "(" at character 84
LINE 5:   id bigint(20) NOT NULL auto_increment,
                   ^
ERROR:  relation "sip_trace" does not exist
ERROR:  relation "sip_trace" does not exist
ERROR:  relation "sip_trace" does not exist
ERROR:  relation "sip_trace" does not exist
INSERT 0 1
ERROR:  relation "admin_privileges" does not exist
ERROR:  relation "admin_privileges" does not exist
ERROR:  role "openser" already exists
ERROR:  role "openserro" already exists
ERROR:  relation "active_sessions" does not exist
ERROR:  relation "active_sessions" does not exist
Install SERWEB tables ?(y/n):


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1522182&group_id=139143