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