[Devel] CVS commitlog: sip-server/scripts postgresqldb.sh
Klaus Darilion
klaus.mailinglists at pernau.at
Mon Jul 17 17:24:17 CEST 2006
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
>>>>
>>>>
>>>>
>>>
>>
>
More information about the Devel
mailing list