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

[Bogdan-Andrei Iancu]

Klaus,

for some strange reasons the "active_sessions" definition was replaced 
with a second  definition of "usr_preferences_types". I fixed this on 
the CVS.
please test and let me know if know works correctly.

Also I was wondering if the SERWEB related stuff makes any sense for 
postgres since serweb has only mysql support (as least when I checked 
last time).

regards,
bogdan


Klaus Darilion wrote:

> 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
>>>
>>>
>>>
>>
>