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

[Jan Janak]

Thanks for the report, we will fix it.

  Jan.

On 20-04 19:51, Bernie Hoeneisen wrote:
> 
> 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 at 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 at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers