Manage Email Signatures Centrally - For All Users

TripleD · Posted: Thu Oct 30, 2008 10:03 am Post subject: OWA Signature Updates

Hi Guys,

I'm having a few problems with the OWA signature updates. Everything on the Outlook side is fine. But it seems like the OWA signatures aren't being updated.

I've run the signowa -v and it's returning http/1.1 200 OK for everyone.

I've recently updated the campaign which made me look, and OW is still using the old campaign, also I've changed someone's job title, and that's not populated across into OWA.

Any ideas why it's now deciding not to work?

I'm running the latest version of the cockpit (V5.0) and the latest signOWA (V2.4.1.1)
_________________
?? can I not link this to my Office Addon product ?? Smile

Jesper Frier · Posted: Thu Oct 30, 2008 11:25 am Post subject:

SignOWA.exe will pull information from your settings DB and deploy to your Exchange Store. Thus, if the user did not run Sign.exe the settings DB is not updated and SignOWA.exe will deploy old data.

Is the Settingsdatabase in signOWA.reg the same as used in your Cockpit?

Please post log file for OWA (Help -> Diagnostics, right click user)?

________________

TripleD · Posted: Thu Oct 30, 2008 11:45 am Post subject:

I've just deleted my profile from the cockpit, then rebooted and re-run the sign.exe but my username is no longer being brought in. I also have another user that's not appearing!

It's all going wrong today Sad

Logfile output for on user:

HTTP/1.1 200 OK

That's all it says!
_________________
?? can I not link this to my Office Addon product ?? Smile

Jesper Frier · Posted: Thu Oct 30, 2008 12:04 pm Post subject:

You cannot deploy to OWA before user is OK in Cockpit Diagnostics.

Excute a simple bat-file (see examples below) and when OK in Diagnostics, then return to OWA.

Example using default Access settings DB:

TripleD · Posted: Thu Oct 30, 2008 12:22 pm Post subject:

No luck, tried running the sign.exe with all the gubbin's from my machine (it's W2008 acting as a workstation) thought that might be a problem, so run on an Windows XP machine, and still no luck.

It doesn't seem to like adding new people, and I'm only using half the licenses.

I'm wondering if it's worth backing up the Sig codes and trashing the DB and starting again?
_________________
?? can I not link this to my Office Addon product ?? Smile

Jesper Frier · Posted: Thu Oct 30, 2008 12:50 pm Post subject:

Please post the bat-file you execute.
_________________
</Jesper> | Test Email Signature | Showcase |

TripleD · Posted: Thu Oct 30, 2008 12:52 pm Post subject:

start \\easyuk-crm\NETLOGON\sign.exe Provider=sqloledb;Data Source=easyuk-crm;Initial Catalog=EmailSignature;User Id=sigadmin;Password=sigadmin;
_________________
?? can I not link this to my Office Addon product ?? Smile

Jesper Frier · Posted: Thu Oct 30, 2008 2:11 pm Post subject:

If Sign.exe exist on NETLOGON and your SQL user 'sigadmin' got the permissions described in the documentation section of this forum -
Then I cannot explain why Sign.exe will not write to the LgdaUsers table.

Please create a new SQL settings DB without changing the script.

Then connect your Cockpit to the new settings DB and test that your new logon script is OK in Diagnostics when executed:

TripleD · Posted: Thu Oct 30, 2008 2:16 pm Post subject:

Yup the latest version of sign.exe exists in NETLOGON, sigadmin has full ownership rights over the EmailSignature DB and is a full sys_admin user.

The thing is it must be working as I can change the campaign module and signatures and it gets rolled out to people. Just not in OWA and it won't accept new users.

I did upgrade the SQL from 2000 to 2005 but that was months ago. As the DB is pretty small I'll just back up the settings trash it, and recreate. Surprised

_________________
?? can I not link this to my Office Addon product ?? Smile

Jesper Frier · Posted: Thu Oct 30, 2008 2:35 pm Post subject:

When you cannot see users OK in Diagnostics, it does not work as entended - and as you cannot provide user log files, we cannot support you ... and you will never get OWA up and running, which is where it all started ...

Creating the SQL settings DB and testing logon script takes 10 min.
Then you copy/paste templates, setup deployment and General Outlook settings - another 30 min. maybe.
And you are done ... Nod

_________________
</Jesper> | Test Email Signature | Showcase |

TripleD · Posted: Thu Oct 30, 2008 2:49 pm Post subject:

Well one step forward,

Creating a new DB certainly helped, new users can be seen again, but I'm having problems pasting my old Signature back into the new version.

I keep getting the error "Multiple-step OLD DB operation generated errors. Check each OLD DB status value, if available. No work was done"
_________________
?? can I not link this to my Office Addon product ?? Smile

TripleD · Posted: Thu Oct 30, 2008 4:39 pm Post subject:

Ignore that just found this post:

http://www.emailsignature.eu/phpBB2/viewtopic,p,2633,highlight,ole++operation.html#2633
_________________
?? can I not link this to my Office Addon product ?? Smile

TripleD · Posted: Thu Oct 30, 2008 5:12 pm Post subject:

Okay,

All is now running after recreating the DB, removing and reinstalling EmailSignature.

Dunno what happened there ........ Cheers for your help Jesper Great

_________________
?? can I not link this to my Office Addon product ?? Smile