SBEAMS log in

[Rich]

Howdy everyone,
So I have been installing SBEAMS on a Linux enterprise machine, with
WIN XP running SQL server. The machines are connnected by freetds and
when I log into the sbeams http://"myIP"/dev1/sbeams/ I get the log in
page. When I try to login I receive the error below. I have installed
the most recent perl module DBD::Sybase (DBD-Sybase-1.05_03 to be
exact) from cpan.org
I installed:
perl Makefile.PL PREFIX=/usr/lib/perl5/5.8.5
make
make install

Additionally, I added the env
SYBASE=/usr/local/freetds
in my bash profile

Despite those things at
http://"my IP"/dev1/sbeams/cgi/main.cgi

I recieve:

SBEAMS Error:

install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC
contains: . /var/www/html/dev1/sbeams/cgi//../lib/perl
/usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl .) at (eval 18) line 3.
Perhaps the DBD::Sybase perl module hasn't been fully installed,
or perhaps the capitalisation of 'Sybase' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at
/var/www/html/dev1/sbeams/cgi//../lib/perl/SBEAMS/Connection/DBConnector.pm
line 139

Any advice folks can give me would be muchly appreciated
take care and thanks ahead of time
-Rich

[Eric Deutsch]

Hi Rich, you should not need to define SYBASE in your profile. You
should only need to define it once before compiling DBD-Sybase.

The error indicates that the instance of Perl you're running does not
believe that DBD-Sybase is installed. So either the install failed, or
you installed it for some other version of Perl existing on your box.

Things to check are: All SBEAMS scripts use /usr/local/bin/perl. I
suggest making this a symbolic link to your desired Perl instance

Type `which perl` to see what perl is being invoked. You might want to
try:

/usr/local/bin/perl Makefile.PL

Instead of:

perl Makefile.PL PREFIX=/usr/lib/perl5/5.8.5

Let us know if this doesn't seem to help.

If your distro contains $SBEAMS/lib/scripts/Core/SimpleDBITest.pl, try
to use that to verify that your database driver is working. If you
don't have it, post again and we'll send it to you.

Regards,
Eric

[Rich]

I tried your suggestions:
/usr/local/bin/perl Makefile.PL
gives me a new error

install_driver(Sybase) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'
for module DBD::Sybase: libct.so.3: cannot open shared object file: No
such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
at (eval 18) line 3
Compilation failed in require at (eval 18) line 3.
Perhaps a required shared library or dll isn't installed where expected
at
/var/www/html/dev1/sbeams/cgi//../lib/perl/SBEAMS/Connection/DBConnector.pm
line 139

what file (module) do you think I could be missing?
The symbolic link was set during installation
'which perl' shows:
/usr/local/bin/perl

Any advice you have would be appreciated

I don't have the
SimpleDBITest.pl could you send it to:
gre...@u.washington.edu

Thank you so much Eric
-Rich

[Eric Deutsch]

Hi Rich, this is encouraging, actually. I think the final fix may just
to do as root:

echo "/usr/local/freetds/lib" >> /etc/ld.so.config
ldconfig

and then the DynaLoader will find the .so. Try that and let us know how
it goes.

Eric


> -----Original Message-----
> From: spctools...@googlegroups.com [mailto:spctools-
> dis...@googlegroups.com] On Behalf Of Rich

[Rich]

Hey Eric,
So I tried the scripts you posted but still get the same error:

install_driver(Sybase) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'
for module DBD::Sybase: libct.so.3: cannot open shared object file: No
such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
at (eval 18) line 3
Compilation failed in require at (eval 18) line 3.
Perhaps a required shared library or dll isn't installed where expected
at
/var/www/html/dev1/sbeams/cgi//../lib/perl/SBEAMS/Connection/DBConnector.pm
line 139

Could do you think could be incorrect?
Any suggestions are muchly appreciated.
thanks
-Rich

[Rich]

So I wanted to update you on my SBEAMS installation. The problem I am
have has to do with the DBD::Sybase connection with FreeTDS. FreeTDS is
installed and I have tested it with tsql. It connects to my
server/SBEAMS database. The error (mentioned in the previous post)
shows the driver failing because it can not find a shared object that
it is trying to load. The object is Sybase.so. Sybase.so tries to use
library libct.so.3 which it can not find because it is not in a library
search path. Listed below are the attempts I've taken to fix this
problem. None of which (so far) have worked.

1. Running the following
echo "/usr/local/freetds/lib" >> /etc/ld.so.config
ldconfig

2. tried this:
export LD_LIBRARY_PATH=/usr/local/freetds/lib:$LD_LIBRARY_PATH

3. add the following line to the /etc/ld.so.conf file
usr/local/freetds/lib

ran this
4. LD_DEBUG=all perl -e 'use DBD::Sybase;'

Any feedback is appreciated
thanks
-Rich

[Brian Pratt]

Where is libct.so.3 located?

> -----Original Message-----
> From: spctools...@googlegroups.com
> [mailto:spctools...@googlegroups.com] On Behalf Of Rich
> Sent: Friday, July 29, 2005 7:07 PM
> To: spctools-discuss
> Subject: Re: SBEAMS log in
>
>

[Brian Pratt]

Also, this may be of interest:
http://lists.ibiblio.org/pipermail/freetds/2003q3/013463.html

HTH!

[Rich]

libct.so.3 is located in
/usr/local/freetds/lib

[root@localhost lib]# ls
libct.a libsybdb.a libtds.a libtdssrv.a
libct.la libsybdb.la libtds.la libtdssrv.la
libct.so libsybdb.so libtds.so libtdssrv.so
libct.so.3 libsybdb.so.5 libtds.so.4 libtdssrv.so.2
libct.so.3.0.0 libsybdb.so.5.0.0 libtds.so.4.0.0 libtdssrv.so.2.0.0

[Rich]

Thanks Brian for the suggestions. I have tried

export LD_LIBRARY_PATH=/usr/local/freetds/lib

and then I added
/usr/local/freetds/lib to /etc/ld.so.conf and then ran ldconfig.

I still seem to getting the same error message though

I'm puzzled

install_driver(Sybase) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'

for module DBD::Sybase: libct.so.3: failed to map segment from shared
object: Permission denied at

/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
at (eval 18) line 3
Compilation failed in require at (eval 18) line 3.
Perhaps a required shared library or dll isn't installed where expected
at
/var/www/html/dev1/sbeams/cgi//../lib/perl/SBEAMS/Connection/DBConnector.pm
line 139

-Rich

[michael...@gmail.com]

Rich wrote:
> Thanks Brian for the suggestions. I have tried
>
> export LD_LIBRARY_PATH=/usr/local/freetds/lib
>
> and then I added
> /usr/local/freetds/lib to /etc/ld.so.conf and then ran ldconfig.
>
> I still seem to getting the same error message though
>
> I'm puzzled
>
> install_driver(Sybase) failed: Can't load
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'
> for module DBD::Sybase: libct.so.3: failed to map segment from shared
> object: Permission denied at

You are getting hit by the SElinux setting which doesn't let you load
libraries from non-system directories by default.

You can disable SElinux, or check the docs to see how to allow libs to
load from that directory.

Michael

[Rich]

Thank you so much michael you are a life saver. I shut off the SElinux
and now I can see the SBEAMS log in interface. Unfortunately now when
I log in I get:

Server message number=208 severity=16 state=1 line=1
server=RICHSMACHINE text=Invalid object name 'sbeams.dbo.user_login'.
at
/var/www/html/dev1/sbeams/cgi//../lib/perl/SBEAMS/Connection/DBInterface.pm
line 779

I am aware that this message indicates it can not find a table, but I
have followed the sbeams notes precisely and executed the runsql.pl
statements loading info into my database. I checked my SBEAMS.conf file
and made sure my mssql database was named properly sbeams.dbo. I also
tried renaming to sbeams.Core , but recieved a similair error. If
anyone has any advice I was really appreciate it. thanks
-Rich