Re: [OpenSER-Users] auth_db module - get_ha1(): Error while querying database - sr-users

10 Dec 2007

On 12/10/07 07:04, Mihail Gluhowchenko wrote:
...
  Hello all work; :) was your version old or there
is a bug in sc.dbtext? Can you post the 
patch of changes?

Best regards,
Daniel

...
  in script sc.dbtext use old format subscriber.
 Little changes and all work

 date_now=$(date +"%s")
 GLOB_ID=$(od -N4 -d /dev/random | head -n1 | cut -d' ' -f2,3 | sed -e 
 's/ //')

  add)
                 if [ $# -ne 4 ] ; then
                         usage
                         exit 1
                 fi
                 shift
                 credentials $1 $2
                 is_user $1
                 if [ $? -eq 0 ] ; then
                         echo -e "\nuser already exists\n"
                         exit 1
                 fi
                 #Add to SUBSCRIBER file
                 #id(int,auto) username(str) domain(str) password(str) 
 first_name(str,null) last_name(str,null) email_address(str) 
 datetime_created(int) last_modified(int)  ha1(str) ha1b(str) 
 rpid(str,null)

 line="$GLOB_ID:$SERUSER:$SERDOMAIN:$2:::$3:$date_now:$date_now:$HA1:$HA1B:"
                 echo $line >> $SUB_FILE
                 #Add to URI file
                 #id(int,auto) domain(str) uri_user(str) 
 last_modified(int)
                 line="$GLOB_ID:$SERDOMAIN:$SERUSER:$date_now"
                 echo $line >> $URI_FILE
                 echo -e "\nNew user ($SERUSER@$SERDOMAIN) added to 
 DBTEXT files\n"
                 ;;
 -- 
 Regards,
 Mihail Gluhowchenko.
 Enterprise ELTEX.