Unfortunately, still no success. Maybe it's a matter of environment variables misconfiguration? I'm a beginner so I might have done something wrong.<br><br>That's a fragment of /usr/local/mapguideopensource/webserverextensions/apache2/conf/mapguide.conf :<br>
<br># Environment variables for MapGuide<br>SetEnv ORACLE_HOME "/usr/lib/oracle/<a href="http://10.2.0.4/client">10.2.0.4/client</a>"<br>SetEnv TNS_ADMIN "/usr/lib/oracle/<a href="http://10.2.0.4">10.2.0.4</a>"<br>
SetEnv LD_LIBRARY_PATH "/usr/lib/oracle/<a href="http://10.2.0.4/client/lib:/usr/local/mapguideopensource/webserverextensions/lib:/usr/local/mapguideopensource/webserverextensions/php/lib:/usr/local/mapguideopensource/lib">10.2.0.4/client/lib:/usr/local/mapguideopensource/webserverextensions/lib:/usr/local/mapguideopensource/webserverextensions/php/lib:/usr/local/mapguideopensource/lib</a>"<br>
SetEnv MENTOR_DICTIONARY_PATH "/usr/local/mapguideopensource/share/gis/coordsys"<br><br>That's /usr/local/mapguideopensource/server/bin/mgserver.sh :<br><br>/bin/bash -c '#!/bin/sh<br><br>export ORACLE_HOME=/usr/lib/oracle/<a href="http://10.2.0.4/client">10.2.0.4/client</a><br>
export TNS_ADMIN=/usr/lib/oracle/<a href="http://10.2.0.4">10.2.0.4</a><br>export MENTOR_DICTIONARY_PATH=/usr/local/mapguideopensource/share/gis/coordsys<br>export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/local/fdo-3.4.0/lib:"$LD_LIBRARY_PATH"<br>
ulimit -s 1024<br>pushd /usr/local/mapguideopensource/server/bin<br>./mgserver run<br>popd<br>'<br><br>My tnsnames.ora file is located in /usr/lib/oracle/<a href="http://10.2.0.4">10.2.0.4</a> .<br><br>Thanks for any help,<br>
<br>Best regards,<br>Jan Małysiak<br><br><div class="gmail_quote">W dniu 22 sierpnia 2011 15:59 użytkownik Jan Małysiak <span dir="ltr"><<a href="mailto:j.malysiak@hotmail.com">j.malysiak@hotmail.com</a>></span> napisał:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi Greg, thanks for your reply,<br><br>Sure, I checked required libraries with ldd for <a href="http://libOGRProvider-3.4.0.so" target="_blank">libOGRProvider-3.4.0.so</a>, 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?<br>
<br>Best regards,<br>Jan Małysiak<br><br><div class="gmail_quote">W dniu 22 sierpnia 2011 14:23 użytkownik Jan Małysiak <span dir="ltr"><<a href="mailto:j.malysiak@hotmail.com" target="_blank">j.malysiak@hotmail.com</a>></span> napisał:<div>
<div></div><div class="h5"><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi,<br><br>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:<br>
<br><2011-08-22T14:08:14> -1388410000 MapGuide Maestro v2.1.4.5245 127.0.0.1 Administrator<br> Error: An exception occurred in FDO component.<br> Connect failed: <br> StackTrace:<br> - MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp<br>
- MgOpTestFeatureSourceConnection.Execute() line 100 file OpTestFeatureSourceConnection.cpp<br> - MgFdoConnectionManager.Open() line 893 file FdoConnectionManager.cpp <br><br>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.<br>
<br>I use:<br><span><span>MapGuide</span> Open Source 2.1.0
</span><br><span>FDO 3.4.0
</span><br><span><span>MapGuide</span> Maestro 2.1.4
</span><br><span>Ubuntu 10.10
</span><br><span>Oracle Instant Client 10.2.0.4
</span><br><br>Thank you for any help.<br><br>Best regards,<br><font color="#888888">Jan Małysiak<br>
</font></blockquote></div></div></div><br>
</blockquote></div><br>