8 Jun
2007
8 Jun
'07
3:42 p.m.
Thank you everyone who responded to my lcr question. Really appreciate your help.
I was wondering if someone could comment on the second part of my email relating to DB schema changes.
Another thing that i noticed is that subscriber table gets the additional (missing compared to v1.1) fields when I install serweb tables. In v1.1 these fields were present without installing serweb tables.
--
Zahid
On Jun 6, 2007, at 4:40 PM, zm23 wrote:
> Hello All,
>
> I'm having trouble getting lcr to work properly. I am not sure
> what to use for wild card matching.
>
> In 1.1 i was using PREFIX 4____ ( 4 followed by 4 underscores) and
> "from_uri" with value %.
>
> Now, in 1.2 I changed the from_uri to be empty (by updating
> from_uri="") but lcr is not able to match on 5 digit numbers
> starting with 4. It works if i actually put a 5 digit extension.
> LCR module documentation mentions regex use for "from_uri" but says
> nothing about the prefix field
>
>
> Another problem for me is the change in db tables usr_preferences
> and subscriber. All tables are created using openser_mysql reinit
> command
>
>
> usr_preferences has "modified" field changed to "last_modified".
>
>
>
> Subscirber table in 1.2 (no serweb or additional tables;
>
> '
> +------------------+------------------+------+-----
> +---------------------+----------------+
> | Field | Type | Null | Key |
> Default | Extra |
> +------------------+------------------+------+-----
> +---------------------+----------------+
> | id | int(10) unsigned | | PRI |
> NULL | auto_increment |
> | username | varchar(64) | | MUL
> | | |
> | domain | varchar(128) | |
> | | |
> | password | varchar(25) | |
> | | |
> | first_name | varchar(25) | |
> | | |
> | last_name | varchar(45) | |
> | | |
> | email_address | varchar(50) | |
> | | |
> | datetime_created | datetime | | | 0000-00-00
> 00:00:00 | |
> | ha1 | varchar(128) | |
> | | |
> | ha1b | varchar(128) | |
> | | |
> | timezone | varchar(128) | YES | |
> NULL | |
> | rpid | varchar(128) | YES | |
> NULL | |
> | phone | varchar(15) | YES | |
> NULL | |
> +------------------+------------------+------+-----
> +---------------------+----------------+
>
>
> subscriber in 1.1
>
> +-------------------+--------------+------+-----
> +---------------------+-------+
> | Field | Type | Null | Key |
> Default | Extra |
> +-------------------+--------------+------+-----
> +---------------------+-------+
> | phplib_id | varchar(32) | | UNI
> | | |
> | username | varchar(64) | | PRI
> | | |
> | domain | varchar(128) | | PRI
> | | |
> | password | varchar(25) | |
> | | |
> | first_name | varchar(25) | |
> | | |
> | last_name | varchar(45) | |
> | | |
> | phone | varchar(15) | |
> | | |
> | email_address | varchar(50) | |
> | | |
> | datetime_created | datetime | | | 0000-00-00
> 00:00:00 | |
> | datetime_modified | datetime | | | 0000-00-00
> 00:00:00 | |
> | confirmation | varchar(64) | |
> | | |
> | flag | char(1) | | |
> o | |
> | sendnotification | varchar(50) | |
> | | |
> | greeting | varchar(50) | |
> | | |
> | ha1 | varchar(128) | |
> | | |
> | ha1b | varchar(128) | |
> | | |
> | allow_find | char(1) | | |
> 0 | |
> | timezone | varchar(128) | YES | |
> NULL | |
> | rpid | varchar(128) | YES | |
> NULL | |
> | domn | int(10) | YES | |
> NULL | |
> | uuid | varchar(64) | YES | |
> NULL | |
> +-------------------+--------------+------+-----
> +---------------------+-------+
>
>
> Installing serweb tables seems to add the missing fields in
> subscriber.
>
>
> I dont know if this is desired behavior or not. In any case I
> think this should be mentioned on the openser 1.1.x to v1.2.x
> migration doc.
>
>
> Thanks.
>
> --
> Zahid
>
>
> _______________________________________________
> Users mailing list
> Users@openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users