Plugin is not working after updating from 1.6.2 to 1.7

Hi guys,

This is the continuation to my posts in sept 2014. We have updated to 1.7 but our plugin ceased to work. I have log the entry and exit points of the methods in the plugin’s main.cfc file, and it enters the db function but doesn’t leave it, neither enters into the load function that registers our logic into the Razuna hooks. This tells me that that’s why the plugin doesn’t work.

Now, upon leaving the db function I have a SQL Exception telling me that the db-table for the plugin already exists.

   Entering db function
+-----------------+--
|            type | Database
|          detail | Database reported: Table 'raz1_lturnotify' already exists
|         message | General SQL Error
|       errorcode | errorCode.sqlError
|    extendedinfo |
|      tagcontext | {CFML Type::array}
|             sql | CREATE TABLE raz1_lturnotify
                        (
                                callback_url    varchar(500)
                        )
                        ENGINE=InnoDB CHARACTER SET
| nativeerrorcode | 1050
|        sqlstate | 42S01
|      queryError | Table 'raz1_lturnotify' already exists
|      datasource | MYSQL
|         tagname | CFQUERY
|        template | /usr/local/razuna_1_7/webapps/razuna/global/plugins/ltur/cfc/main.cfc
|            line | 58
|          column | 4
+-----------------+--

By the way, Razuna seems to be working alright, I can add, remove, and search my assets, so I get SQL-update went fine.

I have tried to manually carry DROP TABLE raz1_lturnotify with the razuna SQL user, but it seems it doesn’t have the privilege to do it remotely. So, should I really try to drop the table? I bet there is a good reason it is not suppose to, I before I do something stupid, I wanted to check with you guys.

Now I have also notice that the WEB-INF/bluedragon/work/cflog/application.log is missing, but instead there a new logs/Catalina.out. We logged onto the application.log file and that’s how we notice. Was there a change in the logging system? I checked with our administrator who update to 1.7 and he says he did not change anything on the logging. Whlle I get the plugin to work again I’m logging onto the Catalina.out. How can I set up a logging back to the application.log file?

As always, thanks a bunch! You guys are heroes and I love Razuna!

– Juan Pablo

Hi,

We did not change the log. This is controlled by Tomcat and not Razuna.

Regarding the plugin, I can’t help you much here as I don’t know what you
are doing. You need to activate the plugin and assign it to a host in the
backend and see that it works. Maybe you forgot to do that?

Hi Nitai,

Thank you for quick reply. I feel stupid! To all of you developing a Razuna Plugin! It is not enough to activate it! You have to assign to a host:

http://wiki.razuna.com/display/ecp/Installing+and+activating+a+plugin

Case closed!

Thank you so much! I’m looking forward to Razuna 2.0! :smiley:

– Juan Pablo

UPDATE After I successfully started the plugin, the application.log is there.