Page 1 of 2
CMS Not visible in admin after upgrade
Posted: Wed Feb 03, 2010 6:31 pm
by lord_alan
Any pointers?
I've upgraded our system from 5.5.1 to 6.0.1 using the manual method described in the README.txt file.
I've created (several times) the openemm_cms database using either the empty or the demo schema sql file.
I've checked the cms.properties file has the right url set on the cms.ccr.url line.
There is nothing obvious in any log files.
When I log in to the system, I do not have the Content Manager menu.
Everything else seems to be working just fine BTW.
TIA
Al
Posted: Wed Feb 03, 2010 9:40 pm
by maschoff
Did you update the database first from 5.5.1 to 6.0 and then from 6.0 to 6.0.1?
Is the new import wizard visible (new: profile management)?
Posted: Thu Feb 04, 2010 12:16 am
by lord_alan
Did you update the database first from 5.5.1 to 6.0 and then from 6.0 to 6.0.1?
Yes.
Is the new import wizard visible (new: profile management)?
In the recipients section? Yes.
Al
Posted: Thu Feb 04, 2010 8:32 am
by maschoff
Does your file sidemenu.properties contain these 3 lines at the end?
Code: Select all
msg_11=ContentManagement
href_11=/splash_cms.jsp
token_11=cms.central_content_management
Posted: Thu Feb 04, 2010 8:59 am
by lord_alan
Does your file sidemenu.properties contain these 3 lines at the end?
Code: Select all
msg_11=ContentManagement
href_11=/splash_cms.jsp
token_11=cms.central_content_management
Unfortunately yes. It does.
Posted: Thu Feb 04, 2010 9:08 am
by maschoff
That is really strange - So you have the item in the side menu but you can not see it? Or can you only not click on it?
When you launch OpenEMM do you have an error report in log file openemm_stdout.log?
Posted: Thu Feb 04, 2010 9:37 am
by lord_alan
Hi Martin,
No, the menu option in the sidebar is not present at all.
Here's a paste on the html source of the main admin screen
http://pastebin.com/m3171fc24
And I took a couple of screenshots just to prove it
The login screen:
http://twitpic.com/11b1vg
The main admin screen
http://twitpic.com/11b1yj
Thanks for helping to diagnose this.
Al
Posted: Thu Feb 04, 2010 9:47 am
by maschoff
Do you have the user rights for the CMS extension?
Have a look at table admin_group_permission_tbl:
Do you have entries for the two CMS permissions (field security token)?
Code: Select all
cms.central_content_management
cms.mailing_content_management
If so, what is the corresponding value in field admin_group_id?
Posted: Thu Feb 04, 2010 9:52 am
by lord_alan
Yes, they are both in the table.
Code: Select all
4 cms.central_content_management
4 cms.mailing_content_management
And all items in the table have the same admin_group_id: 4.
Weird.
Posted: Thu Feb 04, 2010 10:01 am
by lord_alan
ma wrote:When you launch OpenEMM do you have an error report in log file openemm_stdout.log?
No. There are the following log files in /home/openemm/var/log:
Code: Select all
/home/openemm/var/log$ ls -l
total 80
-rw-r--r-- 1 openemm openemm 104 2010-02-03 17:11 20100203-extbounce.log
-rw-r--r-- 1 openemm openemm 51 2010-02-03 17:10 20100203-tolc-bavd.log
-rw-r--r-- 1 openemm openemm 54 2010-02-03 17:10 20100203-tolc-bav-trigger.log
-rw-r--r-- 1 openemm openemm 14227 2010-02-03 23:58 20100203-tolc-bav-update.log
-rw-r--r-- 1 openemm openemm 151 2010-02-03 23:11 20100203-tolc-pickdist.log
-rw-r--r-- 1 openemm openemm 173 2010-02-03 17:10 20100203-tolc-recovery.log
-rw-r--r-- 1 openemm openemm 151 2010-02-03 23:10 20100203-tolc-slrtscn.log
-rw-r--r-- 1 openemm openemm 419 2010-02-03 23:12 20100203-tolc-update.log
-rw-r--r-- 1 openemm openemm 18156 2010-02-04 08:52 20100204-tolc-bav-update.log
-rw-r--r-- 1 openemm openemm 150 2010-02-04 08:11 20100204-tolc-pickdist.log
-rw-r--r-- 1 openemm openemm 150 2010-02-04 08:10 20100204-tolc-slrtscn.log
-rw-r--r-- 1 openemm openemm 150 2010-02-04 08:13 20100204-tolc-update.log
-rw-r--r-- 1 openemm openemm 3375 2010-02-03 22:47 velocity.log
I have noticed the following repeating error in the bav-update.log
Code: Select all
[04.02.2010 08:52:20] 8503 ERROR/data: Unable to read virtusertable (2, 'No such file or directory')
[04.02.2010 08:55:20] 8503 ERROR/data: Unable to read virtusertable (2, 'No such file or directory')
And in velocity.log is the following:
Code: Select all
2010-02-03 22:47:04,262 - SimpleLog4JLogSystem initialized using logfile '/home/openemm/var/log/velocity.log'
2010-02-03 22:47:04,262 - **************************************************************
2010-02-03 22:47:04,262 - Starting Jakarta Velocity v1.4
2010-02-03 22:47:04,262 - RuntimeInstance initializing.
2010-02-03 22:47:04,262 - Default Properties File: org/apache/velocity/runtime/defaults/velocity.properties
2010-02-03 22:47:04,262 - Trying to use logger class org.apache.velocity.runtime.log.AvalonLogSystem
2010-02-03 22:47:04,262 - Couldn't find class org.apache.velocity.runtime.log.AvalonLogSystem or necessary supporting classes in classpath. Exception : java.lang.NoClassDefFoundError: org/apache/log/format/Formatter
2010-02-03 22:47:04,263 - Trying to use logger class org.apache.velocity.runtime.log.SimpleLog4JLogSystem
2010-02-03 22:47:04,263 - Using logger class org.apache.velocity.runtime.log.SimpleLog4JLogSystem
2010-02-03 22:47:04,270 - Default ResourceManager initializing. (class org.apache.velocity.runtime.resource.ResourceManagerImpl)
2010-02-03 22:47:04,278 - Resource Loader Instantiated: org.apache.velocity.runtime.resource.loader.FileResourceLoader
2010-02-03 22:47:04,278 - FileResourceLoader : initialization starting.
2010-02-03 22:47:04,278 - FileResourceLoader : adding path '.'
2010-02-03 22:47:04,278 - FileResourceLoader : initialization complete.
2010-02-03 22:47:04,283 - ResourceCache : initialized. (class org.apache.velocity.runtime.resource.ResourceCacheImpl)
2010-02-03 22:47:04,283 - Default ResourceManager initialization complete.
2010-02-03 22:47:04,286 - Loaded System Directive: org.apache.velocity.runtime.directive.Literal
2010-02-03 22:47:04,291 - Loaded System Directive: org.apache.velocity.runtime.directive.Macro
2010-02-03 22:47:04,298 - Loaded System Directive: org.apache.velocity.runtime.directive.Parse
2010-02-03 22:47:04,316 - Loaded System Directive: org.apache.velocity.runtime.directive.Include
2010-02-03 22:47:04,319 - Loaded System Directive: org.apache.velocity.runtime.directive.Foreach
2010-02-03 22:47:04,387 - Created: 20 parsers.
2010-02-03 22:47:04,407 - Velocimacro : initialization starting.
2010-02-03 22:47:04,407 - Velocimacro : adding VMs from VM library template : VM_global_library.vm
2010-02-03 22:47:04,415 - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
2010-02-03 22:47:04,416 - Velocimacro : error using VM library template VM_global_library.vm : org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource 'VM_global_library.vm'
2010-02-03 22:47:04,416 - Velocimacro : VM library template macro registration complete.
2010-02-03 22:47:04,416 - Velocimacro : allowInline = true : VMs can be defined inline in templates
2010-02-03 22:47:04,416 - Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
2010-02-03 22:47:04,416 - Velocimacro : allowInlineLocal = false : VMs defined inline will be global in scope if allowed.
2010-02-03 22:47:04,416 - Velocimacro : messages on : VM system will output logging messages
2010-02-03 22:47:04,416 - Velocimacro : autoload off : VM system will not automatically reload global library macros
2010-02-03 22:47:04,416 - Velocimacro : initialization complete.
2010-02-03 22:47:04,416 - Velocity successfully started.
Do these help?
Posted: Thu Feb 04, 2010 10:36 am
by maschoff
No. I need the output in log openemm_stdout.log when OpenEMM is started.
Posted: Thu Feb 04, 2010 2:31 pm
by maschoff
From the log you sent me I saw that it is a (complicated) database problem. Do you work with more than one OpenEMM session at the same time (i.e. tabbed browsing of the same application)? Are property system.url in emm.properties and cms.ccr.url in cms.properties set correctly?
Posted: Thu Feb 04, 2010 2:43 pm
by lord_alan
Do you work with more than one OpenEMM session at the same time (i.e. tabbed browsing of the same application)?
Quite often I do yes. I have one tab open with a mailing content preview panel open and then in another tab I make edits to the content etc. and then review the changes by reloading the preview in the other tab.
Are property system.url in emm.properties and cms.ccr.url in cms.properties set correctly?
I believe they are:
Code: Select all
system.url=http://tolc.xx.xxxxxxxx.co.uk:8080
cms.ccr.url=http://tolc.xx.xxxxxxxx.co.uk:8080
Al
Posted: Thu Feb 04, 2010 2:52 pm
by maschoff
To track down the problem you can set up a fresh installation of OpenEMM 6.0.1 with a copy of your database. If the CMS is still invisible, delete everything you don't want us to see (addresses, mailings, etc.) and send us a DB dump so that we can replicate the issue.
Posted: Thu Feb 04, 2010 3:00 pm
by lord_alan
ma wrote:To track down the problem you can set up a fresh installation of OpenEMM 6.0.1 with a copy of your database. If the CMS is still invisible, delete everything you don't want us to see (addresses, mailings, etc.) and send us a DB dump so that we can replicate the issue.
OK. Thanks. I can do that.
This is essentially a "fresh install" though. I used the instructions in the README.txt file and so moved my 5.5.1 /home/openemm to openemm_backup and then untarred the 6.0.1 bin tarball into a new openemm directory.
I should get some time tomorrow to build a new install and will see how it goes.
Thanks
Al