4.0d, mysql and logging in

[gregcpx]

I have been trying (and trying and trying) to install Alfresco with MySQL for several days now.  The instructions are not exactly the best, but I have followed them to the letter.

1. Installed MySQL
2. Created DB, user, password, utf8, allowed remote connections, and all of the other goodies for MySQL
3. Installed the alfresco software, unchecked Postgresql, and added the correct user, passoword, URL (tried several in fact), driver, etc.
4. Modified the global properties to ensure that everything looked good (and kept the utf8 thingy at the end of the connection url)
5. Started up Alfresco

I can't login with any user. Just keeps telling me invalid.  I am not 100% sure what is wrong.  I do see all kinds of error messages but not exactly sure what to copy/paste into here.

Anyone with guidance?
4.0 with mysql seems a bit Murkey to say the least and SQL Server or Oracle install is a bit over kill for just testing something out, and I don't know PostgreSQL and I can't install something that I can't have the ability to control (ie: I don't know PostgreSQL and the tools to support PG are very lacking as well as the ability to manage it).

Thanks in advance

[mrogers]

Need exceptions.

4.0 with MySql is fine for me.

[gregcpx]

Well I decided to rebuild yet one more time.
Taking time and looking at all of the info in front of me to install 3 or 4 times per step.
I also switched from Windows 2008R2 to Windows 2003

I seem to have gotten further along.
I don't seem to have any errors (or at least ones that seem too terrible (although I'll post a few here)
but when I got to:

http://server_ip_address:8080/share - the page times out, yet on the server if I go to http://localhost:8080/share it seems to work. 


There is no firewall turned on or any firewall between PC and server could this be a configuration issue now in the global-properties?



log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
2012-02-14 10:30:57,765  ERROR [activities.feed.AbstractFeedGenerator] [DefaultScheduler_Worker-5] Exception during generation of feeds
org.alfresco.error.AlfrescoRuntimeException: 01140023 Failed to get from EhCache as state invalid:
  state: STATUS_SHUTDOWN
   key: Namespace.http://www.alfresco.org/model/system/1.0
   at org.alfresco.repo.cache.EhCacheAdapter.get(EhCacheAdapter.java:93)
   at org.alfresco.repo.cache.TransactionalCache.getSharedCacheValue(TransactionalCache.java:326)
   at org.alfresco.repo.cache.TransactionalCache.get(TransactionalCache.java:392)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:458)
   at org.alfresco.repo.domain.qname.AbstractQNameDAOImpl.getOrCreateNamespace(AbstractQNameDAOImpl.java:133)
   at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:75)
   at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:449)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
   at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
   at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: java.lang.IllegalStateException: The org.alfresco.cache.immutableEntityCache Cache is not alive.
   at net.sf.ehcache.Cache.checkStatus(Cache.java:2282)
   at net.sf.ehcache.Cache.get(Cache.java:1325)
   at net.sf.ehcache.Cache.get(Cache.java:1306)
   at org.alfresco.repo.cache.EhCacheAdapter.get(EhCacheAdapter.java:81)
   … 16 more

[gregcpx]

So I've been poking around on the server and decided to add windows firewall/ics and then turn off the firewall rules.
It was not originally installed (which I normally do).

For whatever strange reason, that seemed to work…it is all I did, so who knows.
I never did get this to work with Windows 2008R2 though, but I think I'll go back and keep trying on that platform.

Thx for the help (or at least moral support).