[Serusers] register_udomain(): Invalid table version (use ser_mysql.sh reinstall)
Greg Fausak
lgfausak at gmail.com
Fri Sep 15 15:48:03 CEST 2006
Howdy N.,
I've seen your email on this list often.
Would you mind answering a question?
You have ported from openser to ser. Why?
I've been thinking about it, I just wonder what
you experience was? Does it work about the same?
Is anything missing? Are there features in ser that made
it the one to use?
OK, six questions... :-)
---greg
On Sep 15, 2006, at 6:21 AM, sip wrote:
> What's amusing is WHY this comes up. I'm not entirely sure the
> table check
> code is right (or it may be correct, but it's not exactly rational).
>
> For instance, the a month or two ago, we were switching from using
> lookup("aliases") to alias_db_lookup("dbaliases") as our alias
> check (porting
> the code from openser to ser).
>
> There was a spot in the config where we'd forgotten to change the
> command from
> lookup to alias_db_lookup, but had changed the table name from
> aliases to
> dbaliases.
>
> What happens? Out pops the 'register_udomain() Invalid table
> version' error.
>
> Now, I'm not sure what it's checking for in that case, but I can
> tell you that
> THAT error message (and the advice it gives to use the reinstall
> option of the
> mysql script) is entirely NOT helpful. :)
>
> To play around, I added a version entry for dbaliases and matched
> its version
> to the aliases table just to see if indeed that was the result of a
> version
> check. No dice. What it apparently was doing was checking the
> format of the
> dbaliases table against its expected format (aliases is VERY
> different in
> format) and spitting out an error that the table version was
> incorrect. Um...
> no... the table STRUCTURE was incorrect, but that really has
> nothing at all to
> do with the version per se.
>
> I'm thinking that perhaps the version table with its version
> numbers to denote
> some sort of extra check on the tables is, perhaps, not the best
> way to do
> things. At the very least, there ought to be more applicable error
> messages
> when a structure check fails. Something like "aliases table not proper
> structure for lookup() command" would have been the most ideal
> error message
> of course. I'd have known in a heartbeat where the problem was.
>
> Someone who DIDN'T know what he was doing might have spent all day
> trying to
> install/reinstall the DB as per instructions in the error message
> (which don't
> work), and would still have gotten nowhere.
>
>
> N.
>
>
> On Fri, 15 Sep 2006 10:48:08 +0100, bails wrote
>> its come up before so i have to ask
>>
>> I have read the list archives and googled.
>>
>> 1. there is no reinstall option
>> 2. there is nothing in tools/
>>
>> If this is in CVS why hasnt it been fixed?
>>
>> Bails
>> _______________________________________________
>> Serusers mailing list
>> Serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list