DBD::ODBC works as root but not as non-root user

prgupta has asked for the wisdom of the Perl Monks concerning the following question:

DBD::ODBC works as root but not as non-root user on CentOS5 - any ideas? vert1:/home/dbadmin $ perl tempread.pl install_driver(ODBC) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: libodbc.so.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230. And as root on same machine everything works fine: root@vert1:/usr/local# perl /home/dbadmin/tempread.pl 1 2 Any ideas?

Comment on DBD::ODBC works as root but not as non-root user

Replies are listed 'Best First'.
Re: DBD::ODBC works as root but not as non-root user by Anonymous Monk on Jul 09, 2010 at 05:42 UTC
any ideas? Which part of cannot open shared object file is a mystery? Its always the enviroment and permissions .	[reply]
Re^2: DBD::ODBC works as root but not as non-root user by prgupta (Initiate) on Jul 09, 2010 at 06:16 UTC
ODBC.so has global r and x privs - so why would this be an issue?	[reply]
Re^3: DBD::ODBC works as root but not as non-root user by Anonymous Monk on Jul 09, 2010 at 06:25 UTC
ODBC.so has global r and x privs - so why would this be an issue? Um, what? ...ODBC.so' for module DBD::ODBC: libodbc.so.1: cannot open shared object file Compare your %ENV to roots %ENV, and you'll notice differences in LD_LIBRARY_PATH ... ldd ODBC.so	[reply]
Re^4: DBD::ODBC works as root but not as non-root user by mje (Curate) on Jul 12, 2010 at 09:03 UTC