Can't Configure GMaps Zimlet

[carnold]

Using OSS 5.0.16 and have gotten the inova_gmaps zimlet in the zimbra/zimlets folder and ran the zmzimletctl deploy command and everything seems to be fine there. When running:
zmzimletctl configure config.xml net_inova_gmaps
[] INFO: Configure zimlet on mail.electrichendrix.com
[] ERROR: Error
com.zimbra.common.soap.SoapFaultException: system failure: cannot configure
ExceptionId:btpool0-49:1246905792255:1f2e4020cf07c700
Code:service.FAILURE
at com.zimbra.common.soap.Soap12Protocol.soapFault(So ap12Protocol.java:88)
at com.zimbra.common.soap.SoapTransport.extractBodyEl ement(SoapTransport.java:263)
at com.zimbra.common.soap.SoapTransport.parseSoapResp onse(SoapTransport.java:224)
at com.zimbra.common.soap.SoapHttpTransport.invoke(So apHttpTransport.java:277)
at com.zimbra.common.soap.SoapHttpTransport.invoke(So apHttpTransport.java:226)
at com.zimbra.common.soap.SoapTransport.invoke(SoapTr ansport.java:315)
at com.zimbra.common.soap.SoapTransport.invoke(SoapTr ansport.java:279)
at com.zimbra.cs.zimlet.ZimletUtil$ZimletSoapUtil.soa pConfigureZimlet(ZimletUtil.java:1341)
at com.zimbra.cs.zimlet.ZimletUtil$ZimletSoapUtil.con figureZimletOnServer(ZimletUtil.java:1325)
at com.zimbra.cs.zimlet.ZimletUtil$ZimletSoapUtil.con figureZimlet(ZimletUtil.java:1208)
at com.zimbra.cs.zimlet.ZimletUtil.dispatch(ZimletUti l.java:1597)
at com.zimbra.cs.zimlet.ZimletUtil.main(ZimletUtil.ja va:1641)

I have followed the readme, i thought, exactly. I do get confused where the readme says to Create a file with the following lines and replace the values for dbhost, dbuser, dbpass, dbname and baseCountry (i understand the dbhost, dbuser, dbpass, dbname and baseCountry part) but it does not say what name to give this file? A little further down and the readme says to run zmzimletctl configure config.xml net_inova_gmaps so i assume the file name should be config.xml? I am also unsure where i need to be running this command from, i.e what directory (zimlets or does it matter?)? Like i said, i have the zimlet deployd and the admin interface sees the zimlet. I have the api key. I have created a DB for this map and have populated a table with said key. Can anyone help?

I also wanted to mention that the mysql DB is a separate DB from the zimbra mysql DB and that DB has a password with special characters. Does it handle passwords with special characters?

[mosca.br]

It should handle the spectial characters fine, as long as it is properly escaped in the xml file.

You can try to use a xml editor so it escapes the characters for you, or you can change the password to a simpler one and test it.

[carnold]

It should handle the spectial characters fine, as long as it is properly escaped in the xml file.

How do you properly escape the characters? I used [] around the special character and reran zmzimletctl configure config.xml net_inova_gmaps and get an error (it looks to be the same error)

You can try to use a xml editor so it escapes the characters for you, or you can change the password to a simpler one and test it.

I changed to a simpler password and still get the error. What about the other questions:
-what name to give this file or if it matter what name
-where i need to be running this command from, i.e what directory (zimlets or does it matter?)
-the mysql DB is not the mysql DB that zimbra uses, does this matter?

[mosca.br]

How do you properly escape the characters? I used [] around the special character and reran zmzimletctl configure config.xml net_inova_gmaps and get an error (it looks to be the same error)

I changed to a simpler password and still get the error. What about the other questions:
-what name to give this file or if it matter what name
-where i need to be running this command from, i.e what directory (zimlets or does it matter?)
-the mysql DB is not the mysql DB that zimbra uses, does this matter?

That error implies that the server is refusing the xml file, probably because of a broken syntax. You should convert your special characters to xml entities.

What special characters are you using?

I just tested with this simple file and it worked:

<zimletConfig name="Net_Inova_GMaps" version="1.0">
        <global>
                <property name="allowedDomains">*.google.com,*.inova.com.br,*.inova.net</property>
                <property name="dbhost">retirante</property>
                <property name="dbuser">gmaps</property>
                <property name="dbpass">gmaps</property>
                <property name="dbname">gmaps</property>
                <property name="baseCountry">br</property>
                <property name="markerIcon">http://maps.google.com/intl/en_ALL/mapfiles/marker.png</property>
                <property name="markerIconW">20</property>
                <property name="markerIconH">34</property>
                <property name="markerIconAnchorX">13</property>
                <property name="markerIconAnchorY">35</property>
        </global>
</zimletConfig>

As for the other questions:
- The name of the file does not matter at all.
- The command should be run from a mailbox server, with the zimbra user. The directory itself, does not matter, as long as the config file is in the same directory.
- The zimlet does not care where the mysql is, but the machine running the mailbox server must be able to connect to that mysql server with the provided credentials.

[carnold]

The special character is <
I have this in the file, [<] but it still chokes on it. Don't have a xml editor on this server. How do you properly escape that character?

[mosca.br]

Probably, the easier way to escape your password it to place it inside a CDATA secion.

Something along the lines of:

<property name="dbpass"><![CDATA[Your complex mysql password here]]></property>

[carnold]

That was the first thing i tried and it would not work. What did work was &lt;
So i sent myself a message with an address and hover my mouse over it but nothing happens. Do you have to restart the mailbox?

[mosca.br]

Have you checked if the Zimlet is enabled for that account cos?

The Zimlet will also show on the Zimlet list, under the folders on the webclient.

If it shows up, but the address was not highlighted, you may need to change the regexps provided so that it can match the address style in your country.

You can easily add your own regexps to net_inova_gmaps.js arround line 102.

It will support the same regexp used by the Yahoo Maps! Zimlet and Brazilian style addresses out of the box.

If you do change the regexps, please share them here and I'll include it on the Zimlet published on the Gallery

[carnold]

Have you checked if the Zimlet is enabled for that account cos?

Not exactly sure how to see if it is enabled

The Zimlet will also show on the Zimlet list, under the folders on the webclient.

It does show up in that list

If it shows up, but the address was not highlighted, you may need to change the regexps provided so that it can match the address style in your country.

It does highlight just the popup says cant find API for domain. I looked back at the google account and copied the key into the mysql DB table. Still says key not found
When you click on the address that is highlighted, it does bring up the google maps of that address. Seems like it works when you click the link but not when you hover over the link/address.
Oh, the map that comes up is from google brazil. The config file says US?

[mosca.br]

Not exactly sure how to see if it is enabled

It does show up in that list


It does highlight just the popup says cant find API for domain. I looked back at the google account and copied the key into the mysql DB table. Still says key not found
When you click on the address that is highlighted, it does bring up the google maps of that address. Seems like it works when you click the link but not when you hover over the link/address.
Oh, the map that comes up is from google brazil. The config file says US?

Are you sure the credentials for the mysql database are correct?

Try the attached version, as I added the possibility to show some debug information to the dialog box.

Update the zimlet and add

<property name="enableDebug">TRUE</property>

to the config.xml. You may need to restart your mailbox process after updating the Zimlet.

If debugging is enabled and there is any problem connecting to the mysql server, it will display the exception under the "key not found" message.

You can also easily check if the Zimlet is setup correctly by accessing the jsp it uses to display the google maps output directly, like this:

http://your.public.service.hostname....C3%A3o%20Paulo

If you go to this url directly, you can also view source to check what the Zimlet thinks is your baseCountry and the API host it is looking for in the keymap table.

They will both be inside a comment block in the html source, like this:

<!--
Base Country: us
DB Host: retirante
-->

I'll probably update the README file with the result of this discussion. Better documentation never hurts!