Manage Email Signatures Centrally - For All Users

metropolitanhotel · Just can't stay away Joined: 25 Jul 2007 Posts: 22

I'm troubleshooting a few clients that don't seem to run the sign.exe program and it would be very useful to have a text log file of what happened when sing.exe ran.

I know you can turn on the debug mode in the registry, but that requires access to the machine to see the pop-up window. You can also see it in the cockpit, but the problem i'm having is that people are not coming up in the cockpit, even though my login script is triggering sign.exe to run.

Any advice?

Bjarne Mess · Posted: Thu Sep 20, 2007 10:48 pm Post subject:

In that case there is nothing more to do to force the log screen to show. I'm pretty sure that the connection string is not correct and hence not able to find the database.

Please try upgrade the MDAC on those PCs if it is a data write issue. Otherwise log on as a user with local admin rights and check the registry under HKEY_USERS.
_________________
</Bjarne> | Test Email Signature | Showcase |

Jesper Frier · Posted: Fri Sep 21, 2007 5:26 am Post subject: Sign.exe

Or try moving Sign.exe to the very end of your logon script ...

metropolitanhotel · Just can't stay away Joined: 25 Jul 2007 Posts: 22

OK, so I've come to the point of deploying my new signatures and this problem has arisen again. This time I have spent a great amount of time trying to pinpoint what is happening and have some screenshots to help get to the bottom of it (i hope!)

So here's the setup:

I recently moved emailsignature to use SQL as I thought maybe access was to blame. It runs faster now which is great, but this problem is still occuring

I have a login script written in VBscript that uses code I found in another post on this forum, which essentially launces the following code in the shell:
\\domain\netlogon\utils\sign.exe Provider=sqloledb;Data Source=ukmet024;Initial Catalog=EmailSignature;User Id=EmailSigUser;Password=s1gs1g;

The Login script is deployed using GPO. I have a policy tied to the OU for each site I want to deploy signatures. The script runs fine, and I have another setting in the GPO that forces the PC to run the script even if it detects a slow link.

I have moved the execution of sign.exe right to the end of my script. It calls two other executables before sign.exe and the script is 10 pages long, so this is about as late as I can run it Wink

I have seen this problem occur on machines running XP service pack 1 and 2. The MDAC version on SP2 is the latest - 2.8. I have confirmed this on the affected machines using the MDAC compatibility checker.

I wanted to confirm sign.exe was actually being launched, so I've enabled process tracking via GPO and tested one of the affected machines. Here are the results:

User logs in and login script log file tells me sign.exe ran successfully:

Event Viewer tells me sign.exe did in fact run:

However the user's signature is not updated, cockpit shows that they haven't run the sign.exe since 30/10, and the registry of the PC shows this as well:

Now, after confirming all of this, I re-run the login script from a run command and it updates perfectly. So something in sign.exe is not happy about being run at login. I had previously suspected it might have been unhappy about connecting to the access database, but it's now on SQL so that can't be the issue.

Sorry for the essay, but I really need to get to the bottom of this problem. I'm at the stage now where my only option may be to use my scripts to deploy batch files to the startup folder on each PC and see if that works. I do hope however that that isn't the only option.

Thanks for your continuing support :D

Jesper Frier · Posted: Mon Nov 12, 2007 2:35 pm Post subject: Debug

Please run the client in Debug mode found in the Tools section of this forum, and post the log here ...

If the log is OK (read the last line), then please have the client manually run Sign.exe from below one line bat-file. This will show where to troubleshoot ... Confused

Create the correct line from Cockpit deployment menu -> Item 3 ...

metropolitanhotel · Just can't stay away Joined: 25 Jul 2007 Posts: 22

But the problem is that if sign.exe is launched at logon, the debug window doesn't open either, suggesting an abnormal termination of sign.exe before it is finished. Here is a screeenshot from a machine with debug enabled:

Sign.exe was run at 15:55 as shown in my log and the event log, but the LastRun registry value stayed the same, and no debug window came up.

Jesper Frier · Posted: Tue Nov 13, 2007 5:54 am Post subject: Debug

I would like to see a OK debug, before giving you further advise.

In Debug client (item 2) just execute the link to our Sign.exe - or your own Sign.exe (but not to the bat-file, vb-script or GPO executing Sign.exe - only Sign.exe ...)

This must open the debug window so you can copy to this post. Don't execute sign.exe using your script as your script might be the reason for the problem.

If you cannot make it work, please contact me for remote assistance.

metropolitanhotel · Just can't stay away Joined: 25 Jul 2007 Posts: 22

No worries, here is the output from when it is run from the bat file after login:

---------------- eMailSignature LOG file -------------------
- Started at 13/11/2007 09:34:38
- sign.exe version 4.9.1 has been run for this user.
------------------------------------------------------------

Connection string to settings database:
Provider=sqloledb;Data Source=ukmet024;Initial Catalog=EmailSignature;User Id=EmailSigUser;Password=s1gs1g;
13/11/2007 09:34:38 Begin finding user DN
User path: LDAP://DC=como,DC=local
13/11/2007 09:34:38 End Finddistinguishedname
User: it-testing (CN=IT Testing,OU=Dept_IT,OU=Metropolitan Hotel,DC=como,DC=local)
13/11/2007 09:34:38 License Key valid. Licensed version detected. No modules. License issued to Metropolitan Hotel for 600 users.
Distinguished name set to CN=IT Testing,OU=Dept_IT,OU=Metropolitan Hotel,DC=como,DC=local

------------------- Signatures to deploy: -------------------
Default signature: Met Standard 2.0
Reply/forward signature: Met Standard 2.0
Signatures to deploy: Met Standard 2.0
Origin ID (Internal): 1

-------------------------------------------------------------
Office version 2003 detected.
1 signature to deploy.

-> Signature Met Standard 2.0 in htm format (13/11/2007 09:34:3 Cool

Number of parameters in signature: 5
Data will be read from Active Directory
Root context for it-testing: LDAP://DC=como,DC=local
Signature source:
((Display_name)) ((Title))   Metropolitan Hotel 19 Old Park Lane London W1K 1LB   
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD width=110>Direct Tel:</TD>
<TD>((Telephone_number))</TD></TR>
<TR>
<TD>Direct Fax:</TD>
<TD>((Fax_number))</TD></TR>
<TR>
<TD>E-mail:</TD>
<TD>((E-mail))</TD></TR>
<TR>
<TD>Website:</TD>
<TD>metropolitan.como.bz</TD></TR></TBODY></TABLE>  PART OF THE COMO GROUP <A href="http://www.como.bz/"><IMG src="newfooter_como.jpg" border=0></A> Please help save paper and the environment - do you need to print this email?  

Signature result:
IT Testing IT Testing Account   Metropolitan Hotel 19 Old Park Lane London W1K 1LB   
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD width=110>Direct Tel:</TD>
<TD>+44 (0)20 7447 1050</TD></TR>
<TR>
<TD>Direct Fax:</TD>
<TD>+44 (0)20 7447 1043</TD></TR>
<TR>
<TD>E-mail:</TD>
<TD>it-testing@como.bz</TD></TR>
<TR>
<TD>Website:</TD>
<TD>metropolitan.como.bz</TD></TR></TBODY></TABLE>  PART OF THE COMO GROUP <A href="http://www.como.bz/"><IMG src="newfooter_como.jpg" border=0></A> Please help save paper and the environment - do you need to print this email?  

-> Signature Met Standard 2.0 in rtf format (13/11/2007 09:34:3 Cool

Number of parameters in signature: 5
Data will be read from Active Directory
Root context for it-testing: LDAP://DC=como,DC=local
Signature source:
{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss\fprq2\fcharset0 Verdana;}}
{\colortbl ;\red0\green0\blue0;}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\par \f0\fs20 \par
\cf1 ((Display_name))\par
((Title))\par
\par
Metropolitan Hotel\par
19 Old Park Lane\par
London\par
W1K 1LB\par
\par
Direct Tel:\tab ((Telephone_number))\par
Direct Fax:\tab ((Fax_number))\par
E-mail:\tab\tab ((E-mail))\par
Website:\tab metropolitan.como.bz\par
\par
PART OF THE COMO GROUP\par
\cf0 \par
\fs16 Please help save paper and the environment - do you need to print this email?\fs20\par
\par
}

Signature result:
{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss\fprq2\fcharset0 Verdana;}}
{\colortbl ;\red0\green0\blue0;}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\par \f0\fs20 \par
\cf1 IT Testing\par
IT Testing Account\par
\par
Metropolitan Hotel\par
19 Old Park Lane\par
London\par
W1K 1LB\par
\par
Direct Tel:\tab +44 (0)20 7447 1050\par
Direct Fax:\tab +44 (0)20 7447 1043\par
E-mail:\tab\tab it-testing@como.bz\par
Website:\tab metropolitan.como.bz\par
\par
PART OF THE COMO GROUP\par
\cf0 \par
\fs16 Please help save paper and the environment - do you need to print this email?\fs20\par
\par
}

-> Signature Met Standard 2.0 in txt format (13/11/2007 09:34:3 Cool

Number of parameters in signature: 5
Data will be read from Active Directory
Root context for it-testing: LDAP://DC=como,DC=local
Signature source:
((Display_name))
((Title))

Metropolitan Hotel
19 Old Park Lane
London
W1K 1LB

Direct Tel: ((Telephone_number))
Direct Fax: ((Fax_number))
E-mail: ((E-mail))
Website: metropolitan.como.bz

PART OF THE COMO GROUP

Please help save paper and the environment - do you need to print this email?

Signature result:
IT Testing
IT Testing Account

Metropolitan Hotel
19 Old Park Lane
London
W1K 1LB

Direct Tel: +44 (0)20 7447 1050
Direct Fax: +44 (0)20 7447 1043
E-mail: it-testing@como.bz
Website: metropolitan.como.bz

PART OF THE COMO GROUP

Please help save paper and the environment - do you need to print this email?

------------------------------------------------------------
Word as Editor is accepted. Default mail editor is left unchanged.
Stationery deleted.
Office version 2003: Stationary Removed.
Office version 2003: Send font set to Verdana.
Office version 2003: Reply font set to Verdana.
Office version 2003: Plain Text font reset.
Default Profile: Outlook
Profile 1, Outlook 2003: New Signature set to Met Standard 2.0
Profile 3, Outlook 2003: New Signature set to Met Standard 2.0
Outlook settings changed successfully.
The following pictures will be copied to Outlook:
c:\program files\office add-on\eMailSignature\oao_logo.gif copied to Outlook
\\Como.local\netlogon\Images\newfooter_como.jpg copied to Outlook
-------------- eMailSignature END LOG file -----------------
- Finalised at 13/11/2007 09:34:38
------------------------------------------------------------
Status: OK

metropolitanhotel · Just can't stay away Joined: 25 Jul 2007 Posts: 22

Interestingly enough, here is the log produced when I run it through my script AFTER login:

---------------- eMailSignature LOG file -------------------
- Started at 13/11/2007 09:34:38
- sign.exe version 4.9.1 has been run for this user.
------------------------------------------------------------

Connection string to settings database:
Provider=sqloledb;Data Source=ukmet024;Initial Catalog=EmailSignature;User Id=EmailSigUser;Password=s1gs1g;
13/11/2007 09:34:38 Begin finding user DN
User path: LDAP://DC=como,DC=local
13/11/2007 09:34:38 End Finddistinguishedname
User: it-testing (CN=IT Testing,OU=Dept_IT,OU=Metropolitan Hotel,DC=como,DC=local)
13/11/2007 09:34:38 License Key valid. Licensed version detected. No modules. License issued to Metropolitan Hotel for 600 users.
Distinguished name set to CN=IT Testing,OU=Dept_IT,OU=Metropolitan Hotel,DC=como,DC=local

------------------- Signatures to deploy: -------------------
Default signature: Met Standard 2.0
Reply/forward signature: Met Standard 2.0
Signatures to deploy: Met Standard 2.0
Origin ID (Internal): 1

-------------------------------------------------------------
Office version 2003 detected.
1 signature to deploy.

-> Signature Met Standard 2.0 in htm format (13/11/2007 09:34:3 Cool

Number of parameters in signature: 5
Data will be read from Active Directory
Root context for it-testing: LDAP://DC=como,DC=local
Signature source:
((Display_name)) ((Title))   Metropolitan Hotel 19 Old Park Lane London W1K 1LB   
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD width=110>Direct Tel:</TD>
<TD>((Telephone_number))</TD></TR>
<TR>
<TD>Direct Fax:</TD>
<TD>((Fax_number))</TD></TR>
<TR>
<TD>E-mail:</TD>
<TD>((E-mail))</TD></TR>
<TR>
<TD>Website:</TD>
<TD>metropolitan.como.bz</TD></TR></TBODY></TABLE>  PART OF THE COMO GROUP <A href="http://www.como.bz/"><IMG src="newfooter_como.jpg" border=0></A> Please help save paper and the environment - do you need to print this email?  

Signature result:
IT Testing IT Testing Account   Metropolitan Hotel 19 Old Park Lane London W1K 1LB   
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD width=110>Direct Tel:</TD>
<TD>+44 (0)20 7447 1050</TD></TR>
<TR>
<TD>Direct Fax:</TD>
<TD>+44 (0)20 7447 1043</TD></TR>
<TR>
<TD>E-mail:</TD>
<TD>it-testing@como.bz</TD></TR>
<TR>
<TD>Website:</TD>
<TD>metropolitan.como.bz</TD></TR></TBODY></TABLE>  PART OF THE COMO GROUP <A href="http://www.como.bz/"><IMG src="newfooter_como.jpg" border=0></A> Please help save paper and the environment - do you need to print this email?  

-> Signature Met Standard 2.0 in rtf format (13/11/2007 09:34:3 Cool

Number of parameters in signature: 5
Data will be read from Active Directory
Root context for it-testing: LDAP://DC=como,DC=local
Signature source:
{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss\fprq2\fcharset0 Verdana;}}
{\colortbl ;\red0\green0\blue0;}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\par \f0\fs20 \par
\cf1 ((Display_name))\par
((Title))\par
\par
Metropolitan Hotel\par
19 Old Park Lane\par
London\par
W1K 1LB\par
\par
Direct Tel:\tab ((Telephone_number))\par
Direct Fax:\tab ((Fax_number))\par
E-mail:\tab\tab ((E-mail))\par
Website:\tab metropolitan.como.bz\par
\par
PART OF THE COMO GROUP\par
\cf0 \par
\fs16 Please help save paper and the environment - do you need to print this email?\fs20\par
\par
}

Signature result:
{\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss\fprq2\fcharset0 Verdana;}}
{\colortbl ;\red0\green0\blue0;}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\par \f0\fs20 \par
\cf1 IT Testing\par
IT Testing Account\par
\par
Metropolitan Hotel\par
19 Old Park Lane\par
London\par
W1K 1LB\par
\par
Direct Tel:\tab +44 (0)20 7447 1050\par
Direct Fax:\tab +44 (0)20 7447 1043\par
E-mail:\tab\tab it-testing@como.bz\par
Website:\tab metropolitan.como.bz\par
\par
PART OF THE COMO GROUP\par
\cf0 \par
\fs16 Please help save paper and the environment - do you need to print this email?\fs20\par
\par
}

-> Signature Met Standard 2.0 in txt format (13/11/2007 09:34:3 Cool

Number of parameters in signature: 5
Data will be read from Active Directory
Root context for it-testing: LDAP://DC=como,DC=local
Signature source:
((Display_name))
((Title))

Metropolitan Hotel
19 Old Park Lane
London
W1K 1LB

Direct Tel: ((Telephone_number))
Direct Fax: ((Fax_number))
E-mail: ((E-mail))
Website: metropolitan.como.bz

PART OF THE COMO GROUP

Please help save paper and the environment - do you need to print this email?

Signature result:
IT Testing
IT Testing Account

Metropolitan Hotel
19 Old Park Lane
London
W1K 1LB

Direct Tel: +44 (0)20 7447 1050
Direct Fax: +44 (0)20 7447 1043
E-mail: it-testing@como.bz
Website: metropolitan.como.bz

PART OF THE COMO GROUP

Please help save paper and the environment - do you need to print this email?

------------------------------------------------------------
Word as Editor is accepted. Default mail editor is left unchanged.
Stationery deleted.
Office version 2003: Stationary Removed.
Office version 2003: Send font set to Verdana.
Office version 2003: Reply font set to Verdana.
Office version 2003: Plain Text font reset.
Default Profile: Outlook
Profile 1, Outlook 2003: New Signature set to Met Standard 2.0
Profile 3, Outlook 2003: New Signature set to Met Standard 2.0
Outlook settings changed successfully.
The following pictures will be copied to Outlook:
c:\program files\office add-on\eMailSignature\oao_logo.gif copied to Outlook
\\Como.local\netlogon\Images\newfooter_como.jpg copied to Outlook
-------------- eMailSignature END LOG file -----------------
- Finalised at 13/11/2007 09:34:38
------------------------------------------------------------
Status: OK

The problem is only ever when it is triggered as a login script.

Jesper Frier · Posted: Tue Nov 13, 2007 10:14 am Post subject:

Please let me have your views on my conclusion ... Cool

Summary
Some clients don't get signatures delivered.
Those clients don't execute Sign.exe.
No debug errors on clients.
Your script deploy signatures when executed manually.

Conclusion
You must troubleshoot your script used during logon or try and execute default Cockpit bat-file for all users:

Please create the correct line from Cockpit deployment menu (item 3):

metropolitanhotel · Just can't stay away Joined: 25 Jul 2007 Posts: 22

There does indeed seem to be a problem with login scripts in general, as further testing has shown. However I have made adjustments to my script that copies the batch file to each user's startup folder. I'm actually happier with this because now I can simply ask users to click on this link to update changes without having to re-log.

Thanks again for your terrific support :D