Fails to create Newsgroups table; ssl not activated on the server...

anoduck commented 5 years ago

info

git revision / version: 1

OS: Both: OpenBSD-6.5 && Ubuntu Disco

Architecture: x86_64

problem

While setting up srndv2, recieve error that script cannot create the table Newsgroups, because SSL is not enabled on the server.

SSL is enabled on both servers. Curious if there is another means of creating the needed table and/or loading the database template differently? Regardless, a work around is needed to create the missing table. Is it possible to disable the requirement of SSL on the server? Regardless, cannot run application or progress any further in configuration until this has been successfully achieved.

backtrace / error messages

Error messages: yes

cannot create table Newsgroups, pq: SSL is not enabled on the server, login was 'user=srnd password='SomePassword' host=127.0.0.1 port=5432 client_encoding='UTF8''

Backtrace: no

How do you switch on debugging for srnd?

majestrate commented 5 years ago

On Thu, May 09, 2019 at 01:11:44PM -0700, Anoduck wrote:

info

git revision / version: 1

OS: Both: OpenBSD-6.5 && Ubuntu Disco

Architecture: x86_64

problem

While setting up srndv2, recieve error that script cannot create the table Newsgroups, because SSL is not enabled on the server.

SSL is enabled on both servers. Curious if there is another means of creating the needed table and/or loading the database template differently? Regardless, a work around is needed to create the missing table. Is it possible to disable the requirement of SSL on the server? Regardless, cannot run application or progress any further in configuration until this has been successfully achieved.

try using a socket file instead of a loopback address that may work.

backtrace / error messages

Error messages: yes

cannot create table Newsgroups, pq: SSL is not enabled on the server, login was 'user=srnd password='SomePassword' host=127.0.0.1 port=5432 client_encoding='UTF8''

Backtrace: no

How do you switch on debugging for srnd?

it does not have a debug mode at this time. so much crap it needs a good refactor but i don't have much time.

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/majestrate/nntpchan/issues/178

anoduck commented 5 years ago

info

Git revision: 1

OS variety: Ubuntu Disco

Architecture: Intel x86_64

problem

In Ubuntu, I get a slightly different error message. The setup script fails to initialize tls. What am I doing or not doing wrong?

Backtrace / Error Messages

Error Messages: Yes

failed to initialize tls: open certs/overchan-$HOSTNAME.crt: no such file or directory

Backtrace: No

Thank you for your help, kindness, time, and contribution.

majestrate commented 5 years ago

On Thu, May 09, 2019 at 08:44:23PM -0700, Anoduck wrote:

info

Git revision: 1

OS variety: Ubuntu Disco

Architecture: Intel x86_64

problem

In Ubuntu, I get a slightly different error message. The setup script fails to initialize tls. What am I doing or not doing wrong?

Backtrace / Error Messages

Error Messages: Yes

failed to initialize tls: open certs/overchan-$HOSTNAME.crt: no such file or directory

does a directory called certs exist? if not create it, it should be auto made if it's not that's a bug

Backtrace: No

Thank you for your help, kindness, time, and contribution.

-- You are receiving this because you commented. Reply to this email directly or view it on GitHub: https://github.com/majestrate/nntpchan/issues/178#issuecomment-491145054

anoduck commented 5 years ago

EUREKA! Finally! Success. It works!

I created the directory, then it fired right up, just like butter.

Thank you, so much.

Other problems experienced were related to Ubuntu, Postgresql-10, and Postgresql-11 not getting along enough to form a cohesive system environment. I had to remove postgresql-10, re-link some commands, and finish configuration of postgresql-11.

Thanks again.

majestrate commented 5 years ago

On Sun, May 12, 2019 at 06:12:13AM +0000, Anoduck wrote:

EUREKA! Finally! Success. It works! if you need peering info email me for it.

Thank you, so much. yw

-- You are receiving this because you commented. Reply to this email directly or view it on GitHub: https://github.com/majestrate/nntpchan/issues/178#issuecomment-491567756

anoduck commented 5 years ago

Emailed you for peer information, and am I suppose to close the issue or are you? Thanks again.

majestrate commented 5 years ago

yeah you can close it if you want

majestrate / nntpchan