ColdFusion MX on Mac OS X, Part 4

17. The Select schema window shows two items: PBPUBLIC and POINTBASE. The PointBase item will display system components available in the entire PointBase system. The PBPUBLIC item will display everything that is available to the PBPUBLIC user for this database. (Many database systems allow different users to have different access privileges to the same database.) Select the PBPUBLIC item to display the components defined to the creator of the currently-connected (CFSnippets) database. Click OK. The Schema PBPUBLIC window pops up.

18. In the Schema PBPUBLIC window, click the Employees Table in the left pane; the right pane changes to display the definitions for the Employees Table.

19. Move the Schema PBPUBLIC window to the side so we can view both it and the Main ViennaSQL window.

20. In the main ViennaSQL window, enter the following SQL Query into the bottom pane. Then click the Execute (right arrow) icon (top, fifth from the left).

We have only scratched the surface of the powerful, general-purpose ViennaSQL GUI SQL client. We can develop and test our SQL queries, interactively, against test or live data. Once the queries are validated, we can literally copy/paste them to our CFMX programs. The Query we just executed was our (soon-to-be famous) Phone List.

There is much more you can do with ViennaSQL: create databases, create or alter tables, create views, etc. (depending on the capability of the specific database system). A more comprehensive treatment of ViennaSQL is beyond the scope of this article, but I suggest you review the documentation and spend some time experimenting with the program. It is time well invested and will be paid back many times over.

It needs to be said that using a powerful, interactive tool like ViennaSQL requires a certain discipline. It is possible, with a few keystrokes, to irretrievably delete (or modify) all of the records in a table, or even drop entire databases. Proceed responsibly!

I should also note that CFMX, ViennaSQL, and other programs can access the databases concurrently -- though some database systems may not support advanced RDBMS features such as transaction isolation, locking, rollback, and deadlock detection/avoidance. CFMX contains features that help prevent problems that can occur with concurrent database access and modification; other languages may not offer similar protection. My advice? You should limit your concurrent database access and modifications to the lowest-common-denominator of what is supported by the underlying database system and the individual programs and programming languages used to access it.

We will not cover the setup of ViennaSQL connections for each individual database system that we interface from this point on. But the procedure is the same for each database -- only the connection details are different. The connection details can be copy/pasted between the CFMX Administrator and ViennaSQL Connection configurator. If you plan to use the database at all, take a few moments and set up a ViennaSQL connection.

Where Do We Go from Here?

There are quite a few other databases that can be interfaced to our CFMX Mac OS X developer system, and many other related topics that we can explore. Here's your chance to contribute! Below is a list of topics that are on the "To Do" list. We want you, the readers, to prioritize them for us. If you don't see the topic you want, feel free to add to the list.

Dick Applebaum has been doing Web development since 1997, primarily with ColdFusion -- including his latest challenge to port ColdFusion MX to Mac OS X.

Post your comments and questions for Dick here.
You must be logged in to the O'Reilly Network to post a talkback.

Showing messages 1 through 46 of 46.

Dreamweaver integration with Coldfusion with Tomcat
2004-09-29 02:19:26 jane_ [Reply | View]

I have an almost working setup of
Dreamweaver MX
Coldfusion MX (coldfusion_61_other.jar)
Apache (installed)
Tomcat (5.0.28 from http://jakarta.apache.org/site/binindex.cgi)
mySQL - CompleteMySQL-4.0.15.dmg from http://www.serverlogistics.com/mysql.php
and Drivers/ConnectorJ.pkg (3.0.6)

I followed the instructions here -

http://www.macromedia.com/support/coldfusion/j2ee/cfmxj2ee_mac_onjrunandtom.html

I did comment out the tools.jar file, despire being unsure what version of JRE I have.

I've connected Dreamweaver up with a site defined like so:
Local root folder: Macintosh HD:Users:jane:SitesLocal:1000Monkeys:
Remote info: Access: local/Network
remote folder: Macintosh HD:usr:local:jakarta-tomcat-5.0.28:webapps:cfusion:1000Monkeys:
Testing server: Model: Coldfusion
Access: local/Network
remote folder: Macintosh HD:usr:local:jakarta-tomcat-5.0.28:webapps:cfusion:1000Monkeys:
URL prefix: http://127.0.0.1:8080/cfusion/1000Monkeys/

It's al *almost* working. I can embed CF tags in my Dreamweaver .cfm files, press F12 and hey presto, the data from my mySQL database is populating my forms.

But when I try to use the Application bar to embed coldfusion dynamic objects, I get an panel popping up with 5 tasks I need to do first, the first three ticked and the last two not. It's saying that I have to set up an RDS login and configure a data source.

When I click on RDS login, it says that the URL for the testing server is not correct or ColdFusion is not running - which I know to be untrue, as my directly edited pages work.

I've hunted around, and this is a very common problem. None of the solutions that anyone has found applies to me.

I do have the RDS servlet enabled in my web.xml file, like so.

<servlet-mapping id="macromedia_mapping_5">
<servlet-name>RDSServlet</servlet-name>
<url-pattern>/CFIDE/main/ide.cfm</url-pattern>

BUT - I don't think RDS is installed on my machine, because the ide.cfm file mentioned above is not there.

BUT - I don't understand why I need it, since my site is set up to be local.

I cannot access any RDS configuration from the coldfusion admin directly. I think this is again because RDS is not installed. To set or clear an RDS password, I have to type in a URL like so

http://localhost:8080/cfusion/CFIDE/administrator/security/cfrdspassword.cfm

BUT - I don't think this is achieving anything as RDS is not there.

I suspect that Dreamweaver needs RDS to use the Application toolbar, even though my site is local/network. Is this true?

Also, I don't know why I don't have RDS - I copied over the rds.jar file and renamed it to CFIDE.jar so that Tomcat could install it, just as the instructions say.

Finally, I read this

http://www.macromedia.com/support/coldfusion/releasenotes/mx/knownissues_mx_j2ee_p2.html which says

The Macromedia Dreamweaver MX ColdFusion Component Browser will not function if you install ColdFusion MX for J2EE on your application server with a context root other than "/". The component browser only works if ColdFusion MX for J2EE is deployed at "/".

I'm not clear what my context root is, but I followed Macromedia's instructions.

Please can anyone help?

Building Apache Connector for JRun4 and CFMX
2004-09-20 12:43:59 rodthomas [Reply | View]

Hi, I found the articles really useful, and I've since looked around on the Macromedia site and installed the latest versions, with latest updates (JRun 4 Updater 4).

Everything seems fine on the JRun server (apart from not being able to change the contextroot to '/' successfully - CFMX Admin then doesn't work).

So...I'm trying to make things easier by using http://localhost/ via an Apache connector as suggested. This doesn't work - .cfm files not understood, where before a code source view was displayed by Safari.

The Apache error log contains the following line '... mod_jrun.so uses plain Apache 1.3 API, this module might crash under EAPI! (please recompile it with -DEAPI).' Following Macromedia's own advice, this apparently requires manual creation of the connector to replace the one made using JRun GUI tools.

After installing GCC, stopping Apache, extracting the ApacheModule.zip from wsconfig.jar and renaming existing mod_jrun.so file, I ran the /usr/sbin/apxs command for Apache 1.3.x as instructed but still have errors as follows (summarised):

In file included from jrun_ssl.h:25, from mod_jrun.c:16: /usr/include/netinet/in.h:255: error: parse error(s) ... /usr/include/netinet/in.h:329: error: field XXX has incomplete type In file included from /usr/include/netinet/in.h:518, from jrun_ssl.h:25, from mod_jrun.c:16: /usr/include/netinet6/in6.h:123: error: parse error(s) ... /usr/include/netinet6/in6.h:384: error: field XXX has incomplete type ... /usr/include/netinet6/in6.h:617: error: parse error before "__P" In file included from /usr/include/machine/ansi.h:33, from /usr/include/stdlib.h:61, from /usr/include/openssl/crypto.h:62, from /usr/include/openssl/comp.h:5, from /usr/include/openssl/ssl.h:171, from jrun_ssl.h:28, from mod_jrun.c:16: /usr/include/ppc/ansi.h:93: error: syntax error before "typedef" In file included from mod_jrun.h:34, from mod_jrun.c:20: /usr/include/httpd/httpd.h:907: error: field XXX has incomplete type In file included from mod_jrun.c:21: jrun_proxy.h:138: error: field `addr' has incomplete type /usr/include/netinet/in.h:315: error: storage size of `sin_addr' isn't known /usr/include/netinet6/in6.h:149: error: storage size of `sin6_addr' isn't known apxs:Break: Command failed with rc=1

Any ideas/suggestions gratefully received! I'd rather not have to install Apache 2.0 as there are additional complexities there, apparently!

Thx

Forget this: go direct to Macromedia
2004-05-05 08:33:06 Chriscypher [Reply | View]

Installing and Deploying ColdFusion MX 6.1 on Macintosh OS X

The Macintosh OS X operating system is built on top of BSD UNIX, which enables Macintosh users to run software that supports the UNIX platform. Such software includes the Apache web server (included with Macintosh OS X), JRun 4, Tomcat, and ColdFusion MX.

This document describes how to install, deploy, and configure ColdFusion MX as a J2EE application, running on JRun 4 and Tomcat.

http://www.macromedia.com/support/coldfusion/j2ee/cfmxj2ee_mac_onjrunandtom.html

pointbase development
2003-05-29 16:13:28 lanegood [Reply | View]

if i develop an application using pointbase server on my localhost, do i need pointbase installed on the web server or is the database embedded in my web pages?

Starting the CF Server on Start-up
2003-05-21 05:55:03 anonymous2 [Reply | View]

Isn't there a way to start the CF Server on start-up? I know that there was a way with the old set-up option, but with the J2EE set-up, I was wondering if the old way still worked.

RD

Mail server doesn't work..
2003-03-27 10:16:50 anonymous2 [Reply | View]

Hello,
Great article, once again. I used the coldfusion ported version from linux before, now I moved to this new version, everything works well except the mail server, I've entered the same settings than before in the CFM administration mail server, double cheched it and it doesn't do anything... What could be the issue?

Thanks,
FreeminD

Problem with Java 1.4.1 - The Solution?
2003-03-24 16:33:05 anonymous2 [Reply | View]

Jbuilder 7 has the same problem. It don�t work with Java 1.4.1. But i have found a solution to fix.
Perhaps it�s the solution for Jrun 4?

Her it is:

from the MacFixIt site:

Fix for JBuilder 7 We previously reported that since Java 1.4.1 has been installed, JBuilder 7 stops working. Apple has now posted a developer note offering a solution:

In your JBuilder7 folder, navigate to JBuilder.framework/bin/
Open the jdk.config file in a text editor. You may need to do this from the shell with the sudo command depending on how the permissions to JBuilder7 are set. For example, type sudo vi jdk.config
Add the following line:
javapath /System/Library/Frameworks/JavaVM.framework/Versions/1.4.1/Libraries/libjvm_compat.dylib.
Save the file and launch JBuilder7 by double clicking the icon.

I hope it helps you to find the solution.

***WARNING: Issues with Java 1.4.1
2003-03-14 07:39:58 dicklacara [Reply | View]

A few days ago, Apple released Java 1.4.1 (available by download or Software Update).

There are several issues when running CFMXJ2EE for Mac OS X under Java 1.4.1.

Until these are resolved, I suggest that you do not install Java 1.4.1.

I will post another message as soon as I have more information.

Dick

***WARNING: Issues with Java 1.4.1
2003-07-24 16:14:04 anonymous2 [Reply | View]

JDK 1.3.1 should still live on your Mac. Change the java_home variable for Tomcat to /System/Library/Frameworks/JavaVM.framework/Versions/1.3.1/Home

***WARNING: Issues with Java 1.4.1 - QUICK FIX
2003-03-27 11:21:06 anonymous2 [Reply | View]

It is easy to switch back to 1.3.1 after you have installed 1.4.1

Simple go to /System/Library/Frameworks/JavaVM.framework/Versions/

In this directory there is a sym link called 'CurrentJDK' that point to the 1.4.1 directory. change this sym link to point to the 1.3.1 directory.

you will have to be logged in as root or use sudo in order to do this.

This doesn't allow JRun to work with 1.4.1 but is a fix for people who have installed 1.4.1 and don't know how to switch back to 1.3.1 as their default Java VM.

Nick

***WARNING: Issues with Java 1.4.1
2003-03-20 02:38:50 lolajl [Reply | View]

Have you gotten more information about this issue yet?

server problem?
2003-03-08 19:51:43 anonymous2 [Reply | View]

Hi Dick,

I am trying to run coldfusion MX on J2EE server.
But I am having problem with it.

I downloaded Jrun first and installed, then downloaded coldfusion mx on j2ee developer version and installed too.

I open the jun launcher by typing /Applications/Jrun4/bin/jrun in the Terminal.

I started the Amin and Default servers.
And I typed 127.0.0.1:8000 but I only got this error

"500 There is no web application configured to service your request
There is no web application configured to service your request"

I will be really appreciated for your help.

Thanks in advances

server problem?
2003-03-09 05:40:34 dicklacara [Reply | View]
OK, a couple of things:

You are using the JRun Launcher to start things:

---Launch the Launcher (Terminal)
------Start Admin server (Launcher)
---------- JMC (Browser)
------Start Default Server (Launcher)

I prefer to skip the launcher and start the admin server directly from the CLI (Terminal) with:

---Start Admin and Default Servers in Background (Terminal)
------JMC (Browser)

From a Terminal window, enter:
```
   /Applications/JRun4/bin/jrun -start admin &
```
Then you get output similar to the following:
```
   [TiBook:~] cfmx% /Applications/JRun4/bin/jrun -start admin default &

   [1] 1858

   [TiBook:~] cfmx% Starting Macromedia JRun 4 (Build 54102), admin server

   *

   *

   *

   Server admin ready (startup time: 7 seconds)

   

   Starting Macromedia JRun 4 (Build 54102), default server

   *

   *

   *

   Server default ready (startup time: 9 seconds)  
```
Once the Admin server has started up, the JMC is available through a browser by entering:
```
   127.0.0.1:8000
```
into a browser.

If you display the Terminal window in the background, you can see the effect of any JMC activities.

This way of starting Jrun & servers eliminates some steps, and approximates what you would put in a startup script.

HTH

Dick

server problem?
2003-03-10 17:17:19 jchoe [Reply | View]

Hi Dick,

Thank you for your help.

However, I am still having same error again.

Do you think I should reinstall again?

Is there another method to do or test if there is any problem with my files?

Thank you again

server problem?
2003-03-10 17:58:18 dicklacara [Reply | View]

I guess I would start over.

Delete the /Applications/JRun folder

Re Download JRun and CFMXJ2EE - JRun for Mac OS X.

and do a complete reinstall.

Last weekend, I got access to an Xserve & did exactly this -- without any problems.

Dick

Re: Safari
2003-03-01 20:19:05 anonymous2 [Reply | View]

I have the same problem w/ Safari.

New Safari Broke My Setup...
2003-02-12 14:14:59 brianimator [Reply | View]

This is the error I get when trying to connect to my CFMX/JRun4 hosted site:

Could not open the page ?http://localhost:8101/cfusion/seattle-widgets/home/home_random/home1.html? because the network connection was reset. This sometimes occurs when the server is busy.

The same error message appeared when trying to connect to the Admin pages for both CFMX and JRun, though eventually, I was able to get in.

Looks like I'll be developing on Chimera in the meantime - unless someone has a fix???!!

Can't connect ViennaSQL
2003-02-06 09:06:28 dicklacara [Reply | View]

Give me more information:

1) Did you copy the pbserver42RE.jar to:

/Library/Java/Extensions

2) Is CFMX running?

3) Can you Test and Validate the cfsnippets connection from the CF Administrator?

4) What are the contents of all the fields defined in the CFMX cfsnippets datasource?

5) What are the contents of all the fields defined in the ViennaSQL connection?

Dick

Can't connect ViennaSQL
2003-02-06 08:00:50 anonymous2 [Reply | View]

What should we do if the connection test fails when trying to connect to the CFSnippets DB? On the 2nd test, I get a "cannot connect to database using the specified user name and password. Please check the URL, user name and password are correct."

Can't connect ViennaSQL
2003-02-07 11:47:44 brianimator [Reply | View]

I had the same problem... after copying and pasting the info from cfsnippets in the CFMX admin, (not the article) my problems were solved.

For other problems, watch the spaces at the ends of your pasted entries (I've had the best luck copying directly from CFMX admin)

Can't Create Database
2003-02-05 14:46:10 dicklacara [Reply | View]

Sorry, but I have no experience with the MySQL install procedure you mention -- I will cover the proceedure I used in an article in the near future.

Dick

SQL4X Manager J and MySQL jdbc driver
2003-02-04 07:04:57 lolajl [Reply | View]

I followed instructions from the JDBC 3.04 package included in the install, and I placed jdbc2_0-stdext.jar and jta-spec1_0_1.jar in the relevant library directory. When I go to the New Connection Assistant, I select MySQL as Database Server and "I don't know" for driver installer (this tells the program to check if the driver is installed or not). Clicking on "Detect" gives me this message "java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver".

What do I need to do get this working properly? I've got the drivers for Microsoft SQL server and pointbase installed successfully.

SQL4X Manager J and MySQL jdbc driver
2003-02-05 14:41:08 dicklacara [Reply | View]

Sorry, but I have very little experience with SQL4X.

If you want a JDBC driver to be available to all Java applications, [one of ] the standard place[s] to put it is in

/Library/java/Extensions

as I did when installing ViennaSQL.

Also, from the error message, it appears SQL4X is looking for the MySQL JDBC Driver that Macromedia ships with CFMX -- is this what you want?

Dick

Can't Create Database
2003-02-04 07:03:01 lolajl [Reply | View]

I installed Complete MySQL (from aaronfaby.com) on my PB. When I issue the command "create database JobApps;", I get the message "ERRPR 1044: access denied for user: '@localhost' to database 'JobApps'".

So, how do I give permission to user @localhost to set up database?

Can't Create Database
2003-04-10 08:03:27 anonymous2 [Reply | View]

Just installed today and I receive the same error. Did you ever find out what was wrong?

Can't Create Database
2003-02-05 14:46:19 dicklacara [Reply | View]

Sorry, but I have no experience with the MySQL procedure you mention -- I will cover the proceedure I used in an article in the near future.

Dick

One last Q (I hope:))
2003-01-31 15:24:40 brianimator [Reply | View]

First,

Thank you Dick for your help. I've followed your directions to a tee. After having done so, I find myself in the same bind I was in yesterday...

How do I get around the problem of having to change all of my site relative links in my site from:

/site_name/departments/employees
to:
/cfusion/site_name/departments/employees
?????

Thanks in advance!

One last Q (I hope:))
2003-01-31 16:54:14 dicklacara [Reply | View]

Are you talking about HTML (a href) links?

Are you talking about URLs used in CF tags?

Give me some examples?

Dick

One last Q (I hope:))
2003-01-31 19:48:54 brianimator [Reply | View]

this is a portion of my site's structure, and where it currently sits:

-Jrun4
-- servers
---- admin
---- default
---- lib
---- samples
---- seawidgets - (the server I created)
-------- CFIDE
-------- cfusion
---------------- seattle_widgets
------------------------ _common_elements
------------------------ departments
------------------------ education
----------------------------- index.html
----------------------------- tech_tips
----------------------------- healthline
----------------------------- patient_bios
------------------------ home
----------------------------- home_random
----------------------------------- home1.html
----------------------------------- home2.html
----------------------------------- home3.html
------------------------ index.cfm - (a re-direct that points to home/home_random/home1.html)
------------------------ news
------------------------ products
------------------------------ widgets_1
------------------------------------ index.cfm
------------------------------------ detail.cfm
------------------------------ widgets_2
------------------------------ widgets_3
------------------------ tech_notes
-------- default-ear
-------- SERVER-INF

So in all of the above directories, I have either an index.html or index.cfm file.

Since I'm using essentially the same Flash navigation bar on all pages, (the only difference is their original state which highlights the current page) I've designed it so that links from it point back to the root, then down into the appropriate folder/subfolder.

This way, the link from the Flash navigation to

/departments

will get you to "departments" from either

seattle_widgets/education/index.html

or

seattle_widgets/education/techt_tips/index.cfm

Now, in order to get things to work, I'm having to go through and change all my links pointing to the root, so that now a link that read like this:

/departments

has to read like this:

/cfusion/seattle_widgets/departments

Other oddities:

I'm also forced now to include "index.html" in my hrefs,
so now a link like this:

/cfusion/seattle_widgets/departments

has to change to change to this:

/cfusion/seattle_widgets/departments/index.html

Like I said, aarrgghhh!!

Aargghhh!!! Deadlines Approach!!
2003-01-31 01:10:07 anonymous2 [Reply | View]

This was a long winded message, but I hacked it to the essentials:

A.) Where is the equivalent of the "wwwroot" directory?

B.) How do I set up my site (i.e. where do I put it???) Links throughout my site point to "/" as the site root - they're all broken now.

C.) I've noticed that if I put in the path myself, the .cfm pages which have yet to be coded (at this point they're stand in pages with no cfml - just html), show up as a huge string of gobble-dee-gook.

Thanks for your mentorship Dick!!

Aargghhh!!! Deadlines Approach!!
2003-01-31 09:12:30 brianimator [Reply | View]

(had to register, so I'm no longer anonymous)

What I mean -
The address bar clued me into where Jrun looks to get to the CF Admin - I put my web directory in the same place.

My home page worked, but none of the links did, as they are site, not document specific. In order to get to a page, I had to manually type in the address bar to get where I wanted to. .Cfm pages with actual dynamic content ran fine, while place holder .cfm pages (just html with a few static images) gave me a string of text accross the screen (not the usual ColdFusion debug screen)

This will all be a bad memory hopefully. I'll use your suggestion in your reply, and if that doesn't work, I'll point JRun to Apache. (I'd use the ~/Sites directory - would that work?)

Thanks a Ton!!!

Aargghhh!!! Deadlines Approach!!
2003-01-31 10:23:19 dicklacara [Reply | View]

OK, Since you didn't give me a path, I will assume the following:

Applications

--JRun4

----servers

------admin

------default 

--------CFIDE.............(for RDS deployment)

--------cfusion...........(equivalent of wwwroot)

----------cfdocs

----------CFIDE...........(holds the Administrator)

----------index.cfm.......(RDS Redirector)

----------index.htm.......(RDS Redirector)

----------index.html......(RDS Redirector)

----------META_INF

----------WEB-INF

----------YourCFMXapps1...(Your App 1)

----------YourCFMXapps2...(Your App 2)

----------YourCFMXapps3...(Your App 3)

--------default-ear

--------SERVER-INF

------lib

------samples

------template.zip

Put your CF apps in YourCFMXAppsn. Do not put anything under either CFIDE directory (you will be running under that directory's Application.cfm)

Do not try to point JRun to Apache at this time -- that will further complicate the issue.

I would experiment with the GetBaseTemplatePath() function to validate that templates are stored where you think they should be.

Dick.

Aargghhh!!! Deadlines Approach!!
2003-01-31 04:29:31 dicklacara [Reply | View]
A. Where is the equivalent of the "wwwroot" directory?

The equivalent of wwwroot is:

JRun_Root/servers/JRun_Server_Instance/CFMX_Context_Root/

and the URL is:

http://127.0.0.1:port/CFMX_Context_Root/

On my system I used the following:
```
  JRun_Root............./Applications/JRun4/ (default)

  CFMX_Context_Root.....cfusion (default)
```
I created a JRun_Server_Instance named cfmx1, and used the default CFMX-Context_Root so the path is:
```
   /Applications/JRun4/servers/cfmx1/cfusion/
```
and the URL is
```
   http;//127.0.0.1:8101/cfusion/
```
If you used the default server instance, the path would be:
```
   /Applications/JRun4/servers/default/cfusion/
```
and the URL would be:
```
   http;//127.0.0.1:8100/cfusion/
```
This may seem to be a lot of work, but it gives us flexibility -- we can setup multiple JRun_Server_Instances and/or multiple CFMX_Contexts. We will use this flexibility in later articles.

B. How do I set up my site (i.e. where do I put it???)

The outermost level where you can execute CF Templates is the CFMX-Context_Root.

If you have RDS installed, there will be three extra files installed at this level:
```
  index.cfm

  index.htm

  index.html
```
These comprise the RDS Redirector -- they will redirect the URL to the Administrator -- CFIDE/administrator/index.cfm

To avoid any conflict, you should not store any of your application files in the CFMX-Context_Root, itself -- rather they should be deployed in a directory under the CFMX-Context_Root.

For example, with an application directory named mycfmxapps the path would be:

JRun_Root/servers/JRun_Server_Instance/CFMX_Context_Root/mycfmxapps/

and the URL would be:

http://127.0.0.1:port/CFMX_Context_Root/mycfmxapps/

C. I don't understand the question -- examples please!

thanks for the help
2003-01-28 07:01:23 pablo2001 [Reply | View]

Hi Dick,

I've been struggling through the previous articles and jumping through the hoops to port ColdFusion to my Mac. This newest article is a great relief.

I purchased UltraDev about 3 years ago only to discover that its powers were largely unsupported on the Mac. Since then I've been angry at Macromedia for ripping me off by marketing ahead of the real world. It cost me hundreds of dollars and countless hours of hair pulling only to finally uncover the fact that nothing would work unless I was using a Windows machine (virtually unthinkable for a creative director). Macromedia eventually came around with its MX packages for OSX and the recent introduction of JRun4 and ColdFusionMX for the Mac.

Your efforts to remedy the problem are greatly appreciated. I believe your articles to port into OSX's Darwin core helped Macromedia feel the heat from the rest of us.

Bill McEntee
tbi-1design.com

Vienna & MySQL
2003-01-22 21:44:08 jodeo [Reply | View]

Hello Dick, et. al.,

I have CFMXJ2EE running on Tomcat. I've also successfully installed MySQL using the latest package install (<http://www.entropy.ch/software/macosx/mysql/>).

I believe that what I have to do next is:

1. Install the JDBC connect (from http://www.mysql.com/downloads/api-jdbc-stable.html).
- INSTRUCTIONS are not very clear; do I merely copy the .jar file over into {JAVA_HOME}/ext/lib ?

2. Improvise from this lesson here (#4) on how to get Vienna to recognize the MySQL driver.

Am I on the right track here? Am I missing anything?
Also, just for grins, is there a means to test my installation of MySQL? Everything seems right (from the O'Reilly article I used to install it).

THANKS!

Vienna & MySQL
2003-01-24 19:29:50 dicklacara [Reply | View]

I haven't installed MySQL using Marc's package for a while. It should work. Marc's site does not include the latest MySQL package. I understand that similar Mac OS X packages will be available from the official MySQL site, in the near future.

With that in mind, you should be able to get the package from Marc's site to work with CFMX & ViennaSQL.

To use the jar file you mentioned, you need to install it where it can be found by ViennaSQL, CFMX, or any other Java program -- copy the JDBC driver jar file to:

/Library/Java/Extensions/

Then, setup the appropriate connection for ViennaSQL as in Part 4 of this series.

As far as testing the MySQL install, I never got the Test procedures to work (though I did not spend much time trying).

Dick

problem cf debugging
2003-01-20 21:03:22 anonymous2 [Reply | View]

let me explain how I use my computer and develop my CF apps. I develop on my powerbook G4 and I go back and forth between the office and home all the time. And when I saw that Macromedia released a supported version of CF for the Mac I jumped at it.

I installed CFMX J2EE on JRun4 and all went well. Followed the drections, blah, blah, blah... The end of the day came so I shut everything down and took my computer home.

Got home opened up the sleeping computer and start everything up like I first started it and the page comes up just fine but *bang* all the debugging info does not work. so i plug along trying to figure it out, reinstall, get the debugging to work, restart and *bang*. I think that it comes down to permissions but, I am not sure. So I go through the steps and make sure that i always use 'sudo' and such but the debugging information has not returned.

I am frustrated and have not been able to make any progress with this. Has anyone encountered this problem and if so have you been able to fix it?

Ian Sheridan
ians@vminc.net

here is the java error that I get:

java.sql.SQLException
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:66)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:54)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:384)
at cfclassic2ecfm2048376825._factor4(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:218)
at cfclassic2ecfm2048376825._factor5(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:406)
at cfclassic2ecfm2048376825._factor6(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:613)
at cfclassic2ecfm2048376825.runPage(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:716)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:145)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:299)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:75)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:27)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:51)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:99)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:95)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:408)
at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:378)
at jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:157)
at jrun.servlet.file.FileServlet.service(FileServlet.java:300)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:438)
at cfclassic2ecfm2048376825._factor4(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:218)
at cfclassic2ecfm2048376825._factor5(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:406)
at cfclassic2ecfm2048376825._factor6(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:613)
at cfclassic2ecfm2048376825.runPage(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:716)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:145)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:299)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:75)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:27)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:51)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:99)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:95)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:408)
at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:378)
at jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:157)
at jrun.servlet.file.FileServlet.service(FileServlet.java:300)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

javax.servlet.ServletException: Error Executing Database Query.
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:99)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:408)
at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:378)
at jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:157)
at jrun.servlet.file.FileServlet.service(FileServlet.java:300)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

problem cf debugging
2003-01-21 07:22:22 dicklacara [Reply | View]

A couple of things:

You don't have to shut everything down, just close the cover -- I have a TiBook and I go all over with it. Usually I have CFMX running under both JRun and Tomcat -- sometimes, even the port.-- I very seldom stop ColdFusion, except to recycle some services for new database drivers, etc.

I assume you mean the debugging settings in the CFMX Administrator -- I have no problems retaining the settings across reboots of the system.

You have installed JRun in a non-standard location, /opt/JRun4/ -- the standard (default ) location is /Applications/JRun4/ -- this may be causing your permissions problems.

You should not run JRun ar CFMX as root user (su root or sudo)

You are getting a database error -- What RDBMS are you using: At work? At home?

Is the database on the PowerBook or another machine?

Finally, if you think you have found a legitimate bug, you might want to contact Macromedia!

Dick

problem cf debugging
2003-01-21 11:38:54 anonymous2 [Reply | View]

well ok the owner permissions are all now for my user. and I have stopped using sudo. boots up fine with no errors.

About the non-standard install DIR; this problem was happening when i had installed to the deault DIR also.

In the cf admin I have the debugging turned on in classic mode with the deault settings.

The DB that I am using is Frontbase 3.5d. Accessing that DB through JDBC is working fine. This resides on my computer. during my trouble shooting I have removed FB's jar and I still get the DB error that I had shown above.

The error that I have above is happening in the debugging information at the bottom of the page (essentionally the classic.cfm debugging page).

the reason that this is making me taer my hair out is that, at first it worked.

If I find out what the fix is I will post it here too.

thanks,

Ian Sheridan
ians@vminc.net

problem cf debugging
2003-01-21 12:27:20 dicklacara [Reply | View]

Was FB's JDBC Driver jar in /Library/Java/Extensions/

I haven't played with FB and CFMX on the released version (just the port). It has been a while, but I remember having some problems with FB.

It could be, that you have done something to your particular database, that is causing the errors -- FB could have detected an error in the db and is restricting your access. (I have seen this happen on several different RDBMSs, if they are not shut down properly).

Can you start with a clean copy of the FB database?

Can you run the query through ViennaSQL or the SQL GUI that comes with FB?

Can you approximate the db on another RDBMS (the built-in PointBase allows uo to 500 records in a db)?

You didn't include the contents of the query in the error message -- Is CF choking on the query or FB?

If it is CF, could you create the query string as a variable, display it, then include it between the cfquery tags? It would be nice to see the query.

Whenyou do resololve it, please post the solution.

Dick

problem cf debugging
2003-01-21 12:58:17 anonymous2 [Reply | View]

Dick,

I am accessing the FB DB with no problems at all. And I access the FB DB through SQL4X Manager J just fine.

The query error is happening not in my cfm page but the CFMX debugging cfm page and if I turn off debugging I get no errors at all.

Ian

PS - if you want to look at the query you have a copy already on your machine in the /[jrun root]/servers/[server name]/cfusion/WEB-INF/debug/classic.cfm file on line 214. here is a copy if you'd like to see.

<cfquery dbType="query" name="cfdebug_execution" debug="false">
SELECT (endTime - startTime) AS executionTime
FROM qEvents
WHERE type = 'ExecutionTime'
</cfquery>

Problem with Charting
2003-01-20 13:05:22 lee.smith@mac.com [Reply | View]

I'm hoping that you can help

I have installed JRun4 as per Macromedias instructions, successfully and can access the JMC as expected.

I have installed Coldfusion MX as per Macromedias instructions and can access the admin pages and all example applications except for the charting examples, despite (I believe -several complete reinstall attempts) following all macromedias instructions including those specific to the VM arguments under 'settings'. The pages fail to load and cause the Jrun server to fail.

The following are the initiation - termination reports from the terminal:

Starting Macromedia JRun 4 (Build 54102), default server
01/20 20:43:04 info JRun Naming Service listening on *:2908
01/20 20:43:06 info No JDBC data sources have been configured for this server (see jrun-resources.xml)
01/20 20:43:06 info JRun Web Server listening on *:8100
01/20 20:43:07 info Deploying web application "CFMX RDS Application" from: file:/Applications/JRun4/servers/default/CFIDE/
01/20 20:43:07 user JSPServlet: init
01/20 20:43:07 user RDSDispatchServlet: init
01/20 20:43:07 info Deploying web application "Macromedia Coldfusion MX" from: file:/Applications/JRun4/servers/default/cfusion/
01/20 20:43:08 user JSPServlet: init
01/20 20:43:08 user FlashGateway: init
01/20 20:43:09 user FlashGateway: init
01/20 20:43:09 user ColdFusionStartUpServlet: init
01/20 20:43:09 user ColdFusionStartUpServlet: init
01/20 20:43:09 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services
01/20 20:43:09 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.3.1_03-69
1 [scheduler-0] INFO coldfusion.server - Starting logging...
01/20 20:43:13 user ColdFusionStartUpServlet: ColdFusion MX: application services are now available
01/20 20:43:13 user CFCServlet: init
01/20 20:43:13 user CFCServlet: init
01/20 20:43:13 user AdminServlet: init
01/20 20:43:13 user AdminServlet: init
01/20 20:43:13 info Deploying enterprise application "default-ear" from: file:/Applications/JRun4/servers/default/default-ear/
01/20 20:43:14 info Deploying web application "JRun Default Web Application" from: file:/Applications/JRun4/servers/default/default-ear/
01/20 20:43:15 info Web Services in default-ear#default-war:
01/20 20:43:15 info AdminService
01/20 20:43:15 user JSPServlet: init
01/20 20:43:16 info Deploying enterprise application "JRun 4.0 Internal J2EE Components" from: file:/Applications/JRun4/lib/jrun-comp.ear
01/20 20:43:16 info Deploying EJB "JRunSQLInvoker" from: file:/Applications/JRun4/lib/jrun-comp.ear
01/20 20:43:17 info Deploying enterprise application "Flash Remoting EAR" from: file:/Applications/JRun4/lib/flashgateway.ear
01/20 20:43:17 info Deploying web application "Flash Remoting" from: file:/Applications/JRun4/lib/flashgateway.ear
01/20 20:43:17 user JSPServlet: init
01/20 20:43:17 user FlashGatewayServlet: init
Server default ready (startup time: 18 seconds)
01/20 20:43:48 user FileServlet: init
01/20 20:43:48 user CfmServlet: init
kCGErrorIllegalArgument : initCGDisplayState: cannot map display interlocks.
kCGErrorIllegalArgument : CGSNewConnection cannot get connection port
INIT_Processeses(), could not establish the default connection to the WindowServer.Abort

I am running, OS X 10.2.3, fully patched with the apple default version of Java

I am very much impressed with the series of articles and would appreciate any advice

Thanks

Lee.

Problem with Charting
2003-01-20 14:20:33 dicklacara [Reply | View]

Do another reinstall, but skip step #9 (related to graphics) for JRun.

For Tomcat skip step 10>

I tested CFMX for J2EE all during the bata and after the release -- the special instructions for graphics were never required,

Dick

taglibs with cfmx
2003-01-19 02:06:37 anonymous2 [Reply | View]

um, deploying taglibs with jrun is fine, but in order to use taglibs from within coldfusion you need to have an coldfusion enterprise license (i.e.-- several thousand $$$).

Taglibs do work with CFMXJ2EE
2003-01-20 07:41:06 dicklacara [Reply | View]

I just spent a little time writing and testing some examples (both CFMX and JSP).

I used taglibs from various sources.

The examples worked as expected, in both CFMX and JSP.

It may be that deploying tag libs is not available with CFMX Standalone, Professional version. This version is not available on the Mac.

The earlier Linux port, and the current CFMX for J2EE Developer edition for Mac OS X, are both Developer versions of the product(s). As such, they both are full-featured versions. After 30 days they restrict external access to a single IP address.

So, again, you can deploy taglibs within ColdFusion.

Dick

taglibs with cfmx
2003-01-20 00:49:33 dicklacara [Reply | View]

The CFMX for J2EE developer version for Mac OS X, should be able to handle taglibs (AFAIK).

The developer versions are full enterprise versions, except they are limited to a single external IP (after being installed for 30 days).

Using a taglib with CFMX is discussed at:

http://www.macromedia.com/desdev/mx/coldfusion/articles/java.html

Dick