[Mono-list] Re: MySQL Connection from .NET Website (David P. Donahue)
Joe Audette
joe_audette@yahoo.com
Wed, 2 Feb 2005 18:44:53 -0800 (PST)
I've seen this many times. It says file not found but
more accurate would be "Couldn't load assembly".
Are you compiling it on windows with vs.net then
deploying it on linux?
If so, you will get that error unless you use release
build and rebuild (not just build). mono doesn't like
the vs.net incremental builds. Also if there is any
other dotnet assemblies in the dependency chain for
the MySQL .NET connector (I'm thinking sharpziplib
might be one) it also has to be compiled with release
rebuild.
Alternatively you can compile on the linux machine and
it should work.
For the MySQL .NET connector, you might also consider
installing it in the GAC (Global Assembly Cache). I
haven't done this yet so I'm not sure how but I am
sure its possible.
Your other option is don't use the .NET Connector, use
the previous version under the ByteFx.Data namespace.
It ships with mono and is already in the GAC if you
installed it. Thats what I use for mojoPortal running
MySQL.
Hope that helps,
Joe Audette
http://www.mojoportal.com
http://www.joeaudette.com
--- "David P. Donahue" <ddonahue@ccs.neu.edu> wrote:
> caner Sahan wrote:
> > Hi;
> >
> > I think you are using MonoForge hosting and you
> gave this error from
> > there.
>
> I'm pretty sure I'm not.
>
> > When i was putting my application on this web
> hosting i gave some
> > error like this.You can find your answer in
> monoforge forum.
>
> I'd never actually heard of MonoForge, thanks for
> telling me about it.
> I was searching through the forums just now and
> didn't find my specific
> issue, but some stuff closely related. I found some
> recommendations to
> other people there to use the MySQL Connector/Net
> library from the MySQL
> website. I added the .dll, changed my code
> accordingly (it's exactly
> the same except for the new namespace), and tried
> running that. But now
> Mono is returning the error:
>
> System.IO.FileNotFoundException: File
> '/home/www/.www/test/bin/MySql.Data.dll' not found.
>
> Now, the file is most definitely there, and most
> definitely
> world-readable. Any ideas what might be causing
> this new error?
>
>
> Regards,
> David P. Donahue
> ddonahue@ccs.neu.edu
>
>
> > >From: mono-list-request@lists.ximian.com
> > >Reply-To: mono-list@lists.ximian.com
> > >To: mono-list@lists.ximian.com
> > >Subject: Mono-list digest, Vol 1 #2303 - 12 msgs
> > >Date: Wed, 02 Feb 2005 06:35:02 -0500
> > >
> > >Send Mono-list mailing list submissions to
> > > mono-list@lists.ximian.com
> > >
> > >To subscribe or unsubscribe via the World Wide
> Web, visit
> > >
> http://lists.ximian.com/mailman/listinfo/mono-list
> > >or, via email, send a message with subject or
> body 'help' to
> > > mono-list-request@lists.ximian.com
> > >
> > >You can reach the person managing the list at
> > > mono-list-admin@lists.ximian.com
> > >
> > >When replying, please edit your Subject line so
> it is more specific
> > >than "Re: Contents of Mono-list digest..."
> > >
> > >
> > >Today's Topics:
> > >
> > > 1. RE: mod_mono & xsp (Chris Aitken)
> > > 2. Re: mod_mono & xsp (Elfyn McBratney)
> > > 3. RE: mod_mono & xsp (Chris Aitken)
> > > 4. SetHandler vs. AddHandler (David P.
> Donahue)
> > > 5. xsp.exe as windows service (marius popa)
> > > 6. Re: SetHandler vs. AddHandler (Gonzalo
> Paniagua Javier)
> > > 7. Difference in Obsolete attribute
> behaviour (Jakub Linhart)
> > > 8. [OT] post-structuralist object oriented
> system (PA)
> > > 9. Re: HTML 4.01 and XHTML DOM
> Implementation? (Atsushi Eno)
> > > 10. "special" comments in the code/ Monodoc?
> (Julien Sobrier)
> > > 11. MySQL Connection from .NET Website (David
> P. Donahue)
> > > 12. consuming 'php nusoap' webservice (Arturo
>
> > =?ISO-8859-1?Q?Gonz=E1lez?=)
> > >
> > >--__--__--
> > >
> > >Message: 1
> > >From: "Chris Aitken" <chris@ion-dreams.com>
> > >To: <mono-list@lists.ximian.com>
> > >Subject: RE: [Mono-list] mod_mono & xsp
> > >Date: Tue, 1 Feb 2005 12:52:39 -0000
> > >
> > > > > Are you by any chance running with a
> threaded (Apache) MPM?
> > > >
> > > > Yes, I'm running Apache 2.0.53 with pre-fork
> MPM.
> > >
> > >Does this affect the way that
> mod_mono/mod-mono-server works?
> > >
> > >Debian has 3 options with apache2 (MPM = multi
> processing module)
> > >
> > >Apache2-mpm-worker (threaded implemetation,
> recommended)
> > >Apache2-mpm-prefork (non threaded, preforking)
> > >Apache2-mpm-perchild (per-child threaded module)
> > >
> > >Which one of these is the one to go for?
> > >
> > >Cheers
> > >
> > >Chris
> > >
> > >
> > >--
> > >This message has been scanned for viruses and
> > >dangerous content by MailScanner, and is
> > >believed to be clean.
> > >
> > >
> > >--__--__--
> > >
> > >Message: 2
> > >From: Elfyn McBratney <beu@emcb.demon.co.uk>
> > >To: mono-list@lists.ximian.com
> > >Subject: Re: [Mono-list] mod_mono & xsp
> > >Date: Tue, 1 Feb 2005 13:09:14 +0000
> > >
> > >--nextPart1185175.ngL1xkugPx
> > >Content-Type: text/plain;
> > > charset="iso-8859-1"
> > >Content-Transfer-Encoding: quoted-printable
> > >Content-Disposition: inline
> > >
> > >Hello Giuseppe,
> > >
> > >On Tuesday 01 Feb 2005 06:45, Giuseppe Greco
> wrote:
> > > > Hi Elfyn,
> > > >
> > > > >> ...
> > > > >>
> > > > >> I've followed step-by-step what described
> in file INSTALL. By
> > default,
> > > > >> mod_mono is configured to run
> mod-mono-server automatically,
> > isn't it?
> > > > >
> > > > > It is (or was ;-)
> > > > >
> > > > >> So where can I look further?
> > > > >
> > > > > Are you by any chance running with a
> threaded (Apache) MPM?
> > > >
> > > > Yes, I'm running Apache 2.0.53 with pre-fork
> MPM.
> > >
> > >prefork is non-threaded, btw. :-) The reason I
> asked is that we're
> > getting=
> > > a=20
> > >few reports in Gentoo land of mod_mono not
> working, and at the moment
> > a =20
> > >threaded MPM seems to be the culprit.
> > >
> > >Best,
> > >Elfyn
> > >
> > >=2D-=20
> > >Elfyn McBratney
> > >beu on irc.freenode.net/savannah.[non]gnu.org
> > >
> > >PGP Key ID: 0x456548B4
> > >PGP Key Fingerprint:
> > > 29D5 91BB 8748 7CC9 650F 31FE 6888 0C2A 4565
> 48B4
> > >
> > >--nextPart1185175.ngL1xkugPx
> > >Content-Type: application/pgp-signature
> > >
> > >-----BEGIN PGP SIGNATURE-----
> > >Version: GnuPG v1.2.6 (GNU/Linux)
> > >
> >
>
>iD8DBQBB/39/gH4Q50OD3mwRArJwAJ96cl73Ziv9GT7HjgMYIqWdUnANYACeIT3e
> > >4oJzcUnU10JVtRaogD0UpDE=
> > >=HQaO
> > >-----END PGP SIGNATURE-----
> > >
> > >--nextPart1185175.ngL1xkugPx--
> > >
> > >--__--__--
> > >
> > >Message: 3
> > >From: "Chris Aitken" <chris@ion-dreams.com>
> > >To: <mono-list@lists.ximian.com>
> > >Subject: RE: [Mono-list] mod_mono & xsp
> > >Date: Tue, 1 Feb 2005 13:27:23 -0000
> > >
> > > > prefork is non-threaded, btw. :-) The reason
> I asked is that
> > > > we're getting a few reports in Gentoo land of
> mod_mono not
> > > > working, and at the moment a threaded MPM
> seems to be the culprit.
> > >
> > >I'm running 3 systems, all debian sarge, 2 with
> the debian unstable mono
> > >modules (apart from mod-mono-server & mod-mono).
> > >
> > >Each has the same packages loaded, and each has
> the FC2
> > >mod-mono-server/mod_mono rpms installed (via
> alien).
> > >
> > >A third system has the monobundle installed, and
> the FC2 rpms (again via
> > >alien).
> > >
> > >The third system starts mod-mono-server
> automatically, but will not
> > stop it
> > >(so I wrote a shell script). Out of the other
> two, one works
> > perfectly, the
> > >other not at all (unless mod-mono-server started
> by hand - no
> > >/tmp/mod_mono_server appears).
> > >
> > >Every system has the same
> webapp/mod-mono-server.exe.config files etc.
> > They
> > >all use apache2-mpm-prefork.
> > >
> > >Chris
> > >
> > >
> > >--
> > >This message has been scanned for viruses and
> > >dangerous content by MailScanner, and is
> > >believed to be clean.
> > >
> > >
> > >--__--__--
> > >
> > >Message: 4
> > >Date: Tue, 01 Feb 2005 11:01:49 -0500
> > >From: "David P. Donahue" <ddonahue@ccs.neu.edu>
> > >To: mono-list@lists.ximian.com
> > >Subject: [Mono-list] SetHandler vs. AddHandler
> > >
> > >I just installed the Mono Apache Module and
> started testing some basic
> > >C# websites with it. I was noticing that
> certain files (specifically in
> > >the case of these small sites, .gif and .css
> files) were being returned
> > >but the clients couldn't understand them. In
> debugging the problem, I
> > >found the section in the INSTALL file as
> follows:
> > >
> > >-------------------------
> > >If you don't want mod-mono-server to handle all
> the files, but only
> > > ASP.NET ones, you can replace the
> 'SetHandler mono' by:
> > >
> > > AddHandler mono .aspx .ascx .asax .ashx
> .config .cs .asmx
> > >
> > > but this will break PathInfo.
> > >-------------------------
> > >
> > >I made this change in my httpd.conf where I
> specify the folders that
> > >require Mono's use, and this seems to have fixed
> the problem. My
> > >concern, however, is where it says "this will
> break PathInfo." I'm not
> > >entirely sure what that means. What are the
> negative aspects of this
> > >configuration change? Will it come back to bite
> me later? Is there a
> > >better way to fix this problem? I appreciate
> any advice you can give
> > >me, thanks.
> > >
> > >
> > >Regards,
> > >David P. Donahue
> > >ddonahue@ccs.neu.edu
> > >
> > >
> > >--__--__--
> > >
> > >Message: 5
> > >Date: Tue, 1 Feb 2005 19:36:35 +0200
> > >From: marius popa <mapopa@gmail.com>
> > >Reply-To: marius popa <mapopa@gmail.com>
> > >To: mono-list@lists.ximian.com
> > >Subject: [Mono-list] xsp.exe as windows service
> > >
> > >I have started apache and xsp (unsing mod_proxy
> module)
> > >and want to put xsp.exe to run as serivice at
> startup
> > >What should i do ? add service code for xsp ?
> > >
> > >--__--__--
> > >
> > >Message: 6
> > >Subject: Re: [Mono-list] SetHandler vs.
> AddHandler
> > >From: Gonzalo Paniagua Javier
> <gonzalo@ximian.com>
> > >Reply-To:
> reply.to.the.list.iam.suscribed@notexists.ximian.com
> > >To: mono-list@lists.ximian.com
> > >Organization: Novell, Inc.
> > >Date: Tue, 01 Feb 2005 13:35:57 -0500
> > >
> > >On Tue, 2005-02-01 at 11:01 -0500, David P.
> Donahue wrote:
> > > > I just installed the Mono Apache Module and
> started testing some basic
> > > > C# websites with it. I was noticing that
> certain files
> > (specifically in
> > > > the case of these small sites, .gif and .css
> files) were being
> > returned
> > > > but the clients couldn't understand them. In
> debugging the problem, I
> > > > found the section in the INSTALL file as
> follows:
> > > >
> > > > -------------------------
> > > > If you don't want mod-mono-server to handle
> all the files, but only
> > > > ASP.NET ones, you can replace the
> 'SetHandler mono' by:
> > > >
> > > > AddHandler mono .aspx .ascx .asax
> .ashx .config .cs .asmx
> > > >
> > > > but this will break PathInfo.
> > > > -------------------------
> > > >
> > > > I made this change in my httpd.conf where I
> specify the folders that
> > > > require Mono's use, and this seems to have
> fixed the problem. My
> > > > concern, however, is where it says "this will
> break PathInfo." I'm
> > not
> > > > entirely sure what that means. What are the
> negative aspects of this
> > > > configuration change? Will it come back to
> bite me later? Is there a
> > > > better way to fix this problem? I appreciate
> any advice you can give
> > > > me, thanks.
> > >
> > >For an URL like this:
> >
>
>http://www.someserver.com/somedir/somefile.ext/andthis/andthat
> > >
> > >if /somedir/somefile.ext exists,
> /andthis/andthat is that pathinfo. As
> > >long as you don't use that in the virtual
> directories handled by
> > >mod-mono, you're fine.
> > >
> > >-Gonzalo
> > >
> > >
> > >
> > >--__--__--
> > >
> > >Message: 7
> > >Date: Tue, 01 Feb 2005 23:36:56 +0100
> > >From: Jakub Linhart <jakub.linhart@vslib.cz>
> > >To: mono-list@lists.ximian.com
> > >Subject: [Mono-list] Difference in Obsolete
> attribute behaviour
> > >
> > >I have code like this:
> > > 1 class TestClass1 {
> > > 2 [Obsolete ("This method ObsoleteMethod1
> is obsolete.", false)]
> > > 3 public static void ObsoleteMethod1() {
> > > 4 Console.WriteLine ("Executing
> ObsoleteMethod1()");
> > > 5 }
> > > 6 }
> > >
> > > 7 class TestClass2 {
> > > 8 [Obsolete ("This method ObsoleteMethod2
> is obsolete.", true)]
> > > 9 public static void ObsoleteMethod2() {
> > >10 TestClass1.ObsoleteMethod1();
> > >11 }
> > >12 public static void NewMethod2() {
> > >13 TestClass1.ObsoleteMethod1();
> > >14 ObsoleteMethod2();
> > >15 }
> > >16}
> > >
> > >If this code fragment is compiled under .NET
> framework, CSC reports one
> > >error (CS0619) on line 13 and one warning
> (CS0618) at line 14. You get
> > >2 errors (line 10, line 13) and 1 warning (line
> 14) under MONO 1.05
> > >(mcs). It looks like that CSC ignores every call
> to method marked as
> > >obsolete from other obsolete method. MCS reports
> every call to obsolete
> > >method as error or warning. Is it particular
> reason for such a behaviour?
> > >
> > >--__--__--
> > >
> > >Message: 8
> > >To: mono-list@lists.ximian.com
> > >From: PA <petite.abeille@gmail.com>
> > >Date: Tue, 1 Feb 2005 21:46:25 +0100
> > >Subject: [Mono-list] [OT] post-structuralist
> object oriented system
> > >
> > >Not really a question, but rather for your
> entertainment:
> > >
> > >"Lua=92s Story of O"
> > >http://alt.textdrive.com/lua/19/lua-story-of-o
> > >
> > >Cheers
> > >
> > >--
> > >PA, Onnay Equitursay
> > >http://alt.textdrive.com/
> > >
> > >
> > >--__--__--
> > >
> > >Message: 9
> > >Date: Wed, 02 Feb 2005 07:01:12 +0900
> > >From: Atsushi Eno <atsushi@ximian.com>
> > >To: Edgardo Rossetto <erossetto@speedy.com.ar>
> > >Cc: mono-list@lists.ximian.com
> > >Subject: Re: [Mono-list] HTML 4.01 and XHTML DOM
> Implementation?
> > >
> > >Hi,
> > >
> > > > - Does anyone know a HTML 4.01 / XHTML
> implementation of the DOM,
> > or is
> > > > only System.Xml (XML 1.0 and 2.0 only AFAIK)
> avaiable?
> > >
> > >At least I don't know.
> > >
> > > > - Any ideas if .NET 2.0 will have?
> > >
> > >I think never.
> > >
> > > > - Any plans to make a Mono Class for this?
> > >
> > >No, but if anyone would like to contribute, it
> is nice.
> > >
> > > > Is it possible to "load" the DTD
> specification for HTML 4.01 and XML
> > > > usiing the System.Xml namespace or am I just
> dreaming?
> > >
> > >There is an obsolete sample named SgmlReader in
> gotdotnet which is
> > >left buggy, unsupported, and incompatible with
> free software.
> > >
> > >Atsushi Eno
> > >
> > >--__--__--
> > >
> > >Message: 10
> > >Date: Tue, 01 Feb 2005 21:14:40 -0800
> > >From: Julien Sobrier <julien@sobrier.net>
> > >To: mono-list@lists.ximian.com
> > >Subject: [Mono-list] "special" comments in the
> code/ Monodoc?
> > >
> > >Hello,
> > >once I found a page explaining how to format the
> comments (like
> > ><c>MyClass</c>) inside the code to then generate
> automatically a doc for
> > >our code. I'm not sure this is exactly what
> Monodoc is using.
> > >
> > >I cannot find this link anymore.
> > >
> > >Anybody know what I'm talking about?
> > >
> > >Thanks
> > >Julien
> > >
> > >--__--__--
> > >
> > >Message: 11
> > >Date: Tue, 01 Feb 2005 21:52:07 -0500
> > >From: "David P. Donahue"
> <david.donahue@us.army.mil>
> > >To: mono-list <mono-list@lists.ximian.com>
> > >Subject: [Mono-list] MySQL Connection from .NET
> Website
> > >
> > >I'm trying to track down a problem with websites
> using a connection to a
> > >MySQL database. Has anyone had any problems
> using the CoreLab.MySQL.dll
> > >libraries with Mono? If it's known not to work,
> is there a
> > >different/better way to connect to the database?
> For reference, the
> > >code used in a simple test page is as follows
> (sorry for any wrapping):
> > >
> > >MySqlConnection mySqlConnectionGrid;
> > >MySqlDataAdapter mySqlDataAdapter;
> > >DataSet dataSetGrid;
> > >string stringSQL;
> > >stringSQL = "SELECT * FROM
> Reference_DaysOfTheWeek";
> > >mySqlConnectionGrid = new
> > MySqlConnection(Global.stringDatabaseConnection);
> > >mySqlDataAdapter = new
> MySqlDataAdapter(stringSQL, mySqlConnectionGrid);
> > >dataSetGrid = new DataSet();
> > >mySqlDataAdapter.Fill(dataSetGrid);
> > >dataListDOTW.DataSource = dataSetGrid;
> > >dataListDOTW.DataBind();
> > >
> > >And the problem this has been giving me is that
> the server simply hangs
> > >when this page is requested until it eventually
> times out. Any ideas?
> > >
> > >
> > >Regards,
> > >David P. Donahue
> > >ddonahue@ccs.neu.edu
> > >
> > >--__--__--
> > >
> > >Message: 12
> > >From: Arturo =?ISO-8859-1?Q?Gonz=E1lez?=
> <arturogf@ugr.es>
> > >To: mono-list <mono-list@lists.ximian.com>
> > >Date: Wed, 02 Feb 2005 11:50:03 +0100
> > >Subject: [Mono-list] consuming 'php nusoap'
> webservice
> > >
> > >Hi,
> > >
> > >I'm trying to develop an example client for
> ILIAS open source
> > >webservice, lately supported by novell
> > >(http://www.ilias.uni-koeln.de/ios/index-e.html)
> , but i'm having
> > >problems with a remote function that returns an
> integer.
> > >
> > >The server is located at:
> > >
> >
>
>http://tad1.ugr.es/ilias_3_3_x/webservice/soap/server.php
> >
>
>http://tad1.ugr.es/ilias_3_3_x/webservice/soap/server.php?wsdl
> > >
> > >if i try to consume the lookupUser method as
> follows:
> > >
> > >int user_id = ilUA.lookupUser(sess_id,
> "soap_user");
> > >
> > >Then the compiler says that can't convert from
> string to int:
> > >
> > >exampleClient.cs(25) error CS0029: Cannot
> convert implicitly from
> > >`string' to `int'
> > >
> > >if i try the next:
> > >
> > >int user_id =
> Convert.ToInt32(ilUA.lookupUser(sess_id,
> "soap_user"));
> > >
> > >then it throws:
> > >
> > >Unhandled Exception:
> System.Web.Services.Protocols.SoapException:
> > >Session not valid
> > >
> > >in <0x004c5>
> >
>
>System.Web.Services.Protocols.SoapHttpClientProtocol:ReceiveResponse
> >
>
>(System.Net.WebResponse,System.Web.Services.Protocols.SoapClientMessage,System.Web.Services.Protocols.SoapExtension[])
>
> >
> > >in <0x0007d> (wrapper
> remoting-invoke-with-check)
> >
>
>System.Web.Services.Protocols.SoapHttpClientProtocol:ReceiveResponse
> >
>
>(System.Net.WebResponse,System.Web.Services.Protocols.SoapClientMessage,System.Web.Services.Protocols.SoapExtension[])
>
> >
> > >in <0x002a9>
>
System.Web.Services.Protocols.SoapHttpClientProtocol:Invoke
> > >(string,object[])
> > >in <0x0006b> (wrapper
> remoting-invoke-with-check)
> >
>
>System.Web.Services.Protocols.SoapHttpClientProtocol:Invoke
> > >(string,object[])
> > >in <0x0006b> ilUserAdministration:lookupUser
> (string,string)
> > >in <0x000bf> ConsoleIlUserAdmin:Main (string[])
> > >
> > >
> > >Does anyone know what could be happening? I had
> no problem consuming the
> > >'login' method that returns a string with the
> PHP_SESSID.
> > >
> > >regards,
> > >
> > >Arturo.
> > >
> > >
> > >--
> > >Arturo González <arturogf@ugr.es>
> > >
> > >
> > >
> > >--__--__--
> > >
> > >_______________________________________________
> > >Mono-list mailing list
> > >Mono-list@lists.ximian.com
> >
> >http://lists.ximian.com/mailman/listinfo/mono-list
> > >
> > >
> > >End of Mono-list Digest
> >
> >
>
------------------------------------------------------------------------
> > Try the new Beta version of MSN Messenger - it's
> FREE!
> > <http://g.msn.com/8HMAENUS/2728??PS=47575>
> _______________________________________________
> Mono-list maillist - Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250