topic Re: Alfresco tries to connect to Mysql while configured to use Postgresql in Alfresco Archive

Alfresco tries to connect to Mysql while configured to use Postgresql

bostaxola — Wed, 13 Aug 2014 12:35:21 GMT

I'm trying to install alfresco 5.a into an existing tomcat7. I have follow this guide http://fcorti.com/2013/01/09/installation-alfresco-4-2-c-on-ubuntu/ along with the one provided by alfresco wiki. The point is that I have installed postgresql 9.3.1, but Alfresco tries to connect to mysql:13:27:56

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

afaust — Wed, 13 Aug 2014 12:59:12 GMT

Hello,

somehow Alfresco picks up a property override from somewhere - have you made sure that you provide no system properties via the -D flags to the Tomcat Java process and don't have a JNDI data source setup for the container / web app?

Regards
Axel

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

mrogers — Wed, 13 Aug 2014 14:02:38 GMT

And have you added the "shared" folder to catalina's shared classloader?

e.g.
shared.loader= /var/lib/tomcat7/shared/classes

in catalina.properties

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

bostaxola — Sun, 17 Aug 2014 17:53:33 GMT

Thank you for both replies.

First of all, this is the alfresco process, I don't see anything weird.


alfresco 27186     1  0 13:27 ?        00:01:18 /usr/lib/jvm/java-7-openjdk-amd64/bin/java -Djava.util.logging.config.file=/var/lib/tomcat7/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms512m -Xmx768m -Xss768k -XX:MaxPermSize=256m -XX:NewSize=256m -server -Dalfresco.home=/opt/alfresco -Dcom.sun.management.jmxremote -Djava.endorsed.dirs=/var/lib/tomcat7/endorsed -classpath /var/lib/tomcat7/bin/bootstrap.jar:/var/lib/tomcat7/bin/tomcat-juli.jar -Dcatalina.base=/var/lib/tomcat7 -Dcatalina.home=/var/lib/tomcat7 -Djava.io.tmpdir=/var/lib/tomcat7/temp org.apache.catalina.startup.Bootstrap start
‍‍‍

The share.loader is:


shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
‍‍‍

And I dont know anything about the JNDI, I have checked tomcat7's conf files, and the only thing I have found about it is on the server.xml file:


<Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml" />
</GlobalNamingResources>

<Realm className="org.apache.catalina.realm.LockOutRealm">
        <!– This Realm uses the UserDatabase configured in the global JNDI
             resources under the key "UserDatabase".  Any edits
             that are performed against this UserDatabase are immediately
             available for use by the Realm.  –>
        <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
               resourceName="UserDatabase"/>
      </Realm>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

blevinson — Fri, 09 Jan 2015 19:56:57 GMT

Any resolution for this?

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

blevinson — Fri, 09 Jan 2015 20:20:00 GMT

Extract alfresco-repository-5.0.0.3.jar, change entries in repository.properties:
- db.driver=org.gjt.mm.mysql.Driver to db.driver=org.postgresql.Driver
- db.url=jdbc:mysql:///${db.name} to db.url=jdbcostgresql:///${db.name}
Recompress to a jar. If on a new mac, you may need to delete the __MACOSX folder that it creates when it compresses by doing this: zip -d [path]/alfresco-repository-5.0.0.3.jar __MACOSX/\*

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

mrogers — Fri, 09 Jan 2015 21:11:00 GMT

No! Don't change repository.properties, or otherwise hack the alfresco jars. Over-ride alfresco's settings as per the docs and admin guidelines.

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

olfa — Wed, 22 Apr 2015 11:40:22 GMT

Please, any solution for this?

I did not extract alfresco-repository-5.0.0.3.jar.
But i did modified cat /var/lib/tomcat7/shared/classes/alfresco-global.properties and add shared.loader= /var/lib/tomcat7/shared/classes
in catalina.properties.Alfresco connect automatically to Mysql, a Mysql command prompt appears showing this msg:

"150422 11:48:06 [Note] Plugin 'FEDERATED' is disabled.
150422 11:48:06 InnoDB: The InnoDB memory heap is disabled
150422 11:48:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150422 11:48:06 InnoDB: Compressed tables use zlib 1.2.3
150422 11:48:06 InnoDB: Initializing buffer pool, size = 128.0M
150422 11:48:06 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
150422 11:48:06 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
150422 11:48:06 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
150422 11:48:06 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
150422 11:48:07 InnoDB: Waiting for the background threads to start
150422 11:48:08 InnoDB: 1.1.8 started; log sequence number 0
150422 11:48:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 33061
150422 11:48:08 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150422 11:48:08 [Note] Server socket created on IP: '0.0.0.0'.
150422 11:48:08 [Note] Event Scheduler: Loaded 0 events
150422 11:48:08 [Note] E:\PROJET~1\ALFRES~1\ALFRES~1.B\mysql\bin\mysqld: ready for connections.
Version: '5.5.28' socket: '' port: 33061 MySQL Community Server (GPL)

Re: Alfresco tries to connect to Mysql while configured to use Postgresql

olfa — Wed, 22 Apr 2015 13:17:24 GMT