[jira] Commented: (CONNECTORS-148) Creating database in PostgreSQL does not work
[ 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 , 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
[jira] Commented: (CONNECTORS-148) Creating database in PostgreSQL does not work
[ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12988899#comment-12988899 ] Grant Ingersoll commented on CONNECTORS-148: Is there a workaround at all for this? Can the user hand create the DB or run a separate script? > 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
[jira] Commented: (CONNECTORS-148) Creating database in PostgreSQL does not work
[ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12988665#comment-12988665 ] Karl Wright commented on CONNECTORS-148: All of this is a downstream result of the change that removed quoteSQLString() from the database abstraction; it turns out there are at least a couple of cases where you MUST use quoting or the query does not reliably work under PostgreSQL. It's not clear exactly what other conditions contribute to the intermittent nature of the problem, but if your PostgreSQL is in the proper "state", you simply cannot create the ManifoldCF database, no matter how many times you retry. > 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
[jira] Commented: (CONNECTORS-148) Creating database in PostgreSQL does not work
[ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12988663#comment-12988663 ] Karl Wright commented on CONNECTORS-148: I committed a fix on trunk, r1065472. > 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
[jira] Commented: (CONNECTORS-148) Creating database in PostgreSQL does not work
[ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12979509#action_12979509 ] Karl Wright commented on CONNECTORS-148: Trunk check-in: r1057120. > 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 > > 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. - You can reply to this email to add a comment to the issue online.
