I used exactly that script. But It did not create any LCR related tables.!!!
--- Ricardo Martinez rmartinez@redvoiss.net wrote:
Hello Dave. If i'm not wrong, there is a shell script included in the last SER version to create all the DB tables related to SER. I think there is in : /sip_router/scripts/ and is called "ser_mysql.sh" You can try that!.
Regards, Ricardo Martinez
-----Mensaje original----- De: Dave [mailto:ddx66@yahoo.com] Enviado el: Viernes, 29 de Julio de 2005 11:16 Para: serusers@lists.iptel.org Asunto: [Serusers] LCR on onsip.org - No DB tables
created?
Hi, I downloaded and installed the ser-0.9.3 from onsip.org with the intention of using LCR.
Although,
the LCR module was complied, I do not see the
tables
lcr, gw in the DB? How do I create them? Thanks
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam
protection around
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Dave writes:
I used exactly that script. But It did not create any LCR related tables.!!!
ser cvs HEAD has in scripts/ser_mysql.sh:
# # Table structure for table 'gw' #
CREATE TABLE gw ( gw_name VARCHAR(128) NOT NULL, ip_addr INT UNSIGNED NOT NULL, port SMALLINT UNSIGNED, uri_scheme TINYINT UNSIGNED, transport TINYINT UNSIGNED, grp_id INT UNSIGNED NOT NULL, PRIMARY KEY (gw_name), KEY (grp_id) ) $TABLE_TYPE;
# # Table structure for table 'gw_grp' #
CREATE TABLE gw_grp ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, grp_name VARCHAR(64) NOT NULL ) $TABLE_TYPE;
# # Table structure for table 'lcr' #
CREATE TABLE lcr ( prefix varchar(16) NOT NULL, from_uri varchar(128) NOT NULL DEFAULT '%', grp_id INT UNSIGNED NOT NULL, priority TINYINT UNSIGNED NOT NULL, KEY (prefix), KEY (from_uri), KEY (grp_id) ) $TABLE_TYPE;
if the tables were not created, what error message you got?
-- juha
if the tables were not created, what error message you got?
None because I checked the database for creation of these tables before using LCR module. And since no tables were created I did not use LCR.
Could you please update the ser_mysql.sh on onsip.org in the ser-0.9.3-gettingstarted for everyones benefit? Thanks,
Dave
--- Juha Heinanen jh@tutpro.com wrote:
Dave writes:
I used exactly that script. But It did not create
any
LCR related tables.!!!
ser cvs HEAD has in scripts/ser_mysql.sh:
# # Table structure for table 'gw' #
CREATE TABLE gw ( gw_name VARCHAR(128) NOT NULL, ip_addr INT UNSIGNED NOT NULL, port SMALLINT UNSIGNED, uri_scheme TINYINT UNSIGNED, transport TINYINT UNSIGNED, grp_id INT UNSIGNED NOT NULL, PRIMARY KEY (gw_name), KEY (grp_id) ) $TABLE_TYPE;
# # Table structure for table 'gw_grp' #
CREATE TABLE gw_grp ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, grp_name VARCHAR(64) NOT NULL ) $TABLE_TYPE;
# # Table structure for table 'lcr' #
CREATE TABLE lcr ( prefix varchar(16) NOT NULL, from_uri varchar(128) NOT NULL DEFAULT '%', grp_id INT UNSIGNED NOT NULL, priority TINYINT UNSIGNED NOT NULL, KEY (prefix), KEY (from_uri), KEY (grp_id) ) $TABLE_TYPE;
if the tables were not created, what error message you got?
-- juha
____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
Dave, The backport of LCR to 0.9.x has been included in the ONsip.org package as a help as many people want to use the LCR module. However, the package is a true 0.9.3 package and no files have been changed. ser_mysql.h will thus not be changed to include LCR. Most people up to now have known about this and more info hasn't seemed necessary, but I will make sure this will be emphasized in future README files.
BTW, Juha is not involved in ONsip.org, but he is the developer of the LCR module. g-)
Dave wrote:
if the tables were not created, what error message you got?
None because I checked the database for creation of these tables before using LCR module. And since no tables were created I did not use LCR.
Could you please update the ser_mysql.sh on onsip.org in the ser-0.9.3-gettingstarted for everyones benefit? Thanks,
Dave
--- Juha Heinanen jh@tutpro.com wrote:
Dave writes:
I used exactly that script. But It did not create
any
LCR related tables.!!!
ser cvs HEAD has in scripts/ser_mysql.sh:
# # Table structure for table 'gw' #
CREATE TABLE gw ( gw_name VARCHAR(128) NOT NULL, ip_addr INT UNSIGNED NOT NULL, port SMALLINT UNSIGNED, uri_scheme TINYINT UNSIGNED, transport TINYINT UNSIGNED, grp_id INT UNSIGNED NOT NULL, PRIMARY KEY (gw_name), KEY (grp_id) ) $TABLE_TYPE;
# # Table structure for table 'gw_grp' #
CREATE TABLE gw_grp ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, grp_name VARCHAR(64) NOT NULL ) $TABLE_TYPE;
# # Table structure for table 'lcr' #
CREATE TABLE lcr ( prefix varchar(16) NOT NULL, from_uri varchar(128) NOT NULL DEFAULT '%', grp_id INT UNSIGNED NOT NULL, priority TINYINT UNSIGNED NOT NULL, KEY (prefix), KEY (from_uri), KEY (grp_id) ) $TABLE_TYPE;
if the tables were not created, what error message you got?
-- juha
Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Dave -
Greger V. Teigre -
Juha Heinanen