Re: [Serusers] Bug-report: ser_mysql.sh, Error 1054

In the current CVS unstable version there seams to be a bug in the ser_mysql.sh: I have tried to upgrade from my stable 0.8.12 to the CVS unstable and found the following issues: bhoeneis@wil:~/ser/sip_router$ scripts/ser_mysql.sh reinstall MySql password for root: creating backup database dumping table content (ser) dropping table (ser) creating new structures creating database ser ... restoring table content ERROR 1054 at line 42: Unknown column 'usernamename' in 'field list' reinstall: restoring table failed I solved this by commenting out the following line in ser_mysql.sh # sed "s/[uU][sS][eE][rR]/$USERCOL/g" | But then thow following error came as next after running the "fixed" ser_mysql.sh: ERROR 1054 at line 108: Unknown column 'perms' in 'field list' This one I circumvented by inserting a line, which does replace all the strings perms by rpid as follows: sed "s/[uU][sS][eE][rR]_[iI][dD]/user/g" $tmp_file | # sed "s/[uU][sS][eE][rR]/$USERCOL/g" | sed "s/[pP][eE][rR][mM][sS]/rpid/g" | sed "s/[rR][eE][aA][lL][mM]/domain/g"> ${tmp_file}.2 After running it again I executed the following in the mysql client: update subscriber set rpid="NULL" where rpid !="NULL" I hope someone can fix this once... and that my fix really helps...;-) cheers, Bernie PS: Here the diff for a quick and dirty fix: bhoeneis@wil:~/ser/sip_router$ cvs diff -u scripts/ser_mysql.sh Index: scripts/ser_mysql.sh =================================================================== RCS file: /cvsroot/ser/sip_router/scripts/ser_mysql.sh,v retrieving revision 1.52 diff -u -r1.52 ser_mysql.sh --- scripts/ser_mysql.sh 13 Apr 2004 19:14:32 -0000 1.52 +++ scripts/ser_mysql.sh 20 Apr 2004 17:39:49 -0000 @@ -697,7 +697,8 @@ exit 1 fi sed "s/[uU][sS][eE][rR]_[iI][dD]/user/g" $tmp_file | - sed "s/[uU][sS][eE][rR]/$USERCOL/g" | + # sed "s/[uU][sS][eE][rR]/$USERCOL/g" | + sed "s/[pP][eE][rR][mM][sS]/rpid/g" | sed "s/[rR][eE][aA][lL][mM]/domain/g"> ${tmp_file}.2 #3 drop original database echo "dropping table ($DBNAME)" _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers