Bugs item #1462013, was opened at 2006-03-31 14:20
Message generated for change (Settings changed) made by bogdan_iancu
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: Closed
>Resolution: Fixed
Priority: 7
Submitted By: Klaus Darilion (klaus_darilion)
>Assigned to: Bogdan (bogdan_iancu)
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 14: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
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
