<br>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'<br>After my modifications all works.<br>Where is the new database schema?<br>
<br><div><span class="gmail_quote">2007/12/10, Daniel-Constantin Mierla <<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br><br>seems that you haven't updated the database structure. In 1.2, there was<br>a refurbishment that included primary keys, a.s.o. As I could guess from<br>patch, you still use the old database schema.<br><br>
Cheers,<br>Daniel<br><br>PS. Please CC to mailing list, the answer can come much faster, with<br>more competence from people experiencing same issues, and will help new<br>comers with same case.<br><br><br>On 12/10/07 15:07, Mihail Gluhowchenko wrote:
<br>> Hello;<br>> Sorry %)<br>> --<br>> Regards,<br>> Mihail Gluhowchenko.<br>> Enterprise ELTEX<br>> 2007/12/10, Daniel-Constantin Mierla <<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro
</a><br>> <mailto:<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro</a>>>:<br>><br>> Hello,<br>><br>> can you please send unified format for the patch?<br>><br>> diff -u oldfile newfile
<br>><br>> Thanks,<br>> Daniel<br>><br>><br>> On 12/10/07 14:29, Mihail Gluhowchenko wrote:<br>> > Hello;<br>> > Here it is sc.patch;<br>> > my version is 'openser-1.2.2-notls
'<br>> > --<br>> > Regards,<br>> > Mihail Gluhowchenko.<br>> > Enterprise ELTEX.<br>> ><br>> > 2007/12/10, Daniel-Constantin Mierla < <a href="mailto:daniel@voice-system.ro">
daniel@voice-system.ro</a><br>> <mailto:<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro</a>><br>> > <mailto:<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro</a> <mailto:
<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro</a>>>>:<br>> ><br>> ><br>> ><br>> > On 12/10/07 07:04, Mihail Gluhowchenko wrote:<br>> > > Hello all work; :)
<br>> > was your version old or there is a bug in sc.dbtext? Can you<br>> post the<br>> > patch of changes?<br>> ><br>> > Best regards,<br>> > Daniel
<br>> ><br>> ><br>> > > in script sc.dbtext use old format subscriber.<br>> > > Little changes and all work<br>> > ><br>> > > date_now=$(date +"%s")
<br>> > > GLOB_ID=$(od -N4 -d /dev/random | head -n1 | cut -d' ' -f2,3 |<br>> > sed -e<br>> > > 's/ //')<br>> > ><br>> > > add)
<br>> > > if [ $# -ne 4 ] ; then<br>> > > usage<br>> > > exit 1<br>> > > fi
<br>> > > shift<br>> > > credentials $1 $2<br>> > > is_user $1<br>> > > if [ $? -eq 0 ] ; then
<br>> > > echo -e "\nuser already exists\n"<br>> > > exit 1<br>> > > fi<br>> > > #Add to SUBSCRIBER file
<br>> > > #id(int,auto) username(str) domain(str)<br>> > password(str)<br>> > > first_name(str,null) last_name(str,null) email_address(str)<br>> > > datetime_created(int) last_modified(int) ha1(str) ha1b(str)
<br>> > > rpid(str,null)<br>> > ><br>> > ><br>> ><br>> line="$GLOB_ID:$SERUSER:$SERDOMAIN:$2:::$3:$date_now:$date_now:$HA1:$HA1B:"<br>><br>> >
<br>> > > echo $line >> $SUB_FILE<br>> > > #Add to URI file<br>> > > #id(int,auto) domain(str) uri_user(str)<br>> > > last_modified(int)
<br>> > > line="$GLOB_ID:$SERDOMAIN:$SERUSER:$date_now"<br>> > > echo $line >> $URI_FILE<br>> > > echo -e "\nNew user ($SERUSER@$SERDOMAIN)
<br>> added to<br>> > > DBTEXT files\n"<br>> > > ;;<br>> > > --<br>> > > Regards,<br>> > > Mihail Gluhowchenko.
<br>> > > Enterprise ELTEX.<br>> > ><br>> ><br>> ><br>><br>><br></blockquote></div><br>