[Users] OpenSER administrator issue
Bogdan-Andrei Iancu
bogdan at voice-system.ro
Tue Feb 27 17:02:27 CET 2007
Hi Norman,
just for completion sake, this was take care of in 1.2.
regards,
bogdan
Norman Brandinger wrote:
> I believe that phplib_id is only used by serweb. There are a few
> columns that fall into the category of being used only by serweb.
> Recently the database creation scripts were updated to allow for
> serweb tables to be created (or not created) based on user input,
> however, there is no ability to specifically include or not include
> serweb specific columns.
> Perhaps, the roadmap can include a task to include serweb columns only
> if serweb tables are being created.
>
> So, Mike, my suggestion would be to keep the id column as a unique
> value and only include phplib_id if you are going to support serweb
> (or want to retain compatibility with the existing database
> creation/openserctl scripts).
>
> Any other comments, suggestions or opinions are welcome.
>
> Regards,
> Norm
>
>
> Mike Williams wrote:
>> That is definitely the issue, it's a known bug on sourceforge. I'm
>> trying to think of a good fix.
>>
>> Here's what I sent to another user with the same reported issue:
>>
>> <<<
>>
>> As for openserctl failling, that is definitely something that I
>> broke. In the database_tables.sql file, some modifications are made
>> to OpenSER's tables, and dropping the column phplib_id is one of
>> them. I replaced it with just 'id' because it was easier to work with
>> in Ruby on Rails, makes more sense because it is not linked to any
>> particular programming language, and because having an integer that
>> can be autoincremented makes it much easier to manually work with in
>> MySQL and to generate id's with no code, especially since the the
>> former column was generated by PHP specific code.
>>
>> I'm not sure of the best way to fix the problem, as I'm not sure
>> whether re-adding phplib_id would cause more problems or not. For one
>> thing, there would need to be additional code in the interface,
>> although this looks like it would be the only solution that would
>> break nothing.
>>
>>
>> What does the OpenSER team (and everyone else) think about the
>> phplib_id problem?
>>
>> Mike
>>
>>
>> On Friday 11 August 2006 10:25, Pat wang wrote:
>>
>>> Hi,
>>>
>>> Just managed to install the new openser administrator and everything
>>> just
>>> works. Thanks to Mike for this nice application. However I can't add
>>> user
>>> with openserctl anymore. The following error appears:
>>> ERROR 1054 (42S22) at line 1: Unknown column 'phplib_id' in 'field
>>> list'
>>> ERROR: introducing the new user '5702' to the database failed
>>>
>>> On the other hand, adding new users from administrator GUI does not
>>> have
>>> this problem. This happened right after installation of aministrator
>>> so I
>>> think it is related to the administrator mysql table changes.
>>>
>>> Any suggestions please? Thanks,
>>>
>>> Patrick
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at openser.org
>>> http://openser.org/cgi-bin/mailman/listinfo/users
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
More information about the sr-users
mailing list