nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Alfresco 4.2e: SQLException caused by ClassNotFound during startup

beppegg

Hi all,

I'm trying to deploy an alfresco installation on my own linux machine.
The computer run a linux Debian "Jessie (Testing)" distribution, with mysql and tomcat 7 installed by means of regular "apt-get" architecture.

I've downloaded alfresco zip file, customized tomcat 7 installation as described <HERE> adding the required shared/classes, shared/lib and customizing catalina.properties and server.xml according instuctions. I added a "lib" directory and copied mysql-connector-5.1.27.jar in it. I created an empty schema and a user for alfresco in MySQL, granting him "create table" rights.
Finally, I copied share.war and alfresco.war into webapps/ directory.

When I start my servlet container, "share" starts succesfully but "alfresco" fails with the attached stacktrace.

Initially, I thought MySQL Driver class couldn't be found. So I tried writing a small JSP that loads the class, but it succeded: so the Driver class can actually be loaded by deployed applications.

Any help would be greatly appreciated!

alfresco-error.txt.zip

Find more posts tagged with

Comments

jpotts

Please post your alfresco-global.properties or at least your values for db.name, db.driver, and db.url. Also include the location of your alfresco-global.properties file.

Jeff

beppegg

Hi Jeff!

Thanks for your help.
I took some screenshot in order to answer your question in the most faithfull way; I've attached it since my proxy blocks me from using any "personal repository" service

Schermata da 2013-12-11 10:37:57.png

abarisone

Hi beppegg,
so if I correctly understood your situation you put the MySQL driver under tomcat7/lib, then started MySQL instance and then started Alfresco, right?

Regards,
Andrea

mrogers

Sorry, I can't see anything wrong with what you have posted. All looks O.K. to me.

Comparing your install with mine, which works, I put my sql connector library in the main "lib" directory ${TOMCAT_HOME}/lib (rather than the "shared/lib)"

Check you can login to the database with alfresco/alfresco ?

Also have you any earlier errors in your log, in particular out of memory errors? I'd expect you to need to increase the permgen memory settings as well.

bisana

please check when you created 'alfresco' db and user 'alfresco' what permsision u gave
can u login in from command line
mysql -uusername -ppassword databasename

beppegg

Thank you all for your help.

I've tried and I can actually connect to MySQL with provided credentials,also I can confirm mysql-connector.jar lives in tomcat7/lib and can be successfully loaded by webapps, since I tried with a simple JSP I wrote for debug purposes.

Edit: The error seems caused by tomcat's own connection pool; as far as I can understand, Alfresco tries to ask for connection via JNDI but Tomcat fails creating it. I suppose I should configure some other tomcat parameter, I tried looking in META-INF/context.xml but everything related to JNDI datasources is commented out. Should I look somewhere else?
My tomcat log doesn't shows any other exception, and MySQL server is started during bootstrap so it's available and running whe tomcat starts.

beppegg

Ok, I managed to overcome that problem!!

Debian package for tomcat sets CATALINA_BASE and CATALINA_HOME to different directories, so I shouldn't have copied mysql.jar in /var/lib/tomcat7/lib but I should have copied it in /usr/share/tomcat7/lib instead.

The bad news is that error message is now more cryptic:

INFO: Deploying configuration descriptor /etc/tomcat7/Catalina/localhost/alfresco.xml
dic 11, 2013 4:01:57 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
dic 11, 2013 4:01:57 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/alfresco] startup failed due to previous errors‍‍‍‍‍

any advice on where should I look for more details?

abarisone

Hi,
please give more us full log in order to find out what's going wrong.

Rgeards,
Andrea