Can anyone point me to the db schema for the new pipelimit module?
Thanks, Ryan
Hello,
On 2/23/11 12:30 AM, thrillerbee wrote:
Can anyone point me to the db schema for the new pipelimit module?
seems I forgot to add it to db creation script. I will fix that in the next days. Meanwhile you can use:
INSERT INTO version (table_name, table_version) values ('pl_pipes','1'); CREATE TABLE pl_pipes ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, pipeid VARCHAR(64) DEFAULT '' NOT NULL, algorithm VARCHAR(32) DEFAULT '' NOT NULL, plimit INT DEFAULT 0 NOT NULL, CONSTRAINT pipeid_idx UNIQUE (pipeid) ) ENGINE=MyISAM;
This is inside sources, modules/pipelimit/pl_db.c
Thanks, Daniel
Cool, thanks.
On Wed, Feb 23, 2011 at 12:36 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
Hello,
On 2/23/11 12:30 AM, thrillerbee wrote:
Can anyone point me to the db schema for the new pipelimit module?
seems I forgot to add it to db creation script. I will fix that in the next days. Meanwhile you can use:
INSERT INTO version (table_name, table_version) values ('pl_pipes','1'); CREATE TABLE pl_pipes ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, pipeid VARCHAR(64) DEFAULT '' NOT NULL, algorithm VARCHAR(32) DEFAULT '' NOT NULL, plimit INT DEFAULT 0 NOT NULL, CONSTRAINT pipeid_idx UNIQUE (pipeid) ) ENGINE=MyISAM;
This is inside sources, modules/pipelimit/pl_db.c
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com
Is there a fifo command available to reload pipelimit config from db? something like 'kamctl fifo pl_reload'?
On Wed, Feb 23, 2011 at 9:02 AM, thrillerbee thrillerbee@gmail.com wrote:
Cool, thanks.
On Wed, Feb 23, 2011 at 12:36 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
Hello,
On 2/23/11 12:30 AM, thrillerbee wrote:
Can anyone point me to the db schema for the new pipelimit module?
seems I forgot to add it to db creation script. I will fix that in the next days. Meanwhile you can use:
INSERT INTO version (table_name, table_version) values ('pl_pipes','1'); CREATE TABLE pl_pipes ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, pipeid VARCHAR(64) DEFAULT '' NOT NULL, algorithm VARCHAR(32) DEFAULT '' NOT NULL, plimit INT DEFAULT 0 NOT NULL, CONSTRAINT pipeid_idx UNIQUE (pipeid) ) ENGINE=MyISAM;
This is inside sources, modules/pipelimit/pl_db.c
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com
...and while I'm asking questions, how should the algorithm be specified in the db column? Could someone provide some examples? I'm catching the CPS, but nothing is actually being dropped:
#kamctl fifo pl_get_pipes PIPE:: id=30236 algorithm=TAILDROP limit=15 counter=82
Thanks.
On Wed, Feb 23, 2011 at 1:32 PM, thrillerbee thrillerbee@gmail.com wrote:
Is there a fifo command available to reload pipelimit config from db? something like 'kamctl fifo pl_reload'?
On Wed, Feb 23, 2011 at 9:02 AM, thrillerbee thrillerbee@gmail.comwrote:
Cool, thanks.
On Wed, Feb 23, 2011 at 12:36 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
Hello,
On 2/23/11 12:30 AM, thrillerbee wrote:
Can anyone point me to the db schema for the new pipelimit module?
seems I forgot to add it to db creation script. I will fix that in the next days. Meanwhile you can use:
INSERT INTO version (table_name, table_version) values ('pl_pipes','1'); CREATE TABLE pl_pipes ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, pipeid VARCHAR(64) DEFAULT '' NOT NULL, algorithm VARCHAR(32) DEFAULT '' NOT NULL, plimit INT DEFAULT 0 NOT NULL, CONSTRAINT pipeid_idx UNIQUE (pipeid) ) ENGINE=MyISAM;
This is inside sources, modules/pipelimit/pl_db.c
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com
I found the answer to my most recent question (my timer interval was set too long). Can someone answer this one?
Is there a fifo command available to reload pipelimit config from db? something like 'kamctl fifo pl_reload'?
On Wed, Feb 23, 2011 at 2:00 PM, thrillerbee thrillerbee@gmail.com wrote:
...and while I'm asking questions, how should the algorithm be specified in the db column? Could someone provide some examples? I'm catching the CPS, but nothing is actually being dropped:
#kamctl fifo pl_get_pipes PIPE:: id=30236 algorithm=TAILDROP limit=15 counter=82
Thanks.
On Wed, Feb 23, 2011 at 1:32 PM, thrillerbee thrillerbee@gmail.comwrote:
Is there a fifo command available to reload pipelimit config from db? something like 'kamctl fifo pl_reload'?
On Wed, Feb 23, 2011 at 9:02 AM, thrillerbee thrillerbee@gmail.comwrote:
Cool, thanks.
On Wed, Feb 23, 2011 at 12:36 AM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
Hello,
On 2/23/11 12:30 AM, thrillerbee wrote:
Can anyone point me to the db schema for the new pipelimit module?
seems I forgot to add it to db creation script. I will fix that in the next days. Meanwhile you can use:
INSERT INTO version (table_name, table_version) values ('pl_pipes','1'); CREATE TABLE pl_pipes ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, pipeid VARCHAR(64) DEFAULT '' NOT NULL, algorithm VARCHAR(32) DEFAULT '' NOT NULL, plimit INT DEFAULT 0 NOT NULL, CONSTRAINT pipeid_idx UNIQUE (pipeid) ) ENGINE=MyISAM;
This is inside sources, modules/pipelimit/pl_db.c
Thanks, Daniel
-- Daniel-Constantin Mierla http://www.asipto.com
On Wednesday 23 February 2011, thrillerbee wrote:
I found the answer to my most recent question (my timer interval was set too long). Can someone answer this one?
Is there a fifo command available to reload pipelimit config from db? something like 'kamctl fifo pl_reload'?
Hi thrillerbee,
if its not in the documentation, then probably not. You can get all available commands at runtime by executing
kamctl fifo which
on the server.
Cheers,
Henning