[Serusers] issue w/ permissions module
Corey
corey at bitworthy.net
Thu Oct 19 23:10:13 CEST 2006
On Thursday 19 October 2006 01:00, Miklos Tirpak wrote:
> Corey wrote:
> > I'm using postgresql for the db backend for my ser instance, after creating and populating
> > a few obvious tables by handI seem to have it "mostly working". ( using ser-0.9.4 )
> >
> > However, I'm stuck on the following:
> >
> > Oct 18 21:09:36 server /usr/sbin/ser[23595]: ERROR: permissions: trusted_reload(): Database problem
> > Oct 18 21:09:36 server /usr/sbin/ser[23595]: init_trusted(): Reload of trusted table failed
> > Oct 18 21:09:36 server /usr/sbin/ser[23595]: Error while initializing allow_trusted function
> >
>
> there was a bug in postgres module, and unfortunately the SER packages
> do not contain the fix. Get the source from CVS (either branch rel_0_9_0
> or HEAD) and compile it.
>
Cool, thanks for the info!
As an aside, I was able to temporarily workaround the problem by changing:
from:
modparam("usrloc", "db_mode", 1)
to:
modparam("usrloc", "db_mode", 0)
> > ( also, is it possible to use the ser-0.10.x ser_postgres.sh/ser_dbtext.sh scripts
> > for ser-0.9.4, rather than doing it all by hand? )
>
> The database schemas have been changed a lot since 0.9.x, so the files
> in ser_db subdir describing the schema cannot be used for earlier versions.
>
Ah, ok - so next logical question ( which has probably been seen many times already? ):
is there a 0.9.x version/port of the 'ser_mysql.sh' to postgres available anywhere?
Also - approximately how usable is the 0.10.x series at the moment ( for a non-production /
experimental server )? "mostly usable/stable"?, "somewhat usable/stable"? "...good luck"?
Thanks again!
More information about the sr-users
mailing list