Can't start Collect when connecting to PostgreSQL

  • Asked
  • Active
  • Viewed 7829 times
0

Dear Community,

I am trying to change from SQLite to PostgreSQL. After applying the steps given in the manual (with the additional manual steps of creating a database and schema "collect") I am still not able to open collect. I have tried to change the port and I have deactivated my firewall, as well as I have changed the seetings in the postgres files (postgres and pg_hba), but it still does not work. The response it get is: localhost page can't be found (HTTP ERROR 404) Do you know what the problem could be?

Thanks in advance,

Tobias

0

Accepted answer

Hi Tobias,
Can you share with us the Collect log file? You can find it in C:\opt\openforis\collect\tomcat\webapps\collect\logs\collect.log
It will give us some more information about the problem. What version of PostgreSQL are you using?
Thanks,
Open Foris Team

0

Accepted answer

I will send you the file via mail. What is the address?

0

Accepted answer

We will contact you to your private email address.
Thanks,
Open Foris Team

0

Accepted answer

Dear Tobias,
We found a problem running Collect up to version 3.12.8 using the latest version of PostgreSQL (9.6). The problem is due to a non-backwards change in PostgreSQL that caused the problem you had.
Please update Collect to the latest version (3.12.9) and you shouldn't have again the same problem.
Many thanks,
Open Foris Team

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.