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(a)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(a)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(a)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
http://mail.yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)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