8 Jun
2007
8 Jun
'07
6: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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users