[freeside] session_history.cgi

Jerry Sumpton Jerry at Sumpton.com
Thu Dec 18 16:34:51 PST 2003


Rich,
Freeside database initialized successfully &
sponsorateacherpgm.org ran without comment
Thank you!

I hate to admit that I don't understand

Run a separate iteration of Apache[-SSL] with mod_perl enabled as the
freeside user.

and I have the following error when starting:

Starting freeside-queued: freeside-queued started with pid 10888
done.
Starting fs_passwd_server: done.
Starting fs_signup_server: done.
Starting freeside-selfservice-server: freeside-selfservice-server to
localhost started with pid 10899
done.
[root at ns1 init.d]# Insecure dependency in exec while running with -T switch
at /usr/local/lib/perl5/5.8.2/IPC/Open3.pm line 241.
Usage:

  fs_signup_server user machine agentnum refnum
Connection to localhost lost!  Reconnecting...
Insecure dependency in exec while running with -T switch at
/usr/local/lib/perl5/5.8.2/IPC/Open3.pm line 241.

Great progress. Thank you!! Any guidance at this point would be greatly
appreciated.

Thanks, Jerry.




-----Original Message-----
From: Rich Beams [mailto:rbeams at storminteractiveinc.com]
Sent: Tuesday, December 16, 2003 9:33 AM
To: ivan-freeside at sisd.com
Subject: RE: [freeside] session_history.cgi

There you go again Ivan, pointing fingers instead of solving problems. Well,
for those of you that run into this problem here's the workaround that got
my install up and running. I'm building a test environment and just needed
to get it up for some tests. If this workaround has any side effects, Ivan
to chime in, then I would wait for the DBD::Pg bug fix on a production env.
install.

Ok, searches on google groups fixed the problem with a workaround. It may be
a bug in DBD::Pg for sql_types, but you can still use pg_types. Read the
error message.

----------------
Error message when running the "bin/fs-setup <username>' step:

"Cannot specify both sql_type and pg_type at
/usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274."

Workaround: (FYI, not elegant)

    if ( $record->{$field} =~ /^\d+(\.\d+)?$/
         && $dbdef->table($table)->column($field)->type =~ /(int)/i
    ) {
      $sth->bind_param($bind++, $record->{$field}, {pg_type => 21} );
    } else {
      $sth->bind_param($bind++, $record->{$field}, {pg_type => 25} );
    }

----------------






-----Original Message-----
From: ivan [mailto:ivan at 420.am]
Sent: Thursday, December 11, 2003 6:18 PM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] session_history.cgi


This is a DBD::Pg bug, which hopefully will be fixed in DBD::Pg 1.32.
It would be worthwhile to test a current DBD::Pg snapshot from
gborg.postgresql.org and report if the problem has in fact been fixed.

--
_ivan


On Thu, Dec 11, 2003 at 05:32:56PM -0700, Rich Beams wrote:
> I'm installing freeside and get the error below noted in an email post on
> Nov. 21st. Ivan put up a work around but that produced another error also
> noted in an email post. In the CVS it looks like Ivan went back to the
> original syntax. But the current cvs version still throws the original
> error. Is there any solution for this or workaround?
>
> Happens when running 'bin/fs-setup'
>
> "Cannot specify both sql_type and pg_type at
> /usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274."
>
> Thanks.
>
>

--
_ivan








More information about the freeside-users mailing list