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 <[EMAIL PROTECTED]>
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@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
