[Users] openser 1.2 migration questions

[zm23]

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 at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users