Install Bluedragon coldfusion on SME7

Tue, 27 Mar 2007 02:37:00 -0700

Download Sme 7 from smeserver.org Download Bluedragon server 7 from http://www.newatlanta.com/c/products/bluedragon/download/home Install SME from cd after install login into the server using putty (ipaddress, username:root password:password you set during install. I used windows networking to copy the install file to sme server. using putty browse to the install file directory (cd /home/e-smith/file/ibays/primary/files) Run the installer ./ BlueDragon_Server_70_339-Linux.sh Accept all the defaults After install restart the server (type "reboot") After restart start bluedragon using putty (cd /usr/local/NewAtlanta/BlueDragon_Server_62/bin) type "./StartBlueDragon.sh") wait a moment and test a .cfm page. I used a simple Add "//usr/local/NewAtlanta/BlueDragon_Server_70/bin/StartBlueDragon.sh" To the end of etc/rc.d/rc.local This will allow Bluedragon to start when SME restarts Download phpmyadmin http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=293 and install rpm -Uvh smeserver-phpmyadmin-multiuser-2.0-3.noarch.rpm Install mysql conector using puty navigate to blue dragons lib directory cd /usr/local/NewAtlanta/BlueDragon_Server_70/lib Get the mysql connector file or read this http://www.newatlanta.com/c/products/bluedragon/self_help/faq/detail?faqId=216 wget http://affordableweb.net/downloads/mysql.jar Make bluedragon work with sme template system using putty login as root. Type cd / mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/bluedragon add ------------------------------------------------------



LoadModule servletexec_module modules/mod_servletexec2.so


    SetHandler servlet-exec


AddHandler servlet-exec cfc
AddHandler servlet-exec cfm
AddHandler servlet-exec cfml
------------------------------------------------------------

exit with save. (clt-x, y, enter) Expand the template /sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf restart apache apachectl restart Test your test.cfm page That should do it

Coldfusion ODBC DSNLess Connections:

Thu, 09 Nov 2006 15:00:00 -0700

I found this list of dsnless connections that i could use with ignite fusion or coldfusion so i posted them here to so i could find them easyly. Dsnless connections will not work with coldfusion MX7


 

 

" "
Select
* 
from PRODUCTS_T
where CurrentStockLevel_SI >=1
 


 

 

ODBC DSNLess Connections:

MS Access ODBC DSNless connection

Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\somepath\dbname.mdb;Uid=Admin;Pwd=pass;

 

dBase ODBC DSNless connection

Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\somepath\dbname.dbf;

Oracle ODBC DSNless connection

Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=admin;Pwd=pass;

MS SQL Server DSNless connection

Driver={SQL Server};Server=servername;Database=dbname;Uid=sa;Pwd=pass;

MS Text Driver DSNless connection

Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt;Persist Security Info=False;

Visual Foxpro DSNless connection

Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\somepath\dbname.dbc;Exclusive=No;

MySQL DSNless connection

driver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;

Affordable Web

Install Bluedragon coldfusion on SME7

Coldfusion ODBC DSNLess Connections: