[Devel] CVS commitlog: sip-server/scripts postgresqldb.sh

[Klaus Darilion]

Bogdan-Andrei Iancu wrote:
> There was a small fix for serweb table after this patch -  see the 
> history file. Is the last CVS version working properly? if not please 
> detail what is not working.

Sorry - forgotten to paste the error messages (I used the newest version 
1.34).

regards
klaus

Install SERWEB tables ?(y/n):y
creating serweb tables into openser ...
You are now connected to database "openser".
INSERT 18862 1
INSERT 18863 1
INSERT 18864 1
INSERT 18865 1
INSERT 18866 1
INSERT 18867 1
INSERT 18868 1
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"usr_preferences_types_pkey" for table "usr_preferences_types"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"pending_pkey" for table "pending"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pending_phplib_id_key" for table "pending"
CREATE TABLE
CREATE INDEX
NOTICE:  CREATE TABLE will create implicit sequence "phonebook_id_seq" 
for "serial" column "phonebook.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"phonebook_pkey" for table "phonebook"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"server_monitoring_pkey" for table "server_monitoring"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"usr_preferences_types_pkey" for table "usr_preferences_types"
ERROR:  relation "usr_preferences_types" already exists

^^^^^^

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"server_monitoring_agg_pkey" for table "server_monitoring_agg"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"admin_privileges_pkey" for table "admin_privileges"
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
INSERT 18952 1
INSERT 18953 1
ERROR:  relation "active_sessions" does not exist
ERROR:  relation "active_sessions" does not exist

^^^^^^

> regards,
> bogdan
> 
> Klaus Darilion wrote:
> 
>> btw: There are still problems for serweb.
>>
>> regards
>> klaus
>>
>> Klaus Darilion wrote:
>>
>>> please backport to 1.1
>>>
>>> regards
>>> klaus
>>>
>>> Bogdan-Andrei Iancu wrote:
>>>
>>>> User: bogdan_iancu
>>>> Date: 2006/07/14 10:28:57 PDT
>>>>
>>>>   OpenSER CVS - Commit Details
>>>>
>>>>   Modified files:
>>>>     scripts              postgresqldb.sh   Commit Log:
>>>>   Applied path for correcting syntax from MySQL to Postgres:
>>>>    - moved INDEX creation out of CREATE table statement into
>>>>      CREATE INDEX (usr_preferences, trusted)
>>>>    - auto_increment isn't valid in Postgres, replaced with
>>>>      local AUTO_INCREMENT
>>>>    - datetime isn't valid in Postgres, replaced with local DATETIME
>>>>    - split GRANTs for SERWeb tables so that it is only executed
>>>>      if SERWeb tables are created
>>>>    - added GRANTs for re_grp table
>>>>    - added CREATE pd_multidomain table (from PDT module)
>>>>    - corrected comments to indicate Postgres as opposed to MySQL
>>>>    - made last_modified/created stamps consistent to now() using
>>>>      local TIMESTAMP
>>>>      Credits go to Norman Brandinger <norm at goes.com>
>>>>    Closes 1522180, 1522182, 1522303
>>>>     Revision  Changes    Path
>>>>   1.33      +75 -48    sip-server/scripts/postgresqldb.sh
>>>>    [ 
>>>> http://openser.cvs.sourceforge.net/openser/sip-server/scripts/postgresqldb.sh?r1=1.32&r2=1.33 
>>>> ]
>>>>
>>>> _______________________________________________
>>>> Devel mailing list
>>>> Devel at openser.org
>>>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>>
>>>
>>>
>>> _______________________________________________
>>> Devel mailing list
>>> Devel at openser.org
>>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>
>>
>