BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 04-17-2008, 08:22 PM   #1 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default HOWTO: Enable/Disable HTML Email Processing in BES 4.1 SP5

Please Login to Remove!

Please note that this is an unsupported configuration by RIM. There are known issues and conditions that can potentially cause your messaging (Exchange) server to crash. This is not a recommended solution for large BlackBerry deployments. If you do not have OS 4.5 (currently in beta) on your devices, don't apply this patch. If you do not know what you're doing, don't apply this patch!

I hope that's enough disclaimers and warnings, but if not, I have included a method to disable this feature in the package as well. By applying this patch, you agree that BlackBerryForums.com or Jibi (me) or Research In Motion are not responsible for any damage that may be caused by applying the patch in your environment.

Logical Overview
The logic behind the SQL queries being applied is a two-fold approach - a) enables the feature at the server level, and b) enables the feature at the user level for ALL users.

Pre-Requisite: BlackBerry devices must have OS 4.5 in order to take advantage of the HTML feature found deep within BlackBerry Enterprise Server 4.1 SP5. Please do not request this OS in order to test the BES features, as you may be banned from BlackBerryForums.com for asking. Thanks.

<db name> = BESMgmt by default

To enable HTML email processing:
- Login to your BES as the BES service account
- Extract files to a folder
- Bring up a command prompt and navigate to your folder
- Run the following command:
BBDBUpdate.exe -db <db name> -n <sql server name> -input EnableRichContent.sql

To disable HTML email processing:
- Login to your BES as the BES service account
- Extract files to a folder
- Bring up a command prompt and navigate to your folder
- Run the following command:
BBDBUpdate.exe -db <db name> -n <sql server name> -input DisableRichContent.sql
Attached Files
File Type: zip BBDBRichContent.zip (235.6 KB, 1192 views)
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.

Last edited by jibi : 04-20-2008 at 11:02 AM.
Offline  
Old 04-18-2008, 01:03 AM   #2 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2005
Location: Sydney
Model: 9000
Carrier: Telstra
Posts: 23
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is this feature only accessible to Exchange environments? Can I enable this in my Domino environment with SP5 and OS4.5?
__________________
Two Thumbs Technology
Specialist BlackBerry Technical Services & Training
http://www.TwoThumbs.com.au
Offline  
Old 04-18-2008, 01:47 AM   #3 (permalink)
BlackBerry Extraordinaire
 
BBAdmin's Avatar
 
Join Date: Feb 2005
Location: Port 3101.org
Model: .
Carrier: .
Posts: 2,491
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Is this feature only accessible to Exchange environments? Can I enable this in my Domino environment with SP5 and OS4.5?
I would assume yes but I couldn't help you.

Just to elaborate slightly on J's point, the reason it was pulled was due to processor load on the Exchange Server in large environments where companies were sending out distribution wide HTML emails at once. I can't see how they're going to get around this in future releases as all roads lead to the Exchange Server, but I suspect they will figure something out.
__________________


Last edited by jibi : 04-18-2008 at 09:10 AM.
Offline  
Old 04-18-2008, 09:12 AM   #4 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

...nor why such an issue wasn't found by RIM in the 6-8 prior months of testing, but whatever

This feature should be the same for Domino. I will download the package here shortly to verify the registry change would be the same.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 04-18-2008, 09:37 AM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
AlanM's Avatar
 
Join Date: May 2005
Location: Huntsville, AL
Model: 9930
Carrier: Verizon
Posts: 335
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default

Jibi, what are you saying? What do you mean I can't hold you responsible? It's how I get myself out of trouble here at work.

Me (to my bosses): Well, this guy, Jibi, on the BB forums said apply this patch. It's not my fault.

Bosses: Well, then, if it's not your fault, everything's OK. But that guy Jibi is fired.

LOL

In reality html email means little to me in my environment, since we have to disable it. (why Oh why, does MS make you disable it at the client only).
__________________
AlanM
Exchange\Blackberry Admin
4 - BES Servers (5.0.3),
~1500 BB Users, and a headache.
War Eagle!!
Offline  
Old 04-19-2008, 04:31 PM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Jibi, I have followed your instruction and applied it on BES 4.1.5 with no success. I got the error message:
C:\>BBDBUpdate.exe -db BESTESTDB -input EnableRichContent.sql
BlackBerry Configuration Database Update tool Version 4.1.4.8
Copyright (c) Research In Motion, Ltd. 2000-2007. All rights reserved.
Modification date: Aug 8 2007

[20000] (17:30:08.218):{0x1124} Connect to database server: localhost
[20000] (17:30:08.218):{0x1124} Database name: BESTESTDB
[10000] (17:30:25.000):{0x1124} Failed to open database connection


What did I do wrong?
Thanks!

EDIT:
from BBDBUpate Log

[20000] (04/19 17:30:08.218):{0x1124} Connect to database server: localhost
[20000] (04/19 17:30:08.218):{0x1124} Database name: BESTESTDB
[40000] (04/19 17:30:08.218):{0x1124} Authentication Type: Windows Authentication
[40000] (04/19 17:30:25.000):{0x1124} ...connection failed (ADOConnectionItem::ConnectToDB(): COM Error 0x80004005 - Cannot connect to database: Cannot open database).
[10000] (04/19 17:30:25.000):{0x1124} Failed to open database connection

Last edited by BB Junkie : 04-19-2008 at 05:23 PM.
Offline  
Old 04-19-2008, 05:20 PM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I forgot to mention that I dont have SQL Server, but rather SQL Server Express or MSDE that comes with BES 4.1.5 installer if that makes the difference. Thanks again.

Last edited by BB Junkie : 04-19-2008 at 05:22 PM.
Offline  
Old 04-19-2008, 09:08 PM   #8 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

SQL Express shouldn't matter at all here.

Have you logged into the server with an account that is a part of the Administrators group on the server?
Offline  
Old 04-19-2008, 09:14 PM   #9 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
SQL Express shouldn't matter at all here.

Have you logged into the server with an account that is a part of the Administrators group on the server?
Found the solution to this problem. I had to add this command line:

BBDBUpdate.exe -db <db name> -n <server name> -input EnableRichContent.sql
and it worked! I was able to receive html emails now. Hope that helps for anyone who has the same issue as I did.
Offline  
Old 04-19-2008, 09:20 PM   #10 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by BB Junkie View Post
Found the solution to this problem. I had to add this command line:

BBDBUpdate.exe -db <db name> -n <server name> -input EnableRichContent.sql
and it worked! I was able to receive html emails now. Hope that helps for anyone who has the same issue as I did.
Were you not running this on the BES / SQL Server?
Offline  
Old 04-19-2008, 09:29 PM   #11 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
Were you not running this on the BES / SQL Server?
I used SQL Express edition or MSDE that comes with the BES 4.1.5 installer on the same machine. I dont have full blown MS SQL server.
Offline  
Old 04-19-2008, 09:32 PM   #12 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by BB Junkie View Post
I used SQL Express edition or MSDE that comes with the BES 4.1.5 installer on the same machine. I dont have full blown MS SQL server.
hmn ... and it was installed as the Default instance?
Offline  
Old 04-19-2008, 09:33 PM   #13 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
hmn ... and it was installed as the Default instance?
Yes, thats correct.
Offline  
Old 04-20-2008, 11:04 AM   #14 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

I have modified the command-line example to include server name. I don't think SQL 2005 Express changed anything to not process localhost queries, but perhaps it may have. I forgot to take into account remote SQL databases anyhow (I used an 'all under the hood' environment for test, as well).
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 04-21-2008, 06:08 AM   #15 (permalink)
Thumbs Must Hurt
 
Dookie's Avatar
 
Join Date: Oct 2005
Location: Prague
Model: 9000
Carrier: T-Mo
Posts: 175
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Really good job, Jibi! Thanks for that. I have it on my test server and i'm keeping it quiet in our company
At least i know what to expect - user's are asking me when SP6 or BES 5 will be released ...
__________________
How come that the BlackBerry won't last long for me?
7290 -> 8700g -> 7130g -> 8100 -> 8300 -> 8110 -> 8310 -> 9000 ... who will be next?
Offline  
Old 04-21-2008, 09:10 AM   #16 (permalink)
CrackBerry Addict
 
Join Date: Oct 2004
Model: 9800
OS: 6.0.0.337
Carrier: (`.at&t.)
Posts: 825
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by BBAdmin View Post
I would assume yes but I couldn't help you.

Just to elaborate slightly on J's point, the reason it was pulled was due to processor load on the Exchange Server in large environments where companies were sending out distribution wide HTML emails at once. I can't see how they're going to get around this in future releases as all roads lead to the Exchange Server, but I suspect they will figure something out.
I'm confused as to why the exch server cpu would get hit and not the bes server? Isn't the bes getting the emails the same as any outlook client? It gets html emails now its just the client doesn't display them as such. I would think the client (BB) just needs to know how to translate html...
Offline  
Old 04-22-2008, 06:53 PM   #17 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey, I was able to get HTML content working ok on 8310 with 4.5.0.18 beta. I was able to see html content when i receive it, however, if I request for more or more all, I get an error message: HTML Content is not enabled. Would you like to switch to plain text?

What did I do wrong?

Thanks for the help!
Offline  
Old 04-22-2008, 07:48 PM   #18 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by Inphektion View Post
I'm confused as to why the exch server cpu would get hit and not the bes server? Isn't the bes getting the emails the same as any outlook client? It gets html emails now its just the client doesn't display them as such. I would think the client (BB) just needs to know how to translate html...
It only gets 2KB of the message. This was fine for Plain Text, but obviously much different for HTML (in some cases).
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 04-22-2008, 07:53 PM   #19 (permalink)
Retired BBF Moderator
 
Sith_Apprentice's Avatar
 
Join Date: Aug 2005
Model: 9000
OS: 4.6.0.xxx
Carrier: AT&T
Posts: 10,149
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

it would be amusing to get the first 2kb of an email in HTML. it would be like old dialup modems on a content rich page, loading line by line.

do we know how much of the email is sent via HTML? Plain text is 2kb

Last edited by Sith_Apprentice : 04-22-2008 at 07:56 PM.
Offline  
Old 04-22-2008, 10:11 PM   #20 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Sith, I believe it depends on your options that are set on the BES and device (auto-download of images/rich content), but I could be wrong.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Dayton Three Phase Motor 1750 RPM, 208-220/440 Voltage Frame 184 Cat # M3615T
$309.99
Dayton Three Phase Motor 1750 RPM, 208-220/440 Voltage Frame 184 Cat # M3615T pictureVariac Auto Transformer AC Variable Voltage Regulator Metered (500W 5 Amp) BP
$38.99
Variac Auto Transformer AC Variable Voltage Regulator Metered (500W 5 Amp) BP pictureKing Electric ES230-R Electronic Line Voltage 208/240V Thermostat (ES-230)
$9.95
King Electric ES230-R Electronic Line Voltage 208/240V Thermostat (ES-230) pictureFLUKE VOLT ALERT 1AC-A II CAT IV 1000V NON CONTACT VOLTAGE DETECTOR
$20.0
FLUKE VOLT ALERT 1AC-A II CAT IV 1000V NON CONTACT VOLTAGE DETECTOR pictureGenerac 84132GS Generator Voltage Regulator
$80.3
Generac 84132GS Generator Voltage Regulator picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.