[Devel] [ openser-Bugs-1462013 ] openser_mysql.sh reinstall fails

[SourceForge.net]

Bugs item #1462013, was opened at 2006-03-31 13:20
Message generated for change (Comment added) made by klaus_darilion
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1462013&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: tools
Group: None
Status: Open
Resolution: None
Priority: 7
Submitted By: Klaus Darilion (klaus_darilion)
Assigned to: Nobody/Anonymous (nobody)
Summary: openser_mysql.sh reinstall fails

Initial Comment:
Hi!

i tried to update today from 1.0 to cvs and it failed:

server1:~# openser_mysql.sh reinstall
MySql password for root:
creating backup database
dumping table content (openser)
dropping table (openser)
creating new structures
creating database openser ...
restoring table content
ERROR 1062 (23000) at line 216: Duplicate entry '' for
key 2
reinstall: restoring table failed

The strange thing is, that it copied one subscriber
from the backup subscriber table to the new subscriber
table, but:
1. when copying the second subscriber it failed
2. The username of the subscribers (which was copied)
was changed (from user101 to username101). Very strange.

I have no time to debug it now, but I thougt it would
be good to leave a note on the bugtracker.


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

>Comment By: Klaus Darilion (klaus_darilion)
Date: 2006-04-03 13:42

Message:
Logged In: YES 
user_id=1318360

I think I found the problem: During reinstall, the database
will be dumped and rewritten. The first sed expression maps
user_id to user. The last one maps realm to domain. This was
need somehwere in ser 0.8 releases. Thus this can be removed.

The expression in the middle is a little bit strange. I do
not know what it really does, maybe some mapping if $USERCOL
is changed during reinstall. IMO this sed expression should
also be removed, because such DB modifications (changing
columns name) should be done manually.

Thus, I think it is fine to remove this sed expressions.

regards
klaus


sed "s/[uU][sS][eE][rR]_[iI][dD]/user/g" $tmp_file |
  sed "s/[uU][sS][eE][rR]\($\|[^a-zA-Z]\)/$USERCOL\1/g" |
  sed "s/[rR][eE][aA][lL][mM]/domain/g"> ${tmp_file}.2

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

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