[fdo-users] Re: OGR Oracle connection problem

[Jan Małysiak]

Unfortunately, still no success. Maybe it's a matter of environment
variables misconfiguration? I'm a beginner so I might have done something
wrong.

That's a fragment of
/usr/local/mapguideopensource/webserverextensions/apache2/conf/mapguide.conf
:

# Environment variables for MapGuide
SetEnv ORACLE_HOME "/usr/lib/oracle/10.2.0.4/client"
SetEnv TNS_ADMIN "/usr/lib/oracle/10.2.0.4"
SetEnv LD_LIBRARY_PATH "/usr/lib/oracle/
10.2.0.4/client/lib:/usr/local/mapguideopensource/webserverextensions/lib:/usr/local/mapguideopensource/webserverextensions/php/lib:/usr/local/mapguideopensource/lib
"
SetEnv MENTOR_DICTIONARY_PATH
"/usr/local/mapguideopensource/share/gis/coordsys"

That's /usr/local/mapguideopensource/server/bin/mgserver.sh :

/bin/bash -c '#!/bin/sh

export ORACLE_HOME=/usr/lib/oracle/10.2.0.4/client
export TNS_ADMIN=/usr/lib/oracle/10.2.0.4
export
MENTOR_DICTIONARY_PATH=/usr/local/mapguideopensource/share/gis/coordsys
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/local/fdo-3.4.0/lib:"$LD_LIBRARY_PATH"
ulimit -s 1024
pushd /usr/local/mapguideopensource/server/bin
./mgserver run
popd
'

My tnsnames.ora file is located in /usr/lib/oracle/10.2.0.4 .

Thanks for any help,

Best regards,
Jan Małysiak

W dniu 22 sierpnia 2011 15:59 użytkownik Jan Małysiak <
j.malysiak at hotmail.com> napisał:

> Hi Greg, thanks for your reply,
>
> Sure, I checked required libraries with ldd for libOGRProvider-3.4.0.so,
> two of them were missing, as I remember those were libssl.so.6 and
> libcrypto.so.6. I made symbolic links to libssl.so.0.9.8 and
> libcrypto.so.0.9.8 respectively. Could this be the cause of the error?
>
> Best regards,
> Jan Małysiak
>
> W dniu 22 sierpnia 2011 14:23 użytkownik Jan Małysiak <
> j.malysiak at hotmail.com> napisał:
>
> Hi,
>>
>> I would like to connect MapGuide OpenSource to Oracle Spatial database, I
>> use Ubuntu and I've already learned that KingOracle Provider does not work
>> on Linux, so now I attempt to make a connection using OSGeo FDO Provider for
>> OGR. When I test connection in MapGuide Maestro I get "The remote server
>> returned an error: (559) MgFdoException.: An exception occurred in FDO
>> component.". For more details, I looked at error log and that's what I read:
>>
>> <2011-08-22T14:08:14>     -1388410000    MapGuide Maestro v2.1.4.5245
>> 127.0.0.1    Administrator
>>  Error: An exception occurred in FDO component.
>>         Connect failed:
>>  StackTrace:
>>   - MgFeatureServiceHandler.ProcessOperation() line 83 file
>> FeatureServiceHandler.cpp
>>   - MgOpTestFeatureSourceConnection.Execute() line 100 file
>> OpTestFeatureSourceConnection.cpp
>>   - MgFdoConnectionManager.Open() line 893 file
>> FdoConnectionManager.cpp
>>
>> I've searched a lot for similar problems, but I couldn't find any working
>> solution. I've tried multiple various configurations of connection
>> parameters, I've tried also adding Oracle client path to LD_LIBRARY_PATH,
>> but still all my attempts were unsuccessful.
>>
>> I use:
>> MapGuide Open Source 2.1.0
>> FDO 3.4.0
>> MapGuide Maestro 2.1.4
>> Ubuntu 10.10
>> Oracle Instant Client 10.2.0.4
>>
>> Thank you for any help.
>>
>> Best regards,
>> Jan Małysiak
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20110823/56fe7889/attachment.html