[Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2

[Ovidiu Sas]

Then pls. create a patch and upload the patch to the traker:

diff -Naur textdb.sh.old textdb.sh.new


Regards,
Ovidiu Sas

On 3/20/07, Daryl Sanders <daryl.sanders at gmail.com> wrote:
> One correction to my previous post...
>
> When using method 2 (textdb.sh) to create dbtext tables, the
> subscriber table format appears broken. I was able to correct this
> issue by using the following columns.
>
> phplib_id(str) username(str) domain(str) password(str)
> first_name(str,null) last_name(str,null) phone(str,null)
> email_address(str) datetime_created(int,null)
> datetime_modified(int,null) confirmation(str,null) flag(str,null)
> sendnotification(str,null) greeting(str,null) ha1(str) ha1b(str)
> allow_find(str) timezone(str,null) rpid(str,null) domn(int,null)
> uuid(str,null)
>
> - Daryl
>
>
> On 3/20/07, Daryl Sanders <daryl.sanders at gmail.com> wrote:
> > When using db_mode=1,2 or 3 I get the following error when starting
> > OpenSER 1.2 using dbtext as the usrloc DB.
> >
> >  1(23052) preload_udomain(): Error while doing db_query
> >  1(23052) ERROR:ul:child_init(1): Error while preloading domain 'location'
> >  1(23052) ERROR:init_mod_child: Error while initializing module usrloc, rank 1
> >
> > I am wondering if their may be a problem with the columns in the
> > location table file.
> >
> > I tried two different methods of creating the initial table files...
> >
> > 1.) sc.dbtext dbtext /usr/local/etc/openser/dbtext/
> > 2.) textdb.sh create /usr/local/etc/openser/dbtext/
> >
> > The first method has problems with the version file that I tried to
> > repair by trying to mimic the mysql table structure.
> >
> > The second method seems to work ok with the exception of the error I
> > mentioned above when starting OpenSER.
> >
> > Any help would be greatly appreciated!
> >
> > Thanks,
> > Daryl
> >
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>