Display a blob from Mysql into Coldfusion?
I am trying to store images in the longblob text type in one of my tables, and then display the picture on a Coldfusion MX 6.1 page. When I try to get it to display, I get the following error: ByteArray objects cannot be converted to strings. The error occurred in C:\Web Sites\Scooter2\Scooters\Vform.cfm: line 29 27 : /table 28 : 29 : p#ProdImage# 30 : /p 31 : /div Can anyone tell me how I can get this to work? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Just the fact that you GOT the gibberish meant that the server was running and that you were able to connect. What you saw was a Hello packet. It's one of the first stages to authenticating a MySQL client to a MySQL server. It's not meant for humans. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Steve Grosz [EMAIL PROTECTED] wrote on 10/15/2004 01:36:23 PM: I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Any other ideas? Thanks!! Steve Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote: =Neither the DOS nor Unix man pages for telnet mention a colon--Why do you =think you need one? Let me try again, how about 'telnet web-server 3306'? = Sorry for the typo. For your example, that should've been: telnet web-server2 3306 Are you sure you're connecting to the appropriate box? Should your command string be telnet db-server 3306 instead? - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Did the gibberish look something like this? Trying web-server2... Connected to web-server2. Escape character is '^]'. : 4.1.4a-gamma P--=)TK],rFDbDid:5:di Bad handshakeConnection closed by foreign host. If so, you got through to the mysql server. (See the version number?) You weren't connecting as a proper mysql client, so the last string doesn't make sense to you, and your answer didn't make sense to the mysql server, so it hung up on you. The point of the test was simply to see if you could get through to mysql on port 3306 (port is open) or not (port is blocked, probably by a firewall). It looks like you got through. Michael Steve Grosz wrote: I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Fri, 15 Oct 2004 11:36:23 -0600, Steve Grosz wrote: I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? That probably means you can reach the MySQL server and the problem is on OSI-layer 5-8 :-) Could you go into the ColdFusion Administrator and go to the Settings Summary. From there, copy the settings and post them together with the exact text of the error message. (And please, just make a literal copy and don't obfuscating IP addresses etc., they are RFC 1918 addresses so we can't reach them anyway.) Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adding DSN into Coldfusion Admin?
I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
So what, a telnet 192.168.x.x:3306 ? Eric Bergen wrote: telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
If that's the case, its not working, I type a telnet 192.168.x.x:3306 and get a could not open a connection to the host even though Mysql-nt shows as running on the Win2003 server. Steve Eric Bergen wrote: telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz [EMAIL PROTECTED] wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Adding DSN into Coldfusion Admin?
Hi Steve, You haven't got a firewall running have you? Is the MS Internet Connection firewall switched on? Sounds like some sort of firewall issue though. Generally you won't get a response from the server if it is protected. Just a thought, I'm more of a unix bod but have seen this on my own PC. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Steve Grosz [mailto:[EMAIL PROTECTED] Sent: Friday, 15 October 2004 9:29 AM To: [EMAIL PROTECTED] Subject: Re: Adding DSN into Coldfusion Admin? I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Did you tried without the : between web-server2 and 3306? i.e. put a space insted of : B On Thursday 14 October 2004 19:58, Steve Grosz wrote: I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Thu, 14 Oct 2004, Steve Grosz wrote: =I have tried telnet web-server2:3306 = =Didn't work = Neither the DOS nor Unix man pages for telnet mention a colon--Why do you think you need one? Let me try again, how about 'telnet web-server 3306'? ... ... =Dwalu Z. Khasu wrote: [snip] = = = Try 'telnet host port'. = -- - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote: =Neither the DOS nor Unix man pages for telnet mention a colon--Why do you =think you need one? Let me try again, how about 'telnet web-server 3306'? = Sorry for the typo. For your example, that should've been: telnet web-server2 3306 Are you sure you're connecting to the appropriate box? Should your command string be telnet db-server 3306 instead? - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL user passwords and ColdFusion MX6.1
Helpful Hint: I had a major problem not being able to register a DSN (Data Source Name) with the CF Administrator, using username and password from a MySQL 4.1.3 beta user table. After much hair-pulling, I discovered that CF cannot apparently handle the new 41-character format of the passwords. Killing these off, restarting with --old-passwords and redoing them as 16-char passwords allowed CF to register the DSNs. Hope this might help someone else who's going prematurely bald. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL and Coldfusion
Hi Ian, What is the problem you are hitting? I have been successfully using MX with MySQL. Matt -Original Message- From: Ian O'Rourke [mailto:[EMAIL PROTECTED] Sent: Sunday, February 08, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: MySQL and Coldfusion Is anyone on the list using Coldfusion MX with MySql? It's just I've hit a problem I've been hitting my head against for a week or so. The coldfusion people I know have hit a blank (but they are using SQL Server). I'm stretching now in an attempt to find someone with experience of both sides? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and Coldfusion
Is anyone on the list using Coldfusion MX with MySql? It's just I've hit a problem I've been hitting my head against for a week or so. The coldfusion people I know have hit a blank (but they are using SQL Server). I'm stretching now in an attempt to find someone with experience of both sides? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and Coldfusion
Ian O'Rourke wrote: Is anyone on the list using Coldfusion MX with MySql? Yes. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL and Coldfusion
Yes, what's your problem? -Original Message- From: Ian O'Rourke [mailto:[EMAIL PROTECTED] Sent: Sun 2/8/2004 12:52 PM To: [EMAIL PROTECTED] Cc: Subject: MySQL and Coldfusion Is anyone on the list using Coldfusion MX with MySql? It's just I've hit a problem I've been hitting my head against for a week or so. The coldfusion people I know have hit a blank (but they are using SQL Server). I'm stretching now in an attempt to find someone with experience of both sides? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ColdFusion and mySQL
Hi, How can I display only certain occurences from my database based on a certain critieria. In the filed strSelect I could have a long string which would contain: strSelect = D:\temp\file.txt,D:\temp\file2.txt,D:\mywork\file.txt,D:\mywork\file.txt,D:\documents\file.txt,D:\documents\file.txt So in my query I want to just display the match of D:\mywork and nothing else. Can this be done in SQL? cfquery name=ListElement datasource=user-profiles dbtype=ODBC SELECT * FROMprofiles WHERE strUsername = '#auth#' /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
COLDFUSION AND MYSQL
Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: COLDFUSION AND MYSQL
Hi marco In the administration page of coldfusion, usually something like: http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm go to your data sources and click the edit button. THen click the show advance settings button. Make sure that the Allowed sql privelages are correct (ie. select, delete, update, etc). That is, if you give your coldfusion a datasource using the user name mySource you have to make sure that your sql database has a user mySource. Make sure that the user mySource has the correct privelages. That is, if you say that the user mySource can only have select privelages then you have to make sure that the coldfusion knows about it too and thus, you can't say that the user: mySource has drop or alter privelages. Hope this helps Desmond From: marco [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: COLDFUSION AND MYSQL Date: Mon, 19 Aug 2002 10:23:19 +0200 Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: COLDFUSION AND MYSQL
First thing I would do is update your mysql. That version is very old and probably does not support a lot of stuff you are looking for. After that I would go and download the newest JDBC drivers from: http://www.mysql.com/downloads/api-jdbc.html -Nick marco said: Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
crashing problem with Coldfusion, Mysql, and MyODBC
Hi - I'm having some problems with using MySQL, MyODBC, and Coldfusion together, so I thought I'd post here and see if anyone had any ideas on how to fix the problems. I see other people have had similar issues, so hopefully someone can help me out. So, we've running on Solaris 2.7, with Mysql 3.23.49 (using InnoDB tables...), Coldfusion 5, unixODBC-2.2.2, and MyODBC (both versions 2.50.39 and 3.51.02). Coldfusion and mySQL are running on the same machine. We've gotten everything to basically work - we can do everything we need to in Coldfusion, but we're having the dreaded crashing problem. When we put our Coldfusion application under load, or basically just click a lot of links in the application at once, Coldfusion crashes and restarts. The same application running against Oracle with the oracle native driver doesn't crash - this is code we've run for a long time in a different environment, so we don't think it's a code problem. Anyway - we suspect the problem is some sort of 'thread-safe' problem. Originally we used the binary distributions of MySQL and MyODBC, and then realized the Solaris binary that's available isn't threadsafe. So we built everything from source, following these instructions: http://dbforums.com/showthread.php?threadid=174934 MySQL ColdFusion unixODBC MyODBC and Solaris - how to succeed! of course, adding in the InnoDB option to the mysql compilation. But even after going through all this, we still had the crashing problems. So - I've seen other people post about having the crashing problem - are there any obvious things I may have missed? How do I know if MyODBC and mysqld have been compiled to be thread safe? Here are some concrete questions: Is there a way to force Coldfusion and MyODBC to connect to MySQL using network sockets instead of the Unix sockets? I'd like to test that to see if the behavior is different. I tried to follow the mysql documentation about compiling a thread-safe client: http://www.mysql.com/doc/T/h/Threaded_clients.html one thing I don't understand: The documentation states compiling with thread-safe options will create a thread-safe client library libmysqlclient_r - do I need to make certain that libmyodbc links against the libmysqlclient_r.so, instead of the generic libmysqlclient.so? I've seen posts in the past on this mailing list, and other places, about people having problems using mysql + coldfusion together, so if anyone can help, or has any ideas, please respond to the list or directly to me at [EMAIL PROTECTED] Thanks for any help! Thank you- dana = Dana Quinn [EMAIL PROTECTED] Unix-type guy __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion,Mysql,Myodbc
At 13:29 26/3/2002 +0100, =?us-ascii?Q?Xavier_Prelat?= wrote: Hi, Even if you are using the CFServer 5.0 you will not be able to edit any MySQL DSN with the ColdFusion DSN web admin tool. A clarification here. Is possible ColdFusion to create DSN on the fly using a custom DLL. I did a DLL sometime ago, which you can find it on the contribution page as mydsn with the source for to build on VC++. Regards, Miguel First install the MySQL ODBC on your server, then create any DSN you need using the ODBC Sources tool (administrator tool on Win 2000). Once you created the DSN you want, the CF let you manage the DSN through the web admin interface! hopt it helps. Xavier Xavier Prelat Chief Technical Officer WEBCENTRIC 25 rue de Ponthieu 75008 PARIS - FRANCE http://www.wcentric.com -Message d'origine- De : andy thomas [mailto:[EMAIL PROTECTED]] Envoye : mardi 26 mars 2002 13:14 A : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet : Re: Coldfusion,Mysql,Myodbc On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL and you should be using these. Note that the cfodbc45.so driver shipped with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib) is broken and you can download a fixed version from Macromedia's web site. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion,Mysql,Myodbc
Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. I need it asap..kindly help.. Thanks Srini - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion,Mysql,Myodbc
On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL and you should be using these. Note that the cfodbc45.so driver shipped with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib) is broken and you can download a fixed version from Macromedia's web site. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion,Mysql,Myodbc
Even if you are using the CFServer 5.0 you will not be able to edit any MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL ODBC on your server, then create any DSN you need using the ODBC Sources tool (administrator tool on Win 2000). Once you created the DSN you want, the CF let you manage the DSN through the web admin interface! hopt it helps. Xavier Xavier Prelat Chief Technical Officer WEBCENTRIC 25 rue de Ponthieu 75008 PARIS - FRANCE http://www.wcentric.com -Message d'origine- De : andy thomas [mailto:[EMAIL PROTECTED]] Envoye : mardi 26 mars 2002 13:14 A : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet : Re: Coldfusion,Mysql,Myodbc On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL and you should be using these. Note that the cfodbc45.so driver shipped with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib) is broken and you can download a fixed version from Macromedia's web site. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion,Mysql,Myodbc
On Tue, 26 Mar 2002, Xavier Prelat wrote: Even if you are using the CFServer 5.0 you will not be able to edit any MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL ODBC on your server, then create any DSN you need using the ODBC Sources tool (administrator tool on Win 2000). Once you created the DSN you want, the CF let you manage the DSN through the web admin interface! Hmmm, that is odd. We have had no problem editing MySQL DSN's with the Merant drivers, although where you are asked for the MySQL server's hostname (and the MySQL server is on the same system as Cold Fusion), you must give the full hostname, not just localhost. If you use 'localhost' it will work initially but if you need to restart cfserver for any reason, then it will not be able to verify the DSN again, unless you have used the full Internet address of teh MySQL server. Andy -Message d'origine- De : andy thomas [mailto:[EMAIL PROTECTED]] Envoye : mardi 26 mars 2002 13:14 A : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet : Re: Coldfusion,Mysql,Myodbc On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL and you should be using these. Note that the cfodbc45.so driver shipped with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib) is broken and you can download a fixed version from Macromedia's web site. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion,Mysql,Myodbc
Hi !! Sorry for the delayed response on this. Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. What type of compilation errors ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)
Hello, list! I'm not quite sure that this is the right place to ask, but I'm having problems getting MySQL and ColdFusion Server 5 to work together. I have a ColdFusion server that connects to MySQL via ODBC. I've configured the Merant MySQL ODBC driver via the ColdFusion administrator, and it is able to connect to my MySQL database (at least it claims that the connection was successful when clicking verify in the CF admin). The datasource name is hpTest. However, trying to connect to the database in an CFM doesn't seem to work at all. My error message is ODBC Error Code = 08003 (Connection not open) [MERANT][ODBC lib] Connection not open The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:114). and the code goes like this: cfquery name=Test dbtype=ODBC dbname=hpTest datasource=hpTest SELECT * FROM hpTest /cfquery cfoutput query=hpTest#FieldName1#, #FieldName2#br/cfoutput I've been reading TFM, browsing TFW, reading TFML and I've even been to (*ghasp*) Microsofts ODBC-pages looking for an answer (and you know it's -bad- when that happens!g). Reading the manual I got the impression that coldfusion would open the connection when using a cfquery-tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)
Hi !! -Original Message- From: Markus Lervik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:22 AM To: [EMAIL PROTECTED] Subject: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie) Hello, list! I'm not quite sure that this is the right place to ask, but I'm having problems getting MySQL and ColdFusion Server 5 to work together. I have a ColdFusion server that connects to MySQL via ODBC. I've configured the Merant MySQL ODBC driver via the ColdFusion administrator, and it is able to connect to my MySQL database (at least it claims that the connection was successful when clicking verify in the CF admin). The datasource name is hpTest. However, trying to connect to the database in an CFM doesn't seem to work at all. My error message is ODBC Error Code = 08003 (Connection not open) [MERANT][ODBC lib] Connection not open The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:114). and the code goes like this: cfquery name=Test dbtype=ODBC dbname=hpTest datasource=hpTest SELECT * FROM hpTest /cfquery cfoutput query=hpTest#FieldName1#, #FieldName2#br/cfoutput I've been reading TFM, browsing TFW, reading TFML and I've even been to (*ghasp*) Microsofts ODBC-pages looking for an answer (and you know it's -bad- when that happens!g). Reading the manual I got the impression that coldfusion would open the connection when using a cfquery-tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. We don't recommend to use third-party drivers with MySQL unless if they are from our parters or directly linking with MySQL. As we never tested the above driver(s) with MySQL, we can't comment any thing. We appriciate if you can make use of the following MySQL ODBC Drivers, as they are tested and working fine with CF. - MyODBC 2.50 (stable) and - MyODBC 3.51 (developmemt). For more information about MySQL ODBC, refer to http://www.mysql.com/products/myodbc/ Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql max, coldfusion 5.0, and MyODBC
Hello, I've been using mysql 3.23.47 with Coldfusion 4.52 for several months, and I want to switch to a new server with mysql max 3.23.47 and Coldfusion 5.0. I was able to get the new versions of each running on the new server without any problem, but I can't get the Coldfusion 5.0 serverto connect to the new mysql database. I have been able to connect to the database from the remote coldfusion server (version 4.52) without any problem. We are running Redhat 7.1, mysql max 3.23.47 using InnoDB tables in the first database, Coldfusion 5.0 and have installed the current(2.50.39) version of MyODBC. I have permissions set the same way I do on the older box, as well as the same operating system and MyODBC version. Has anyone else run into any similar issues, or have any idea what could be causing the problem? Thanks, Rob Cunningham [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion?
Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion?
Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion?, Database, SQL, etc!
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Robert, Bjorn et all Thanks for your advice and support - great to know that folks are using it in this way and getting good results. I'm looking forward to getting stuck into this, and appreciate knowing there is an active community out there too. Cheers Mark P.S. By the way, this is the 5th attempt to send this message, I'm getting auto replies from the server telling me that my reply appears to be spam or off-topic. It seems the server filter is very strict as it's rejected a number of my attempts to send today! I've changed the subject as advised by the server responses. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion?
ColdFusion server on Unix/Linux platform, then yes. The ColdFusion server for Linux/Unix comes complete with the MySQL drivers necessary. I have successfully created CF-MySQL pages without any problem. When I have installed ColdFusion on Windows platforms, it has NOT come with the MySQL drivers. I'm not sure if there's a place to get MySQL drivers for ColdFusion? I haven't tried. The My-ODBC drivers might work. I don't know. Bryan Capitano MSL wrote: Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- CAPITANO WEb CONSULTING http://www.capitanoweb.com Bryan R. Capitano cell (541)760.6288 home (541)929.5060 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion?
I currently use MySQL along with CF v5 on a Win2k box. After installing MySQL, install the myODBC drivers (also available at MySQL.com), setup your DSN on your win box, then attach them in CF and you are ready to rock. While my install is still new (a few months), I could not be happier after moving from MSSQL. stephen -Original Message- From: MSL [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 09:16 To: MySQL Subject: Coldfusion? Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion? Database, MySQL
database,sql,query,table Hi Stephen Good to hear your very postive notes on Win2K/Coldfusion/MySQL. I'm just setting up, and wondering about some notes in the MySQL documentation: In the following circumstances you will need to use the MySQL configuration file: 1.The install/data directories are different than the default `c:\mysql' and `c:\mysql\data'. 2. If you want to use one of the these servers: mysqld.exe mysqld-max.exe mysqld-max-nt.exe 3. If you need to tune the server settings. There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both les are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. Using notepad.exe, create the configuration file and edit the base section and keys: [mysqld] basedir=the_install_path #e.g. c:/mysql datadir=the_data_path #e.g. c:/mysql/data or d:/mydata/data If the data directory is other than the default `c:\mysql\data', you must cut the whole `\data\mysql' directory and paste it on the your option new directory, e.g.: `d:\mydata\mysql'. If you want to use the InnoDB transactional tables, you need to manually create two new directories to hold the InnoDB data and log les, e.g. `c:\ibdata' and `c:\iblogs'. You will also need to add some extra lines to the configuration file. If you don't want to use InnoDB tables, add the skip-innodb option to the configuration file. Now you are ready to test starting the server. I have the MySQL database installed under directory drive letter 'E:\MySQL' , the 'E:\' directory being what I use for all my software, and I use my 'D:\' directory for all data. This would seem to suggest that I fall under number 1. of the above circumstances. However, I am finding the following notes (as copied above) from the documentation less than clear. Can you advise or clarify what the correct process is in this case? Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
More Coldfusion
Hi, I just read the message that Mark posted concerning ColdFusion. It would be much appreciated if Stephen S Zappardo could email me concerning his installation of mySQL on Win2k box as I have been having endless problems doing it. I am going to be doing developing in Coldfusion and wanting to use mySQL instead of MSSQL. Once again this would be much appreciated Stephan. Andrew [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion?
Mark -- We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. No amount of MySQL configuration tweaking, query optimization, Cold Fusion configuration tweaking, Cold Fusion query caching, or version upgrades of MySQL or Cold Fusion made much of a dent in the problem. I've heard from a number of other folks concerning similar experiences. Allaire pointed the finger at MySQL, which I've had no reason to believe is the problem. To back that assertion up, I can say that converting our most heavily used dynamic pages from CF to PHP has already had an *incredible* effect on the stability of the system, with no other MySQL changes. If you are thinking of running CF on Solaris, save yourself the headaches and use PHP instead. I can't speak to it's performance on Windows. My 2 cents, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] -Original message- Subject: Coldfusion? Date: Fri, 11 Jan 2002 14:16:23 - From: MSL [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion?database,sql,query,table
database,sql,query,table Hi Andy Wow! Well, that's made me take a double take! Sorry to hear of your woes, as I know having to deal with that sort of thing (especially for so long!) is no joke. Seems strange that there are such diverging reports on coldfusion today, but your experience and tales from 3rd parties has to be seriously considered. Trouble is, I'm not too familiar with PHP and like everyone else, don't know where the time can be found to learn yet another format, etc! Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion?
-Original Message- From: Andy Ingham [mailto:[EMAIL PROTECTED]] We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. Oh boy... I'll confirm that as well. I previously worked at Macmillan Computer Publishing (www.mcp.com) when I wrote The Personal Bookshelf and migrated that application from cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on Solaris. It was CF version 4. And it was really bad. In a development environment where there is limited access, and the machine load is relatively low, it's no problem. Yet, the webstats were saying we had approximately 8,000 users using the Personal Bookshelf at any one time, so it was going to be put under a heavy load once it is in production. Such happened and CF really really choked. The machine suffered under a really high *load*. Typically above 90%. The sysadmins joked that the machine was working so hard it was glowing in the corner. We optimized the code over the course of a couple of weeks scruitinizing the CF markup for more efficient ways to do things in order to get it down to a load. We got the load down to between 60-70% as I remember, which was still too high. Not only was the machine at an unusually high load, but the CF server would die periodically between every 10-45minutes. The sysadmins eventually wrote a script to check the health of the CF server instance that'd run every 3 minutes to determine whether or not it should restart CF automtically. It was a really bad situation. We talked with Allaire and they couldn't believe the problems we had with CF on Solaris. At the time, Allaire said that we had the largest *nix based CF application on the www with a Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of disk space, etc. We provided them with database schema's, data, and our code ... and let them try it out. They did. And they confirmed everything we had said...even in their environment. They said the design of the database and the coding of the pages didn't contribute to the poor performance of the CF engine. Ultimately, they said they couldn't help us because the thing in CF that was causing all of the problems (they said) was a simulated windows registry that CF requires in order to operate. They said that we were also suffering from a lot of errors where CF would loose database connections and not keep threads alive like they would in a non-*nix environment without a heavy load. They had no answers for us at all. They suggested that it be monitored constantly so that the application stays running as much as possible. When I heard about the simulated registry for *nix servers built into CF, I nearly hit the roof! I couldn't hardly believe it. That was a couple of years ago, and CF has went from 4 -- 4.5 -- 5. Under a windows environment, it's probably pretty good. Under *nix (Solaris in my experience) it really left much to be desired. I'd avoid it and stick with php on Solaris any day. Tyler Nally -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion?
Interesting story. We run Windows 200 servers, and we axed MSSQL and CF/ASP. i would (and do) run php even on a windows box. i guess the only problem it brings is no stored procedures, and people freak out if they don't have that enterprise interface. oh well. mySQL runs better even on a win32 platform (IMHO). -Original Message- From: Nally, Tyler G. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: RE: Coldfusion? -Original Message- From: Andy Ingham [mailto:[EMAIL PROTECTED]] We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. Oh boy... I'll confirm that as well. I previously worked at Macmillan Computer Publishing (www.mcp.com) when I wrote The Personal Bookshelf and migrated that application from cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on Solaris. It was CF version 4. And it was really bad. In a development environment where there is limited access, and the machine load is relatively low, it's no problem. Yet, the webstats were saying we had approximately 8,000 users using the Personal Bookshelf at any one time, so it was going to be put under a heavy load once it is in production. Such happened and CF really really choked. The machine suffered under a really high *load*. Typically above 90%. The sysadmins joked that the machine was working so hard it was glowing in the corner. We optimized the code over the course of a couple of weeks scruitinizing the CF markup for more efficient ways to do things in order to get it down to a load. We got the load down to between 60-70% as I remember, which was still too high. Not only was the machine at an unusually high load, but the CF server would die periodically between every 10-45minutes. The sysadmins eventually wrote a script to check the health of the CF server instance that'd run every 3 minutes to determine whether or not it should restart CF automtically. It was a really bad situation. We talked with Allaire and they couldn't believe the problems we had with CF on Solaris. At the time, Allaire said that we had the largest *nix based CF application on the www with a Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of disk space, etc. We provided them with database schema's, data, and our code ... and let them try it out. They did. And they confirmed everything we had said...even in their environment. They said the design of the database and the coding of the pages didn't contribute to the poor performance of the CF engine. Ultimately, they said they couldn't help us because the thing in CF that was causing all of the problems (they said) was a simulated windows registry that CF requires in order to operate. They said that we were also suffering from a lot of errors where CF would loose database connections and not keep threads alive like they would in a non-*nix environment without a heavy load. They had no answers for us at all. They suggested that it be monitored constantly so that the application stays running as much as possible. When I heard about the simulated registry for *nix servers built into CF, I nearly hit the roof! I couldn't hardly believe it. That was a couple of years ago, and CF has went from 4 -- 4.5 -- 5. Under a windows environment, it's probably pretty good. Under *nix (Solaris in my experience) it really left much to be desired. I'd avoid it and stick with php on Solaris any day. Tyler Nally -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
Using ColdFusion with MySQL
Has anyone setup MySQL 3.23.44 with ColdFusion 5.0 Enterprise Edition. I have heard that there may be problems with transactions. I was wondering if anyone knew how to do this, and if they could point me to some reading material. I was also wondering if MySQL 4.0 would include transactions and stored procedures, and if so, when it would most likely be stable. Note I have not used 4.0, and was wondering if it would be advisable to use if I would be populating it with a lot of data, and running intense queries with respect to stability? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql+myodbc+coldfusion
Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine. However i keep getting a [TCX][Myodbc]Transactions are not enabled error. In the setup for the system dsn I have NOT disabled transactions. So whats up? any help would be really appreciated. I really don't want to be forced into using some other product because of this. Thanks David Berndt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql+myodbc+coldfusion
Hi, -Original Message- From: berndt [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 8:49 PM To: [EMAIL PROTECTED] Subject: mysql+myodbc+coldfusion Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine. However i keep getting a [TCX][Myodbc]Transactions are not enabled error. In the setup for the system dsn I have NOT disabled transactions. So whats up? any help would be really appreciated. I really don't want to be forced into using some other product because of this. This error comes when you are trying to perform some transactional calls in MyODBC on a non-transactional MySQL server. You can avoid this by either: 1. Enabling InnoDb/BDB table support in MySQL server or 2. By Disabling the transactions in MyODBC by checking ' Disable transaction' option from DSN dialog. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Thanks David Berndt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help needed with MySql/MyODBC ColdFusion on Win2k
Hi! I am desperately trying to get the following combination to run: MySQL (Win32 3.23.44) on host_1.something.tld ColdFusion Enterprise 4.5.1 SP2 for Windows on host_2.something.tld MyODBC 2.50.39 for NT/2000/XP on host_2.something.tld The MySQL-DB ist hosting one database named TEST with one table 'produkte' (for now). I granted a new user 'administrator' with password 'something' all privileges on the database. Then I installed myodbc on the ColdFusion machine and set up a system DSN named MYSQL, server host_1.something.tld, DB TEST, user 'administrator', pwd 'something'. Whenever I restart the ColdFusion service, I can actually verify the MYSQL ODBC-source successfully and run queries on the tables therein. After some time (just a few minutes usually), verification fails completely however, and the very same query, which did return results before, now just returns an error message. Here's the error message of the query: Error Diagnostic Information ODBC Error Code = () Unknown connection error for the data source, 'MYSQL.' SQL = SELECT ProduktID, Name, Beschreibung, LetztesUpdate, Bemerkungen FROM produkte Data Source = MYSQL ColdFusion Admin returns on verification-attempt: The connection to the data source failed. Check the following to resolve this problem: Are the data source settings configured properly? Did you provide valid security information in the data source settings ? For some databases the ColdFusion Server may need to be logged in under a special NT account rather than the default System Account. Use the Windows NT Services Control Panel to change the account the ColdFusion Server service is using. When I run some other ODBC-access-client like StarOffice 5.2 on host_2.something.tld, I can get access to the MYSQL datasource, although something seems to be a bit messed up there, too, as the 'TDX mysql Driver default configuration' (the configuration dialogue of myodbc) keeps popping up on the first two or three connection-attempts and I have to re-enter the 'something' password, before getting a successful connection. This password is however still entered correctly in the main-configuration of myodbc... From my point of view it looks like some kind of time-out problem, as it's working fine for the first few minutes after the first access to the database from a freshly started ColdFusion service but fails some time after that. Has anybody got this combination to run smoothly (sorry, only interested in Win32-environments!)? How did you manage to get it to run and which versions of MySQL and myodbc do you use? Did you change anything in ColdFusion like timeout-Settings or whether to maintain db-connections or not? One more thing I noticed: The MYSQL-driver doesn't appear in the dropdown-list for ODBC-drivers under the ODBC Data Sources Available to ColdFusion-section of ColdFusion Administrator. However, the datasource MYSQL with the 'MySQL'-driver is still listed there, it's only verification which fails. Please help - I'm now experimenting with this mess for more than two days already and can't exactly pin down the source of all evil ;) Greetings, Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ColdFusion, talking to a mySQL database, on Solaris 7
Hey all, I'm fighting to get ColdFusion 4.5.1 SP2 to talk to a mySQL DB on Solaris 7 using unixODBC/myODBC. anyone here tried this? I've gotten to the point where I can see the myODBC mySQL Driver in the CFIDE/adminstrator ODBC screen. I've added various entries to the CFHOME/odbc/odbc.ini, CFHOME/bin/start, and copied all the library files associated with unixODBC/myODBC to the proper places (as far as I know at least). However, I can't get the DB to verify. I think I might have flubbed the username / password portion of mySQL, but I'm not posisitive. All the entries are passing the same user/pass now, but still, can't access the DB through CF. Suggestions anyone? -ALEX Web Designer, LibertyLiveWire 323-603-2118 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need MySQL/ASP/Coldfusion developer
We have a project that will require some MySQL/Cold Fusion/ASP development. We are looking for an offsite developer. There is already some development that has been done. The developer will have to do an analysis of the work that has already been done and finally complete the remaining tasks. The developer will need to have MySQL/Cold fusion/ASP configured on their personal development machine and/or have Terminal Services Client on Windows NT or 2000 so that they can login to the client's server. We can provide details of the project by request. Please respond with: -Your rates -Examples of your work -Your availability - References Thank you, Maroa Gikuuri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Coldfusion/MySQL developer
We have an upcoming project that will require some Coldfusion/MySQL development. We are looking for an offsite developer. Initially we may need the developer to configure the server for Coldfusion (there is already some development that has been done). Then the developer will have to do an analysis of the Coldfusion/MySQL work that has already been done and finally complete the remaining tasks. We can provide details as we move closer to solidifying the project with the client. Please respond with: -Your rates -Examples of your work -Your availability Thank you, Maroa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion/MySQL - Connection Failed
Hi! Let me try to restate my question and provide more information. Running: Linux 2.2.16-3, Coldfusion 4.5, MySQL 3.23.33 Problem: "The connection to the data source failed. Check the following to resolve this problem: ..." Now, I get this error on one database called xprojects while I can get the datasource to verify on the test database that came with mysql. i connect to the test with no user and no password. I tried to set up the permissions on the xprojects database like the test database.. but it still didnt work. I am assuming based upon what I have read about MySQL and Coldfusion that this is a permissions issue. For those that have this working what should the permissions be like and could this be anything else? Thanks, -Tanya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion/MySQL
Nevermind about my previous posts I got it to work! -Tanya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php