RE: CF form puzzler
No - standard text field. That doesn't mean they couldn't copy-and-paste from something else but, given the size of the answers (they are enteriing county names, one, maybe two), I find that very unlikely. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, May 07, 2011 4:12 PM To: cf-talk Subject: Re: CF form puzzler how is the content getting entered, is it a WYSIWYG editor ? If so then your users are probably copying and pasting content from WORD and thus you get al the word markup. You need to do some auto cleanup of the content to avoid this, CKEDITOR has this built in. On Sat, May 7, 2011 at 8:42 PM, Stephens, Larry V steph...@indiana.eduwrote: I'm leaving out some code here (for other fields): cfform action=Register_Step_2_Response.cfm method=post cfinput type=text name=ProjTitleUrl size=20 maxlength=50 /cfform In the response file: cfparam name=FORM.ProjTitleUrl default= INSERT INTO Positions ( ProjTitleURL ) VALUES ( '#FORM.ProjTitleUrl#'); /cfquery The other fields (I omitted here) in the form and in the insert query all work fine but this one keeps doing screwy things. ProjTitleUrl is a memo field (why I set it up that way I don't recall, but I don't think that should make any difference over it being a text field; and why I put a maxlength in with a memo field I can't remember). I keep seeing html charcters in the field and the latest entry has 300-400 lines of MS Word html code and, at the very end, the true entry Pierce amp; Madison Co.s I imagine Co.s is just a typo by the user, but I'll bet money they used not amp; when they input this. This is running on a CF8 server and I haven't seen anything like this on any other page I have there. I just made a similar entry myself and it comes out fine. Anyone have a clue why all this extraneous stuff is getting inserted? Could it be caused by a particular browser? Larry Stephens steph...@indiana.edu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF form puzzler
I keep seeing html charcters in the field and the latest entry has 300-400 lines of MS Word html code and, at the very end, the true entry Pierce amp; Madison Co.s Is it possible that you are having two fields using the same name in the form ? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scripting of adding a Database - CF8
Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scripting of adding a Database - CF8
Have you looked into the CFAdmin API? You can do all this from code using this API. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 9, 2011, at 10:16 AM, Matthew Friedman wrote: Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scripting of adding a Database - CF8
Add database (SQL Server): SEE: http://msdn.microsoft.com/en-us/library/ms176061.aspx CREATE DATABASE [mydatabasename] Add datasource: SEE: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html On Mon, May 9, 2011 at 10:16 AM, Matthew Friedman m...@hozgroup.com wrote: Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scripting of adding a Database - CF8
Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some where. Not production ready but it would give you a start in the right direction. G! On Mon, May 9, 2011 at 11:26 AM, Wil Genovese jugg...@trunkful.com wrote: Have you looked into the CFAdmin API? You can do all this from code using this API. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 9, 2011, at 10:16 AM, Matthew Friedman wrote: Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scripting of adding a Database - CF8
On Mon, May 9, 2011 at 4:47 PM, Gerald Guido gerald.gu...@gmail.com wrote: Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some where. Not production ready but it would give you a start in the right direction. G! On Mon, May 9, 2011 at 11:26 AM, Wil Genovese jugg...@trunkful.com wrote: Have you looked into the CFAdmin API? You can do all this from code using this API. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 9, 2011, at 10:16 AM, Matthew Friedman wrote: Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scripting of adding a Database - CF8
Here it is My bad... http://cfmladminapi.riaforge.org/ HTH G! On Mon, May 9, 2011 at 11:47 AM, Gerald Guido gerald.gu...@gmail.comwrote: Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some where. Not production ready but it would give you a start in the right direction. G! On Mon, May 9, 2011 at 11:26 AM, Wil Genovese jugg...@trunkful.comwrote: Have you looked into the CFAdmin API? You can do all this from code using this API. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 9, 2011, at 10:16 AM, Matthew Friedman wrote: Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Form Field Validation - codon boundaries
I should have provided more detail. This has to do with nucleotide strings in DNA. for example, consider the follow string: 123 456 789 act gta ccc ... (spaces not in string, just for clarity) Any start position must begin at position 1,4,7, etc. Any end position must conclude at position 3,6,9 etc. So, I am not sure the function below would do exactly what I need?? On 5/7/2011 4:40 AM, Jason Fisher wrote: If startVal, endVal, and lengthVal represent your values in JS [like var startVal = parseInt(myForm.start.value); ], then the following should work: if (startVal % 3 != 0) { alert(Start must be a multiple of 3.); return false; } else if (endVal % 3 != 0) { alert(End must be a multiple of 3.); return false; } else if (endVal startVal) { alert(End must be larger than Start.); return false; } else if (endVal lengthVal) { alert(End cannot be larger than Length.); return false; } return true; You could put that into a function and call the function on the form onsubmit(return myFunction()). On 5/6/2011 5:51 PM, Rick Colman wrote: I have the following: length: xxxstart [ ] end [ ] I would like to test for the following conditions: * must be an integer * start and end must be evenly divisible by 3 * end cannot exceed length CFINPUT works for type test, but not sure how to generate the javascript validation that would be required. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Form Field Validation - codon boundaries
i dont know how, but im going to say some regex work here would do the trick. On Mon, May 9, 2011 at 1:51 PM, Rick Colman rcol...@cox.net wrote: I should have provided more detail. This has to do with nucleotide strings in DNA. for example, consider the follow string: 123 456 789 act gta ccc ... (spaces not in string, just for clarity) Any start position must begin at position 1,4,7, etc. Any end position must conclude at position 3,6,9 etc. So, I am not sure the function below would do exactly what I need?? On 5/7/2011 4:40 AM, Jason Fisher wrote: If startVal, endVal, and lengthVal represent your values in JS [like var startVal = parseInt(myForm.start.value); ], then the following should work: if (startVal % 3 != 0) { alert(Start must be a multiple of 3.); return false; } else if (endVal % 3 != 0) { alert(End must be a multiple of 3.); return false; } else if (endVal startVal) { alert(End must be larger than Start.); return false; } else if (endVal lengthVal) { alert(End cannot be larger than Length.); return false; } return true; You could put that into a function and call the function on the form onsubmit(return myFunction()). On 5/6/2011 5:51 PM, Rick Colman wrote: I have the following: length: xxx start [ ] end [ ] I would like to test for the following conditions: * must be an integer * start and end must be evenly divisible by 3 * end cannot exceed length CFINPUT works for type test, but not sure how to generate the javascript validation that would be required. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf_sql_timestamp
I've always used cf_sql_timestamp, in cfqueryparams, when using a value with a date and time. Comparing the online documentation, between CF8 and CF9, it looks like this datatype is now intended to map to the sql timetamp datatype in CF9.is this correct, or just mis-documentation? http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_18.html#1102474 Thanks -Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf_sql_timestamp
is this correct, or just mis-documentation? IMO it is an error. datetime and smalldatetime are valid types, yet they are missing entirely from the CF9/MSSQL column. My recollection is the ms sql timestamp type maps to cf_sql_binary, not cf_sql_timestamp, like in the CF8 documentation. http://msdn.microsoft.com/en-us/library/ms378878.aspx ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Solr Errors
Just checking in Mary. Were you able to get past this? Have you considering contacting Adobe for official support? On Mon, Apr 11, 2011 at 2:41 PM, Mary Jo Sminkey mary...@cfwebstore.com wrote: What are you loading into your index (queries or documents)? Can you provide a code snippet of your process? Just results of a query, so nothing real earth-shattering. Just wanted to use Solr to search all my long text fields that hold a considerable amount of data (users have a search interface to select which tables to search, I'm using categories to handle that). The majority of the data gets updated and reindexed nightly, this is the one type of data that users can add and so needs to be updated at runtime. My cfindex tag looks like this: cfindex collection=#docCollection# action=update body=thedata category=IMPACT custom1=grant_id custom2=fy key=key query=local.qryImpacts / --- Mary Jo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Precision Value from SQL Server CF9
yes, I could do it that way. However, all dates I try to insert are giving the error, not just ones I'm using the function #now()# in. Turns out the issue is my data source in CF. We have been using the ODBC socket to connect CF to the System DSN which uses the SQL Native driver. When I change my CF data source to the SQL Server driver instead of the ODBC Socket, all works fine! database have built in functions for getting the current date, so you don't need to use CF. e.g. for sql server use editdate - getDate() ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Scripting of adding a Database - CF8
Everything you need is in the Admin API. Specifically... the datasource.cfc Here is a quick snippet for creating a SQL Server CF dsn. cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(arguments.cfadminpassword); dbObj = createObject(component,cfide.adminapi.datasource); // Create the DSN dbObj.setMSSQL ( name = arguments.newDataSourceName , host = arguments.databaseServer , database = arguments.newDataSourceDB , port = arguments.newDataSourcePort , username = arguments.newDataSourceUsername , password = arguments.newDataSourcePassword , selectmethod = direct , disable = false , disable_clob = false , disable_blob = false , sendStringParametersAsUnicode = true ); /cfscript .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Matthew Friedman [mailto:m...@hozgroup.com] Sent: Monday, May 09, 2011 11:17 AM To: cf-talk Subject: Scripting of adding a Database - CF8 Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Migrating a DB from MS SQL 2000 into MySQL latest release
I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version
Quick question: Does the 64 bit Windows server 2k3 (and CF server 8.x 64 bit) use enough extra RAM than the 32 bit version for it to be significant? I am looking @ a Windows server 2k3 VPS with one gig of ram and was wondering if getting the 64 bit version would make any difference in terms of RAM. As always, many TIA, G! -- Gerald Guido http://www.myinternetisbroken.com ONE TWO THREE FOUR!!! -- Dee Dee Ramone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels jor...@viviotech.netwrote: I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version
64-bit OS only comes into play if you are going to be taking advantage of a lot of ram. If you are doing under 4 gigs for the box, there is no reason for a 64-bit OS, go with 32-bit. Judah On Mon, May 9, 2011 at 4:08 PM, Gerald Guido gerald.gu...@gmail.com wrote: Quick question: Does the 64 bit Windows server 2k3 (and CF server 8.x 64 bit) use enough extra RAM than the 32 bit version for it to be significant? I am looking @ a Windows server 2k3 VPS with one gig of ram and was wondering if getting the 64 bit version would make any difference in terms of RAM. As always, many TIA, G! -- Gerald Guido http://www.myinternetisbroken.com ONE TWO THREE FOUR!!! -- Dee Dee Ramone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Perhaps you tried to run MSSQL on linux Jordan, that would certainly be humorous I imagine :-) On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.comwrote: Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version
Thanx Judah. This list = awesome! G! On Mon, May 9, 2011 at 7:15 PM, Judah McAuley ju...@wiredotter.com wrote: 64-bit OS only comes into play if you are going to be taking advantage of a lot of ram. If you are doing under 4 gigs for the box, there is no reason for a 64-bit OS, go with 32-bit. Judah On Mon, May 9, 2011 at 4:08 PM, Gerald Guido gerald.gu...@gmail.com wrote: Quick question: Does the 64 bit Windows server 2k3 (and CF server 8.x 64 bit) use enough extra RAM than the 32 bit version for it to be significant? I am looking @ a Windows server 2k3 VPS with one gig of ram and was wondering if getting the 64 bit version would make any difference in terms of RAM. As always, many TIA, G! -- Gerald Guido http://www.myinternetisbroken.com ONE TWO THREE FOUR!!! -- Dee Dee Ramone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version
It would depend what you want to achieve. on 32bit you can only give 1GB or so to CF, with 64bit you can give a lot more. But if you are only going to have 1GB RAM anyway then there is no point as you will only really be able to give 512mb to CF anyway. On Tue, May 10, 2011 at 12:15 AM, Judah McAuley ju...@wiredotter.comwrote: 64-bit OS only comes into play if you are going to be taking advantage of a lot of ram. If you are doing under 4 gigs for the box, there is no reason for a 64-bit OS, go with 32-bit. Judah On Mon, May 9, 2011 at 4:08 PM, Gerald Guido gerald.gu...@gmail.com wrote: Quick question: Does the 64 bit Windows server 2k3 (and CF server 8.x 64 bit) use enough extra RAM than the 32 bit version for it to be significant? I am looking @ a Windows server 2k3 VPS with one gig of ram and was wondering if getting the 64 bit version would make any difference in terms of RAM. As always, many TIA, G! -- Gerald Guido http://www.myinternetisbroken.com ONE TWO THREE FOUR!!! -- Dee Dee Ramone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Well, it is pretty damn funny. I've migrated from MS SQL to MySql before and it generally isn't too bad. There are various migration tools available, I like the ones from Red Gate. MySql has some funkiness that comes into play if you want to combine foreign keys and full text indexing from what I recall, though that may have gone away in more recent versions. There are also data type differences that you might want to take a look at, like you would think that timestamp (in mysql) would be a datetime type but it isn't, so be sure to read up on them and you should be fine. If you are still looking at options, you might also want to look at PostGres. PostGres is a solidly enterprise-level db (hot swap backup, all sorts of replication options, partitioning, etc), is free, truly open source and doesn't have the strangeness that comes along with MySql being governed by Oracle. It's good stuff. Cheers, Judah On Mon, May 9, 2011 at 4:12 PM, Gerald Guido gerald.gu...@gmail.com wrote: Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels jor...@viviotech.netwrote: I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Or possibly Jordan has needed a database that runs on more than 1 CPU, uses more than 1GB of RAM or has a db size of more than 10GB :) On Mon, May 9, 2011 at 4:20 PM, Russ Michaels r...@michaels.me.uk wrote: Perhaps you tried to run MSSQL on linux Jordan, that would certainly be humorous I imagine :-) On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.comwrote: Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version
Thanx Russ, It is just an el-cheapo VPS for my dev and hobby sites so it is no big deal. Thanx G! On Mon, May 9, 2011 at 7:23 PM, Russ Michaels r...@michaels.me.uk wrote: It would depend what you want to achieve. on 32bit you can only give 1GB or so to CF, with 64bit you can give a lot more. But if you are only going to have 1GB RAM anyway then there is no point as you will only really be able to give 512mb to CF anyway. On Tue, May 10, 2011 at 12:15 AM, Judah McAuley ju...@wiredotter.com wrote: 64-bit OS only comes into play if you are going to be taking advantage of a lot of ram. If you are doing under 4 gigs for the box, there is no reason for a 64-bit OS, go with 32-bit. Judah On Mon, May 9, 2011 at 4:08 PM, Gerald Guido gerald.gu...@gmail.com wrote: Quick question: Does the 64 bit Windows server 2k3 (and CF server 8.x 64 bit) use enough extra RAM than the 32 bit version for it to be significant? I am looking @ a Windows server 2k3 VPS with one gig of ram and was wondering if getting the 64 bit version would make any difference in terms of RAM. As always, many TIA, G! -- Gerald Guido http://www.myinternetisbroken.com ONE TWO THREE FOUR!!! -- Dee Dee Ramone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Many people often wrongly assume that MySQL is simply FREE, which is not correct. Many people are also completely unaware that there is a FREE MSSQL Express edition. The FREE version is the community edition, which also has limitations, look them up, If you want enterprise features then you have to pay i'm afraid, even with MySQL. The FREE editions of both will meet most peoples needs even with their limitations, it is really not very common to have databases of 10GB that needs more than 1GB RAM or more than 1CPU, then you probably be using the FREE editions anyway. On Tue, May 10, 2011 at 12:26 AM, Judah McAuley ju...@wiredotter.comwrote: Or possibly Jordan has needed a database that runs on more than 1 CPU, uses more than 1GB of RAM or has a db size of more than 10GB :) On Mon, May 9, 2011 at 4:20 PM, Russ Michaels r...@michaels.me.uk wrote: Perhaps you tried to run MSSQL on linux Jordan, that would certainly be humorous I imagine :-) On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.com wrote: Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
yes it will run fine. The limitations of web edition are windows related, you cannot installed MSSQL for example, but it doesn;t stop you installing any 3rd party software. On Tue, May 10, 2011 at 12:55 AM, Robert Rhodes rrhode...@gmail.com wrote: Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
It should run fine. I installed it no problem on the Web Server Edition. Web Server Edition is just a feature limited version of the Standard version. HTH G! On Mon, May 9, 2011 at 7:55 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ISP blocking port 25
Big problem.. I use verizon fios for my Internet connection. It is a business class - static IPs and specifically allows web and email servers. Was working really nice.. then today around 1pm, I couldn't send email. My mail server (smartermail) log said couldn't connect to server.. mostly AOL servers.. so at first I thought aol was blocking me.. then I figured out that I couldn't telnet to any server on port 25 outside of my network. I called tech support and had to escalate way up before someone understood. They kept telling me to change the port to something else. But that can't work.. Finally I found someone who understood the problem. He first said that I can not use port 25.. I have to figure out a way around it. After a lot of arguing, he understood and said he will check into it.. 6 hours later, I just hear back.. other people are reporting the same problem. Looks like they misconfigured a router but the people who know how to fix it won't be in until tomorrow morning. So - anyone have any ideas on what I can do from now until it is fixed? I changed the retries on my mail server to 6,12,18,24 hours so hopefully the mail in the queue will go out when it is fixed and I won't lose anything... but of course this is for a brain cancer charity and we are in the middle of the national walk to end brain tumors for brain tumor awareness month and were getting a lot of action on the server. 2 times before they messed up and changed my static IPs without telling me. Each time took about 24 hours to fix. You would think they would tell you before changing IPs or blocking a port. I need to find a better ISP... anyone know of a good one? Al ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ISP blocking port 25
Hi Al, Do you route all of your out-going mail to one server? Because that's a horrible way to do it if you are sending out a lot of mail, exactly because of the experience you have now. Have they told you what port you can use? If so, you can change the port on Coldfusion in CF Admin: Server Settings Mail. You can also change the port on the cfmail tag, cfmail port =. You can also change the out-going port on Smartermail if you look at the Default Domain Settings. If you need any help, give me a shout off-list. Jenny -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: 10 May 2011 01:37 To: cf-talk Subject: ISP blocking port 25 Big problem.. I use verizon fios for my Internet connection. It is a business class - static IPs and specifically allows web and email servers. Was working really nice.. then today around 1pm, I couldn't send email. My mail server (smartermail) log said couldn't connect to server.. mostly AOL servers.. so at first I thought aol was blocking me.. then I figured out that I couldn't telnet to any server on port 25 outside of my network. I called tech support and had to escalate way up before someone understood. They kept telling me to change the port to something else. But that can't work.. Finally I found someone who understood the problem. He first said that I can not use port 25.. I have to figure out a way around it. After a lot of arguing, he understood and said he will check into it.. 6 hours later, I just hear back.. other people are reporting the same problem. Looks like they misconfigured a router but the people who know how to fix it won't be in until tomorrow morning. So - anyone have any ideas on what I can do from now until it is fixed? I changed the retries on my mail server to 6,12,18,24 hours so hopefully the mail in the queue will go out when it is fixed and I won't lose anything... but of course this is for a brain cancer charity and we are in the middle of the national walk to end brain tumors for brain tumor awareness month and were getting a lot of action on the server. 2 times before they messed up and changed my static IPs without telling me. Each time took about 24 hours to fix. You would think they would tell you before changing IPs or blocking a port. I need to find a better ISP... anyone know of a good one? Al ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344381 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ISP blocking port 25
I can use any port except for 25 right now. Going from the coldfusion 7 server to the smartermail server (different boxes but within my local network) is no problem, so making a change in cf administrator won't help. The problem is a router between me and the rest of the internet that verizon controls and is blocking port 25 with. In smartermail, I don't see where the outgoing smtp port can be changed? And if I did, how would it connect to all of the different domains on the internet? What port number could I use? I think the answer might lie in using a gateway server.I send about 10,000 emails a day from the 8 websites I run.. and all now go through my smartermail server. All of the messages conform to the spam rules..all are medical related that people have asked for. So I am looking for a gateway server. I found a few but they are really expensive - anyone know a relatively cheap one? Hi Al, Do you route all of your out-going mail to one server? Because that's a horrible way to do it if you are sending out a lot of mail, exactly because of the experience you have now. Have they told you what port you can use? If so, you can change the port on Coldfusion in CF Admin: Server Settings Mail. You can also change the port on the cfmail tag, cfmail port =. You can also change the out-going port on Smartermail if you look at the Default Domain Settings. If you need any help, give me a shout off-list. Jenny -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: 10 May 2011 01:37 To: cf-talk Subject: ISP blocking port 25 Big problem.. I use verizon fios for my Internet connection. It is a business class - static IPs and specifically allows web and email servers. Was working really nice.. then today around 1pm, I couldn't send email. My mail server (smartermail) log said couldn't connect to server.. mostly AOL servers.. so at first I thought aol was blocking me.. then I figured out that I couldn't telnet to any server on port 25 outside of my network. I called tech support and had to escalate way up before someone understood. They kept telling me to change the port to something else. But that can't work.. Finally I found someone who understood the problem. He first said that I can not use port 25.. I have to figure out a way around it. After a lot of arguing, he understood and said he will check into it.. 6 hours later, I just hear back.. other people are reporting the same problem. Looks like they misconfigured a router but the people who know how to fix it won't be in until tomorrow morning. So - anyone have any ideas on what I can do from now until it is fixed? I changed the retries on my mail server to 6,12,18,24 hours so hopefully the mail in the queue will go out when it is fixed and I won't lose anything... but of course this is for a brain cancer charity and we are in the middle of the national walk to end brain tumors for brain tumor awareness month and were getting a lot of action on the server. 2 times before they messed up and changed my static IPs without telling me. Each time took about 24 hours to fix. You would think they would tell you before changing IPs or blocking a port. I need to find a better ISP... anyone know of a good one? Al ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344382 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
So how did your first day go? Any load issues with the setup the good folks on this recommended? Brian Polackoff On May 8, 2011, at 9:46 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 8/05/2011 10:58 PM, Robert Rhodes wrote: I installed Win2K8 on one of the servers last night, and discovered there is actually 6GB of memory in them. I had forgotten that I had to install the RAM sticks in threes on these servers. Just sitting there idling, it's got 340mb cached, 5451mb available, and 5133mb free. 6GB, that's a nice number. Set the JVM max to 3GB, max perm to 512 and let it take traffic. If all is good the OS will bump up to about 1GB and the cache the same leaving a smidge of fully free mem. If you have a server monitor of some form you can then balance as needed. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ISP blocking port 25
Hi Al, If Verizon is blocking delivery from Smartermail outside their own network, there is nothing you can do. Port 25 is the only port for email to be delivered on. Verizon has violated their terms of service by denying you use of your connection. This is the classic definition of an outage. And you can't use a gateway server as that will be delivered on port 25 as well. --Ben On 5/9/2011 7:06 PM, Al Musella, DPM wrote: I can use any port except for 25 right now. Going from the coldfusion 7 server to the smartermail server (different boxes but within my local network) is no problem, so making a change in cf administrator won't help. The problem is a router between me and the rest of the internet that verizon controls and is blocking port 25 with. In smartermail, I don't see where the outgoing smtp port can be changed? And if I did, how would it connect to all of the different domains on the internet? What port number could I use? I think the answer might lie in using a gateway server.I send about 10,000 emails a day from the 8 websites I run.. and all now go through my smartermail server. All of the messages conform to the spam rules..all are medical related that people have asked for. So I am looking for a gateway server. I found a few but they are really expensive - anyone know a relatively cheap one? -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 or PO Box 1122 480-704-2000 Queen Creek, AZ 85142 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ISP blocking port 25
On 10/05/2011 12:51, Ben Conner wrote: And you can't use a gateway server as that will be delivered on port 25 as well. How about port 587, the alternate port for authenticated mails, that should still be open. If not maybe a completely different port to a gateway where that is configurable? -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344386 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
I do use MSSQL, but never on server that is web-facing. So, that will not be a problem. On Mon, May 9, 2011 at 8:00 PM, Russ Michaels r...@michaels.me.uk wrote: yes it will run fine. The limitations of web edition are windows related, you cannot installed MSSQL for example, but it doesn;t stop you installing any 3rd party software. On Tue, May 10, 2011 at 12:55 AM, Robert Rhodes rrhode...@gmail.com wrote: Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrating a DB from MS SQL 2000 into MySQL latest release
MySql is free though licensing is a bit complicated because of a dual-license model. The community edition includes many enterprise sorts of features like replication and partitioning. If I recall, there are additional backup tools and monitoring in the paid enterprise edition. If you want to go completely free from the weird Oracle ownership stuff (which I think is wise, personally), there is the MariaDB fork which is entirely FOSS as far as I know. What enterprise features are you thinking aren't in the community edition? MySql community edition has none of the limitations present in MS SQL Express edition. Honestly, not taking advantage of more than a gig of RAM or 1 cpu core is just stupid. Why would you even have a database server? I suppose if you are housing the db on the same machine as your app server then...well, you have plenty of other problems at that point. Sql Express is great for development (though I prefer developer edition myself). It is not meant for production websites, period. That's why Microsoft has a Web edition. I like SQL Server and use it but it is wrong to try and compare Sql Express and MySql community edition, they are completely different classes of software. That being said, I still think people should check out PostGres. A feature set comparable to Oracle/MS SQL/Sybase and genuinely FOSS, unlike MySql. Tasty DB goodness. Cheers, Judah On Mon, May 9, 2011 at 4:57 PM, Russ Michaels r...@michaels.me.uk wrote: Many people often wrongly assume that MySQL is simply FREE, which is not correct. Many people are also completely unaware that there is a FREE MSSQL Express edition. The FREE version is the community edition, which also has limitations, look them up, If you want enterprise features then you have to pay i'm afraid, even with MySQL. The FREE editions of both will meet most peoples needs even with their limitations, it is really not very common to have databases of 10GB that needs more than 1GB RAM or more than 1CPU, then you probably be using the FREE editions anyway. On Tue, May 10, 2011 at 12:26 AM, Judah McAuley ju...@wiredotter.comwrote: Or possibly Jordan has needed a database that runs on more than 1 CPU, uses more than 1GB of RAM or has a db size of more than 10GB :) On Mon, May 9, 2011 at 4:20 PM, Russ Michaels r...@michaels.me.uk wrote: Perhaps you tried to run MSSQL on linux Jordan, that would certainly be humorous I imagine :-) On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.com wrote: Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at 6:52 PM, Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html I've done it several times with no issues. -Jordan On 05/09/2011 03:38 PM, Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ISP blocking port 25
If you have a VM or something outside of their network, then you could set up an SSH tunnel and do port forwarding, having your local port 25 get tunneled over to the remote machine and then sent out from there. Judah On Mon, May 9, 2011 at 5:36 PM, Al Musella, DPM muse...@virtualtrials.com wrote: Big problem.. I use verizon fios for my Internet connection. It is a business class - static IPs and specifically allows web and email servers. Was working really nice.. then today around 1pm, I couldn't send email. My mail server (smartermail) log said couldn't connect to server.. mostly AOL servers.. so at first I thought aol was blocking me.. then I figured out that I couldn't telnet to any server on port 25 outside of my network. I called tech support and had to escalate way up before someone understood. They kept telling me to change the port to something else. But that can't work.. Finally I found someone who understood the problem. He first said that I can not use port 25.. I have to figure out a way around it. After a lot of arguing, he understood and said he will check into it.. 6 hours later, I just hear back.. other people are reporting the same problem. Looks like they misconfigured a router but the people who know how to fix it won't be in until tomorrow morning. So - anyone have any ideas on what I can do from now until it is fixed? I changed the retries on my mail server to 6,12,18,24 hours so hopefully the mail in the queue will go out when it is fixed and I won't lose anything... but of course this is for a brain cancer charity and we are in the middle of the national walk to end brain tumors for brain tumor awareness month and were getting a lot of action on the server. 2 times before they messed up and changed my static IPs without telling me. Each time took about 24 hours to fix. You would think they would tell you before changing IPs or blocking a port. I need to find a better ISP... anyone know of a good one? Al ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344390 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
I talked them into a few more days. Currently we are aiming for Friday. Phew! On Mon, May 9, 2011 at 10:26 PM, Brian Polackoff bpolack...@gmx.com wrote: So how did your first day go? Any load issues with the setup the good folks on this recommended? Brian Polackoff On May 8, 2011, at 9:46 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 8/05/2011 10:58 PM, Robert Rhodes wrote: I installed Win2K8 on one of the servers last night, and discovered there is actually 6GB of memory in them. I had forgotten that I had to install the RAM sticks in threes on these servers. Just sitting there idling, it's got 340mb cached, 5451mb available, and 5133mb free. 6GB, that's a nice number. Set the JVM max to 3GB, max perm to 512 and let it take traffic. If all is good the OS will bump up to about 1GB and the cache the same leaving a smidge of fully free mem. If you have a server monitor of some form you can then balance as needed. -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ISP blocking port 25
in the meantime, try port 26 - it usually works fine (unless it is blocked). Azadi On 10/05/2011 08:36 , Al Musella, DPM wrote: So - anyone have any ideas on what I can do from now until it is fixed? I changed the retries on my mail server to 6,12,18,24 hours so hopefully the mail in the queue will go out when it is fixed and I won't lose anything... but of course this is for a brain cancer charity and we are in the middle of the national walk to end brain tumors for brain tumor awareness month and were getting a lot of action on the server. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm