[OpenSER-Devel] [ openser-Bugs-1886421 ] CPL module should suggest "openserdbctl"

[SourceForge.net]

Bugs item #1886421, was opened at 2008-02-04 16:12
Message generated for change (Comment added) made by henningw
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1886421&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Iñaki Baz (ibc_sf)
Assigned to: Nobody/Anonymous (nobody)
Summary: CPL module should suggest "openserdbctl"

Initial Comment:
SVN revision 3622. I compile and restart but I get this error:

---
ERROR:cpl-c:cpl_db_bind: Invalid table version (0, required 1)(use openser_mysql.sh reinstall)
---

AFAIK it should do mention to "openserdbctl reinit".

----------------------------------------------------------------------

>Comment By: Henning Westerholt (henningw)
Date: 2008-02-05 09:49

Message:
Logged In: YES 
user_id=337916
Originator: NO

Hi,

there were recent changes in the trunk that includes the db_table
variables and the function that evaluates them. 
I've seen this errors in the past during a mismatch of the module library
vs. the core binary, e.g. the module assumes
still the old interface but the core has changed. I've did also a quick
review of the code in question, but i found
nothing obvious wrong there.

Could you recompile the cpl-c module and try again? You could also try to
change the db_table variable in the config
and looks whats happen, perhaps this give more hints about the problem.

Cheers,

Henning

----------------------------------------------------------------------

Comment By: Iñaki Baz (ibc_sf)
Date: 2008-02-04 16:27

Message:
Logged In: YES 
user_id=1844020
Originator: YES

Anyway I see there is a bug here since it gives that error:
  ERROR:cpl-c:cpl_db_bind: Invalid table version (0, required 1)
even if I have "1" as CPL table version.

In fact, I see something very strange in the MySQL query when starting
OpenSer:

7774 Query       select table_version from version where
table_name='subscriber'
                   7775 Query       select table_version from version
where table_name='trusted'
                   7776 Query       select table_version from version
where table_name='address'
                   7777 Query       select table_version from version
where table_name='grp'
                   7778 Query       select table_version from version
where table_name='presentity'
                   7778 Query       select table_version from version
where table_name='active_watchers'
                   7778 Query       select table_version from version
where table_name='watchers'
                   7778 Query       select
presentity_uri,expires,event,event_id,to_user,to_domain,watcher_username,watcher_domain,callid,to_tag,from_tag,local_cseq,remote_cseq,record_route,socket_info,contact,local_contact,version,status,reason
from active_watchers
                   7779 Query       select table_version from version
where table_name='xcap'
                   7780 Query       select table_version from version
where table_name='pua'
                   7781 Query       select table_version from version
where table_name='P�'

Note the final query: the 'P�' is obviously a wrong character. I assume
that there should appear "cpl" instead and that is the reason CPl module
doesn't find the correct version.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1886421&group_id=139143