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

Bernie Hoeneisen bhoeneis at switch.ch
Tue Apr 20 19:51:56 CEST 2004


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)"




More information about the sr-users mailing list