these are all true. i have been using mysql for quite some time. Transactions are
not allowed by MySQL so any driver will fail. Also, if you have embedded SELECTS or
stored
procedures they are not supported yet...but soon I am told. Also, any mysql user will
want to research ISAMCHK (MYISAMCHK on later versions), a VERY USEFUL utility to
rebuild corrupted
tables and records.
Has anyone experienced problems with these msgs:
After executing ./cfserver from the command line and leaving it up for a
long while in my telnet window, it output this:
[root@coldfusion bin]# ./cfserver
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
[MERANT][ODBC 20101 driver]6060
6066:
And in the log file /usr/local/coldfusion/coldfusion/log/serve.log I
found lots of this:
Error: performing semget() on ColdFusion Registry semaphore:Permission
denied
Error: performing semget() on ColdFusion Registry semaphore:Permission
denied
?
thanks.
Jon Cline
Enthusiast, Inc.
www.enthusiastonline.com
[EMAIL PROTECTED]
Dustin Breese wrote:
> Gilson,
>
> I just completed a conversion from NT/MSSQL to Linux/MySql. Couple of
> things to note:
>
> 1. As Steve said, filenames are now case sensitive.
> 2. CustomTags are searched-for in the same manner as under Windows -- under
> Linux, it MUST be in the CUSTOMTAGS directory.
> 3. The MySQL ODBC Driver (by Merant) that ships with CF does NOT SUPPORT
> TRANSACTIONS. Therefore, using CFTRANSACTION will cause an exception.
> 4. In MySQL, table names are case sensitive, but everything else is not.
> 5. I used @@IDENTIY values in MSSQL, so had to convert those to AUTO
> INCREMENT values in MySQL.
> 6. CFINSERT and CFUPDATE do not appear to work with MySQL.
>
> I think those are about the biggest GOTCHAS I have found so far. Now, I'm
> off to stress testing!
>
> -Dustin
>
> >
> > Date: Fri, 29 Dec 2000 00:22:29 -0200
> > From: Gilson Soares <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Subject: Re: Porting from Win2K to Linux
> > Message-ID: <[EMAIL PROTECTED]>
> >
> > Thanks Steve.
> > I will start the port next week. I will try to record all issues and tell
> > you the results.
> >
> > Happy New Millenium.
> >
> > At 28/12/2000 11:47 -0500, you wrote:
> > >Be careful of your case sensitivity with filenames dealing with
> > >cfinclude/cfmodule, custom tags, Application.cfm and OnRequestEnd.cfm.
> > >Also at the web server level with image case sensitivity. If you're
> > >using Apache, you can try the mod_speling to solve the problem with the
> > >images. The .cfm's you have to do check by hand.
> > >
> > >I'm not sure about the DB2 port, but I imagine that should move over
> > >just fine.
> > >
> > >Steve Nelson
> > >http://www.SecretAgents.com
> > >Tools for Fusebox Developers
> > >(804) 825-6093
> > >
> > >
> > >Gilson Soares wrote:
> > > >
> > > > Hi everybody,
> > > >
> > > > I have a ColdFusion application (around 260 CFM in Fusebox)
> > running ok with
> > > > DB2 on win2k (I personally prefer Linux).
> > > > It's time to deploy it. I just received a server box to try running it
> > > > under Linux, ie CF-Linux and DB2-Linux.
> > > >
> > > > Has anyone made this migration before (even not using DB2) ?
> > > > Has any cautions that I am be aware off?
> > > >
> > > > PS: All Custom Tags I use are strictly CFM. No objects, OCX, C++, etc.
> > > >
> > > > Thanks
> > > > Gilson Soares
> > > >
> > > >
> > >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
