Search the web
Sign In
New User? Sign Up
speckcms · Speck CMS
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
How to use a MySQL or MSSQL database for HelloSpeck   Message List  
Reply | Forward Message #735 of 830 |
Re: [speckcms] How to use a MySQL or MSSQL database for HelloSpeck

Hi Dave,

> If I want to setup the Hellospeck app using a MySQL or MSSQL db I know
> I have to specify the database type in the hellospeck.app file, but
> where do I supply the database username and password?

You'd normally just do this when setting up the datasource in the cf
administrator. If for some reason you can't do that, you can add the
username and password to a database section in the application
configuration, e.g.

[database]
username = dbusername
password = dbpassword

Add this at the end of your config file, after all other settings.

The database section of the application configuration file is optional
and is only used override system wide settings for your DBMS (for
example to force a character string data type other than simply
character varying) or provide a username and password to connect to the
database (if you can't provide it as part of the datasource).


Mark



Tue Jun 3, 2008 10:10 am

markthickpaddy
Offline Offline
Send Email Send Email

Forward
Message #735 of 830 |
Expand Messages Author Sort by Date

Hi, Just started using this and have set things up fine with a blank access db. If I want to setup the Hellospeck app using a MySQL or MSSQL db I know I have...
dave_abrams
Offline Send Email
Jun 3, 2008
9:54 am

Hi Dave, ... You'd normally just do this when setting up the datasource in the cf administrator. If for some reason you can't do that, you can add the username...
Mark Woods
markthickpaddy
Offline Send Email
Jun 3, 2008
10:10 am

Mark, Thanks. I don't know why but I always thought I had to supply the username and pw if the database was password protected even if the datasource had the...
dave_abrams
Offline Send Email
Jun 7, 2008
6:55 pm

... Hash: SHA1 I set my userrname/password within the ColdFusion Administrator for the Datasource. ... Arial; margin: 14px 0px; padding: 0px 14px; } #ygrp-mkp...
Graham Pearson
gspearson69
Offline Send Email
Jun 3, 2008
11:13 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help