manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Emery <marco.em...@gmail.com>
Subject Re: Error getting postgres connection
Date Thu, 14 Jun 2012 15:29:30 GMT
Hi Karl,

Yes, you're right, these 2 properties were missing in my config. Database
is ok now, even if the 'manifold' database was already there.

Thanks a lot

2012/6/14 Karl Wright <daddywri@gmail.com>

> Hi Marc,
>
> The initialize.sh script is designed to do a bit more than you
> probably want in your setup.  It's designed to create the database
> instance as well, if it does not yet exist.  In order for it to work,
> then, you would need to give it the postgresql superuser name and
> password.  The parameters are:
>
> org.apache.manifoldcf.dbsuperusername
> org.apache.manifoldcf.dbsuperuserpassword
>
> If you don't want that creation step to take place, you will need to
> write your own custom script that performs the activities you want
> directly.  You can use the appropriate java commands as described in
> how-to-build-and-deploy, but those will not read and interpret
> connectors.xml for you so you'd have to hardcode the connectors you
> wish to register.
>
> If you want to create an enhancement ticket in jira
> (https://issues.apache.org/jira), then we can look at separating the
> example functionality that creates the database instance from the
> functionality that does the schema creation and connector
> registration.
>
> Thanks,
> Karl
>
>
> On Thu, Jun 14, 2012 at 8:48 AM, Marc Emery <marco.emery@gmail.com> wrote:
> > Hello,
> >
> > I'm installing MCF 0.5.1 with latest Postgresql 9.1.4
> >
> > here is my MCF properties.xml
> >
> >   <property name="org.apache.manifoldcf.databaseimplementationclass"
> > value="org.apache.manifoldcf.core.database.DBInterfacePostgreSQL"/>
> >   <property name="org.apache.manifoldcf.postgresql.hostname"
> > value="localhost"/>
> >   <property name="org.apache.manifoldcf.database.name"
> value="manifold"/>
> >   <property name="org.apache.manifoldcf.database.username"
> > value="manifold"/>
> >   <property name="org.apache.manifoldcf.database.password"
> > value="manifold"/>
> >
> > the database (manifold) and user (manifold/manifold) are created in
> Postgres
> > but when i run initialize.sh, i get the following error:
> >
> > org.apache.manifoldcf.core.interfaces.ManifoldCFException: Error getting
> > connection
> > at
> >
> org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:106)
> > at
> >
> org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:721)
> > at
> >
> org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1393)
> > at
> >
> org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
> > at
> >
> org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:185)
> > at
> >
> org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:524)
> > at
> >
> org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:698)
> > at
> >
> org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:123)
> > at
> >
> org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37)
> > at
> >
> org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60)
> > Caused by: org.postgresql.util.PSQLException: FATAL: no PostgreSQL user
> name
> > specified in startup packet
> > at
> >
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:293)
> > at
> >
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
> > at
> >
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
> > at
> >
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
> > at
> >
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
> > at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
> > at org.postgresql.Driver.makeConnection(Driver.java:393)
> >
> > Any idea would be appreciated.
> > Thanks a lot.
> >
> > marc
>

Mime
View raw message