29 Jul
2005
29 Jul
'05
6:30 p.m.
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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-----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
30 Jul
30 Jul
1:54 p.m.
New subject: [Serusers] LCR on onsip.org - No DB tables created?
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
9:19 p.m.
New subject: [Serusers] LCR on onsip.org - No DB tables created?
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(a)tutpro.com> wrote:
Dave writes:
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
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
10:06 p.m.
New subject: [Serusers] LCR on onsip.org - No DB tables created?
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
7055
days inactive
7056
days old
3 comments
3 participants
participants (3)
-
Dave -
Greger V. Teigre -
Juha Heinanen