[freeside] 2 Problems

[ivan]

On Wed, Aug 22, 2001 at 10:38:11AM -0700, Greg Sibley wrote:
> I am trying to get freeside running on mysql 3.23.36 with
> Apache-AdvancedExtranetServer/1.3.19 and I can't seem to get past these
> two issues.
> 
> Problem 1:
> 	Whenever I try running fs-setup, I get the error  (after the
> radius stuff):
> 	Transactions not supported by database at
> /usr/lib/perl5/site_perl/5.6.0/i386-li
> nux/DBI.pm line 445.
> Issuing rollback() for database handle being DESTROY'd without explicit
> disconnect().
> 
> I have isolated it down to the line in fs-setup:
> 	&FS::Record::reload_dbdef($dbdef_file);
> 
> 	I have BDB tables enabled.  I have run test creating a generic
> table and they default to type BDB.  I'm not sure why it thinks that
> transactions are not supported.  Can anyone help with this?

I'd guess it is a problem with the DBD::mysql module you are using.  You
didn't post the version of DBD::mysql you are using, as per the
instructions sent to you when you signed up for the mailing list, so I'm
unable to say for sure. 

the DBD::mysql module is supported on a mailing list.  See the `MAILING
LIST SUPPORT' section of the DBD::mysql manpage.

> Problem 2:  Having problems with running under the freeside user.
>   I keep getting the error:
>    Not running uid freeside! at /home/httpd/html/freeside/edit/cust_main.cgi
> line 153
> 
> 	I know I have suExec installed.  If I look at the apache log, it
> says that it is enabled.

Using suExec, check each of the 20 steps at 
http://www.apache.org/docs-2.0/suexec.html#model

>  I also re-compiled Perl to use setuid emulation,
> but the problem still exists.  The perl version I am running is:  v5.6.0
> built for i386-linux.  Permissions are set as on the /html/freeside
> directory as follows:
>
> drwxr-sr-x    2 freeside users        4096 Aug 19 11:07 browse/
> drwxr-sr-x    3 freeside users        4096 Aug 19 11:07 docs/
> drwxr-sr-x    3 freeside users        4096 Aug 19 11:07 edit/
> drwxr-sr-x    2 freeside users        4096 Aug 19 11:07 images/
> -r-xr-xr-x    1 freeside users        5596 Aug 19 11:07 index.html*
> drwxr-sr-x    3 freeside users        4096 Aug 19 11:07 misc/
> drwxr-sr-x    2 freeside users        4096 Aug 19 11:07 search/
> drwxr-sr-x    2 freeside users        4096 Aug 19 11:07 view/
>
> Any ideas on this one?

This shows the permissions of directories and a static .html file, but it
is the permissions of the .cgi files which is relevant.

Since the permissions need to be different using Perl's setuid emulation
than using suExec, first pick which one you are using.  Next, verify that
it is working.  Then set the permissions as documented in
htdocs/docs/install.html

-- 
_ivan