[
https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12988921#comment-12988921
]
Karl Wright commented on CONNECTORS-148:
----------------------------------------
The user needs only to create the proper database user for everything to work.
However, I am concerned that the complexity of doing this will dissuade
first-time users. Usually that involves firing up psql -U <superusername> ,
and entering the following:
CREATE USER manifoldcf PASSWORD 'local_pg_passwd';
\q
Furthermore, it's not clear the best way to disseminate this information, and
given that this is essentially step 1, I believe ManifoldCF is best served by
fixing the problem before release.
However, if you wish to go ahead and release the artifact as it stands, I can
certain go ahead and do that. Suggestions for how to distribute the necessary
information welcome.
> Creating database in PostgreSQL does not work
> ---------------------------------------------
>
> Key: CONNECTORS-148
> URL: https://issues.apache.org/jira/browse/CONNECTORS-148
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework core
> Affects Versions: ManifoldCF 0.1
> Reporter: Karl Wright
> Assignee: Karl Wright
> Priority: Blocker
> Fix For: ManifoldCF 0.1
>
>
> When you try to create a PostgreSQL database, you get back the following
> error:
> Exception: Database exception: Exception doing query: ERROR: syntax error at
> or near "$1"
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database
> exception: Exception doing query: ERROR: syntax error at or near "$1"
> at
> org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:461)
> at
> org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:505)
> at
> org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1131)
> at
> org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
> at
> org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:168)
> at
> org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:536)
> at
> org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:656)
> at
> org.apache.manifoldcf.jettyrunner.ManifoldCFJettyRunner.main(ManifoldCFJettyRunner.java:202)
> Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
> "$1"
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
> at
> org.apache.manifoldcf.core.database.Database.execute(Database.java:606)
> at
> org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:421)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
