Export all SMTP address into a CSV from Exchange 2007 and 2010 (PowerShell)

Posted on June 14, 2012 by J

In the Exchange Power Shell :

Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | Export-Csv c:smtp.csv –NoTypeInformation

The file smtp.csv will be located in c:

You might want to change the path.

Sage CRM 7.0, 7.1 and Complete Sage Accpac Integration

Posted on June 14, 2012 by J

Hi,

For freak security users like me 🙂 This is the required open port if you deploy on a Web Server Sage CRM 7.x and a complete Sage Accpac Integration.

Sage CRM=> Default Port 80 and 443, depending on what port you are using for HTTP and HTTPs.
Sage Accpac Web Deploy (Open OE/AR windows from CRM) => Default Port 9000-9180 and can be expanded during web deployment setup. Accpac opens one port per UI opened.

Crystal Web Reporting (Print OE from CRM) => default port 80.

Sage Accpac Portal => whatever HTTP you are using, plus 10015 (server) and 10020 (AJP).

More information after the break

Thanks,

Sage Accpac ERP 300 or ERP 200 – 100 – 500 or Version 6.0 5.6 5.5

Posted on June 14, 2012 by J

Hi,

If you have a customer and they want to implement SQL replication on a Sage Accpac Database (please check the title for all the possible version, change doesn’t change their product name often :S )

They might received an error the table A4WCHARORDER cannot be added to the replication because it doesn’t have a PK (Primary Key). All the table can be replicated except the A4WCHARORDER.

According to Sage Senior support Team :

Sage 300 generates this table A4WCHARORDER if it doesn’t exist. So this is not important to backup.
To clarify, it is still actively used to “figure how the database collation sort between min and max characters”.

Sage support “One Way” Replication not Both Way….. This is by design…

Thanks,

Sage CRM 7.0 / 7.1 Http Error 503 Service Unavailable

Posted on May 29, 2012 by J

When you install Sage CRM 7.0 and 7.1 on 2008 R2 or SBS 2011 you might have issue : http error 503 service unavailable.

You will notice the CRM App Pool and the CRMRewriter App pool is stopped.

In the Event log you will have an event id : 2282

IIS-W3SV-WP

The module DLL ‘C:program filesMicrosoftExchanger ServerV14Binkerbauth.dll’ could not be loaded due to a configuration problem. The current configuration only supports loading images built for a x86 processor architecture.

This might occurred with several DLL.

The kerbauth.dll only work 64 bit.

In the applicationHost.config file for IIS (located in C:WindowsSystem32inetsrvconfig). Stop IIS and edited the file. In the globalModules section, add at the end of the line for kerbauth, and added the precondition=”bitness64” attribute as follows:

Those DLL might need the same :

Both were listed in the <isapiFilters> section of the applicationHost.config file:

Restart IIS and CRM.

Horde Session Error

Posted on April 25, 2012 by J

If you received an error when you open Horde email client :

A fatal error has occurred
Session cookies will not work without a FQDN and with a non-empty cookie domain. Either use a fully qualified domain name like “http://www.example.com” instead of “http://example” only, or set the cookie domain in the Horde configuration to an empty value, or enable non-cookie (url-based) sessions in the Horde configuration.
Details have been logged for the administrator.

In the file :
/usr/local/cpanel/base/horde/config/conf.php

Change the value for $conf[‘session’][‘usr_only_cookies’] = false