[Mono-list] Re: MySQL Connection from .NET Website (David P. Donahue)
David P. Donahue
ddonahue@ccs.neu.edu
Wed, 02 Feb 2005 21:03:21 -0500
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>