User: juhe
Date: 2007/02/20 17:50:53 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
modules/lcr lcr_mod.c
Commit Log:
* IP addresses are now kept in dotted string format in gw table.
* LCR mudule should now work al
Hi,
You're right. It is now fixed.
I have changed it to blob because Alex suggested that it is better for
Oracle database.
Anca
Klaus Darilion wrote:
Hi Anca!
There is no "blob" in postgresql. What is the problem with "text" ?
regards
klaus
Anca Vamanu wrote:
User: anca_vamanu
Date: 20
Hi Anca!
There is no "blob" in postgresql. What is the problem with "text" ?
regards
klaus
Anca Vamanu wrote:
User: anca_vamanu
Date: 2007/02/14 01:23:22 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- corrected xca
User: anca_vamanu
Date: 2007/02/14 01:23:22 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- corrected xcap_xml table definition(reported by Helge Waastad )
Revision ChangesPath
1.56 +3 -3 sip-server/
User: anca_vamanu
Date: 2007/02/13 07:59:28 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- changed the scripts for presence tables
- using the patches sent by Aron Rosenberg, adding a new key in
active_watcher
Hi Juha,
as more people are partially using radius support (only auth with no
profile, or only accounting, etc) it will lead to big fragmentation of
the table creationthis will mean problems for the users and to be
honest I prefer to avoid it as much as possible.
regards,
bogdan
Juha He
Bogdan-Andrei Iancu writes:
> - extra - creates tables requied by rare used modules (cpl,
> imc, siptrace, domainpolicy)
this reminds me of at least the following tables that are not needed if
user related information is stored in radius:
- subscriber, grp, re_grp, uri, usr
User: bogdan_iancu
Date: 2007/02/08 04:16:26 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- fixed tables creation - added 2 new classes of tables to be independently
created (on init or later):
- presence -
User: dan_pascu
Date: 2007/02/08 02:12:26 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
Made environment variable names consistent with the ones used by openserctl
Revision ChangesPath
1.53 +21 -21sip
User: bogdan_iancu
Date: 2007/01/12 06:30:24 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- all openser tables have an auto-increment id column as primary key
Closes feature request 1611616.
Revision Changes
User: juhe
Date: 2006/12/19 04:24:33 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
* Added id auto-increment field to trusted table.
Revision ChangesPath
1.48 +3 -2 sip-server/scripts/mysqldb.sh
User: bogdan_iancu
Date: 2006/12/18 02:10:43 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
-fixed several Solaris compatibilities reported by Samwise.
- removed the E grep param - not supported on Solaris
User: klaus_darilion
Date: 2006/12/06 02:29:52 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- changed NOTE to WARNING
Revision ChangesPath
1.46 +4 -2 sip-server/scripts/mysqldb.sh
[
http://opens
User: klaus_darilion
Date: 2006/12/06 02:27:35 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- added a note that a default admin user is created during serwerb table
installation (a default user is always a security i
User: bogdan_iancu
Date: 2006/12/05 10:36:31 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- fixed credentials calculation for admin user in serweb section
Reported by Klaus Darilion <[EMAIL PROTECTED]>
Revision
User: bogdan_iancu
Date: 2006/11/01 08:39:15 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
table format tuning:
- callid field increased from 64 to 128 to avoid truncation
- sip_code switched from varchar to char as i
Hi Norm,
thanks again for your help - the fixup is on the CVS!
Best regards,
Bogdan
Norman Brandinger wrote:
The following change appears to work on PostgreSQL.
/*
* Extend table 'subscriber' with serweb specific columns
*/
ALTER TABLE subscriber
add column phplib_id varchar(32) NOT NULL de
The following change appears to work on PostgreSQL.
/*
* Extend table 'subscriber' with serweb specific columns
*/
ALTER TABLE subscriber
add column phplib_id varchar(32) NOT NULL default '',
add column phone varchar(15) NOT NULL default '',
add column datetime_modified $TIMESTAMP,
add column
Hi,
if some of the postgres users will be willing to test the changes into
"postgresqldb.sh" will be very, very helpful - not sure if the ALTER
TABLE syntax is similar to mysql
regards,
bogdan
Bogdan-Andrei Iancu wrote:
User: bogdan_iancu
Date: 2006/10/27 06:21:54 PDT
OpenSER CVS
User: bogdan_iancu
Date: 2006/10/27 06:21:54 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- subscriber table cleanup:
unused columns dropped (uuid and dom)
added "id" column (autoincrement) as PRIMARY KEY
ser
User: bogdan_iancu
Date: 2006/10/27 04:30:25 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- ACC DB aligned to latest changes in ACC module - from_uri, to_uri and cseq
columns were dropped.
Revision ChangesPat
User: klaus_darilion
Date: 2006/10/24 08:04:17 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- added SQL definitions for domainpolicy table (refer to rEADME of
domainpolicy module)
Revision ChangesPath
1.38
User: juhe
Date: 2006/10/04 22:45:36 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
* Removed unused r_uri column of silo table.
* Added into silo table an index on ($USERNAME, domain).
Revision ChangesPath
User: miconda
Date: 2006/09/29 05:21:50 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- removed special characters used by 'show create', they conflict with shell
special quotes (reported by Rafael J. Risco)
Revisi
User: bogdan_iancu
Date: 2006/06/26 01:48:56 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- fix issue with primary key in usr_preferences (AVP) table.
Credits go to Mike Williams <[EMAIL PROTECTED]> and
G.Jacobs
User: bogdan_iancu
Date: 2006/05/19 08:39:34 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh sc sc.dbtext
sc.postgres sc_unixsock
Commit Log:
- applied patch : added ability to specify MD5 from a configuration
User: bogdan_iancu
Date: 2006/05/19 05:00:27 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- last_modified column does not reflect DB timestamps anymore, but is used
by usrloc module for storing the date+time of the l
User: bogdan_iancu
Date: 2006/04/10 01:57:20 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- removed duplicates from usage text.
Pointed out by Juha Heinanen <[EMAIL PROTECTED]>
Revision ChangesPath
1.28
User: bogdan_iancu
Date: 2006/04/07 07:03:55 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- reinstall functonality fixed (only for mysql)
- serweb tables moved away from the openser tables
- replaced gen_ha1 with md5
User: miconda
Date: 2006/04/07 02:43:30 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Added files:
modules/siptrace Makefile README siptrace.c
modules/siptrace/doc siptrace.sgml siptrace_devel.sgml
User: juhe
Date: 2006/03/19 16:32:58 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
* Added tag field to trusted table.
Revision ChangesPath
1.24 +3 -2 sip-server/scripts/mysqldb.sh
[
http://c
User: bogdan_iancu
Date: 2006/02/08 05:00:44 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- changes in usr_preferences keys/indexes:
1) primary keys extended to
(uuid,username,domain,attribute,type,value)
User: bogdan_iancu
Date: 2005/12/01 07:03:08 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
-included file path fixed (reported by Norman Brandinger) - closes 1370925
Revision ChangesPath
1.16 +3 -3 s
User: klaus_darilion
Date: 2005/11/30 13:44:10 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- increased user_agent to varchar(255), 50 is to small
Revision ChangesPath
1.15 +3 -3 sip-server/scripts/
User: klaus_darilion
Date: 2005/11/30 13:43:25 PST
OpenSER CVS - Commit Details
Modified files:(Branch: rel_1_0_0)
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- increased user_agent to varchar(255), 50 is to small
Revision ChangesPath
1.9.2.3 +3
User: klaus_darilion
Date: 2005/11/28 07:43:07 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- renamed src, dst to src_leg, dst_leg in missed_calls table (closes
1368287), thanks to Norman
Revision ChangesPath
User: klaus_darilion
Date: 2005/11/28 07:45:44 PST
OpenSER CVS - Commit Details
Modified files:(Branch: rel_1_0_0)
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- renamed src, dst to src_leg, dst_leg in missed_calls table (closes
1368287), thanks to Norman
User: klaus_darilion
Date: 2005/11/28 03:10:14 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- changed acc columns src and dst to src_leg and dst_leg (fixes #1367858),
credits go to Norman
Revision ChangesPath
User: klaus_darilion
Date: 2005/11/28 03:06:44 PST
OpenSER CVS - Commit Details
Modified files:(Branch: rel_1_0_0)
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- changed acc columns src and dst to src_leg and dst_leg (fixes #1367858),
credits go to Norman
User: bogdan_iancu
Date: 2005/11/23 08:12:31 PST
OpenSER CVS - Commit Details
Modified files:
scripts postgresqldb.sh mysqldb.sh
modules/lcr README lcr_mod.c
modules/lcr/doc lcr_user.sgml
Commit Log:
LCR Strip Option patch submitted - provided by
User: bogdan_iancu
Date: 2005/11/22 13:52:47 PST
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
-re_grp table (regular expression group table) added
Revision ChangesPath
1.10 +14 -2 sip-server/scripts/mysq
User: bogdan_iancu
Date: 2005/10/27 13:03:34 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
-bogus columns removde from subscriber table
Revision ChangesPath
1.9 +2 -3 sip-server/scripts/mysqldb.sh
User: klaus_darilion
Date: 2005/09/05 02:41:21 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
- updated tables definition along with ser (to work with serweb)
Revision ChangesPath
1.7 +29 -7 sip-serve
User: juhe
Date: 2005/08/20 09:35:45 PDT
OpenSER CVS - Commit Details
Modified files:
scripts mysqldb.sh postgresqldb.sh
Commit Log:
* Added gs, lcr, and gw_gpr tables to mysqldb.sh.
* Added prefix field to gw table in postgresqldb.sh.
Revision ChangesPat
44 matches
Mail list logo
