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

[Klaus Darilion]

Bogdan-Andrei Iancu wrote:
> 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.

wrong comments, applies now without errors

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

Last time (I tried with an old CVS version of serweb) it worked against 
postgresql. Thus, I suggest to leave the serweb tables inside.

regards
klaus

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