[OpenSER-Users] auth_db module - get_ha1(): Error while querying database
Mihail Gluhowchenko
kukumander at gmail.com
Tue Dec 11 05:05:50 CET 2007
I don`t know but if use sc.dbtext out of tarball(openser-1.2.2), then i saw
'auth_db module - get_ha1(): Error while querying database'
After my modifications all works.
Where is the new database schema?
2007/12/10, Daniel-Constantin Mierla <daniel at voice-system.ro>:
>
> Hello,
>
> seems that you haven't updated the database structure. In 1.2, there was
> a refurbishment that included primary keys, a.s.o. As I could guess from
> patch, you still use the old database schema.
>
> Cheers,
> Daniel
>
> PS. Please CC to mailing list, the answer can come much faster, with
> more competence from people experiencing same issues, and will help new
> comers with same case.
>
>
> On 12/10/07 15:07, Mihail Gluhowchenko wrote:
> > Hello;
> > Sorry %)
> > --
> > Regards,
> > Mihail Gluhowchenko.
> > Enterprise ELTEX
> > 2007/12/10, Daniel-Constantin Mierla <daniel at voice-system.ro
> > <mailto:daniel at voice-system.ro>>:
> >
> > Hello,
> >
> > can you please send unified format for the patch?
> >
> > diff -u oldfile newfile
> >
> > Thanks,
> > Daniel
> >
> >
> > On 12/10/07 14:29, Mihail Gluhowchenko wrote:
> > > Hello;
> > > Here it is sc.patch;
> > > my version is 'openser-1.2.2-notls'
> > > --
> > > Regards,
> > > Mihail Gluhowchenko.
> > > Enterprise ELTEX.
> > >
> > > 2007/12/10, Daniel-Constantin Mierla < daniel at voice-system.ro
> > <mailto:daniel at voice-system.ro>
> > > <mailto:daniel at voice-system.ro <mailto:daniel at voice-system.ro>>>:
> > >
> > >
> > >
> > > 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.
> > > >
> > >
> > >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20071211/1af2fb51/attachment.htm
More information about the Users
mailing list