Hello Dave. I was almost sure that the tables for LCR were defined there!, my mystake. But, i have the table definitions (i can't rememeber where i found it). You can check with Juha if there is a mistake in the tables.
# # Table structure for table 'gw' #
CREATE TABLE gw ( gw_name VARCHAR(128) NOT NULL, ip_addr INT UNSIGNED NOT NULL, port SMALLINT UNSIGNED, grp_id INT UNSIGNED NOT NULL, PRIMARY KEY (gw_name), KEY (grp_id) );
# # 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 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) );
Regards Ricardo.-
-----Mensaje original----- De: Dave [mailto:ddx66@yahoo.com] Enviado el: Viernes, 29 de Julio de 2005 11:30 Para: Ricardo Martinez; serusers@lists.iptel.org Asunto: RE: [Serusers] LCR on onsip.org - No DB tables created?
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
-
Ricardo Martinez