[OpenSER-Devel] [ openser-Bugs-1896045 ] Postgres DB Init not working

[SourceForge.net]

Bugs item #1896045, was opened at 2008-02-18 12:12
Message generated for change (Comment added) made by henningw
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1896045&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: tools
Group: ver 1.3.x
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Henning Westerholt (henningw)
Summary: Postgres DB Init not working

Initial Comment:
Hi, using 1.3.0, 1.3 SVN or trunk I am unable to create the postgres database and tables. Attached is the output when running ./openserdbctl create.
I am running postgres 8.1

The dialog table is not in the openser database.

I verified that dialog-create.sql in /usr/local/share/openser/postgres exists.

At one occasion I was able to pass creation of dialog, but it then stopped at "dispatcher" with similar errors.


mikael at bjerkeland.com

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

>Comment By: Henning Westerholt (henningw)
Date: 2008-02-18 12:43

Message:
Logged In: YES 
user_id=337916
Originator: NO

Fix confirmed on IRC, closes the bug.

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

Comment By: Henning Westerholt (henningw)
Date: 2008-02-18 12:35

Message:
Logged In: YES 
user_id=337916
Originator: NO

The (uncommented) STANDARD_TABLES variable that was placed in the
openserctlrc file was not up to date.
So if you use postgres and remove the comments from this variable you
probably run into this error.
I've tested this, and could reproduce the script output you've attached on
my system.

I've commited a fix to svn trunk and 1.3 branch, could you please test
again?

Henning

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

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