Yeh it had stopped cause I ran out of disk space during the key import. Resizing now and will try again later.
-- Fabian A. Santiago OpenPGP: 0x643082042dc83e6d94b86c405e3daa18a1c22d8f > On Sunday, Sep 02, 2018 at 8:17 PM, Fabian A. Santiago > <fsanti...@garbage-juice.com (mailto:fsanti...@garbage-juice.com)> wrote: > Ahh, damn, it had stopped. Ok service starts now but I’m missing keys which > suggests it stopped during the key load for which I think I may know why. Ok > back to the drawing board. Standby. Thanks. > > -- > > Fabian A. Santiago > > OpenPGP: > > 0x643082042dc83e6d94b86c405e3daa18a1c22d8f > > > On Sunday, Sep 02, 2018 at 7:37 PM, Moritz Wirth <m...@flanga.io > > (mailto:m...@flanga.io)> wrote: > > > > Looks like PostgreSQL is not running or you got the wrong path to the unix > > socket. > > > > > > > > Am 03.09.18 um 01:15 schrieb Fabian A. Santiago: > > > I should add that it worked fine using Mongodb but was so slow. If I > > > hadn't made that clear prior. > > > > > > -- > > > > > > > On Sunday, Sep 02, 2018 at 7:08 PM, Fabian A. Santiago > > > > <fsanti...@garbage-juice.com (mailto:fsanti...@garbage-juice.com)> > > > > wrote: > > > > Ok, > > > > > > > > So trying to run in user space produces: > > > > > > > > [{/build/hockeypuck-lsqW7K/hockeypuck-2.0~rc2~1437340214+54df397~trusty/src/gopkg.in/hockeypuck/pghkp.v1/storage.go:112: > > > > } > > > > {/build/hockeypuck-lsqW7K/hockeypuck-2.0~rc2~1437340214+54df397~trusty/src/gopkg.in/hockeypuck/pghkp.v1/storage.go:122: > > > > } {dial unix /var/run/postgresql/.s.PGSQL.5432: no such file or > > > > directory}] > > > > > > > > I have postgresql version 10.5 installed on Ubuntu 14.04.5. Thanks in > > > > advance for any help you can offer. > > > > > > > > -- > > > > > > > > > On Sunday, Sep 02, 2018 at 6:54 PM, Fabian A. Santiago > > > > > <fsanti...@garbage-juice.com (mailto:fsanti...@garbage-juice.com)> > > > > > wrote: > > > > > Alright....import was much quicker. But now the service won't start. > > > > > Triaging now. > > > > > > > > > > -- > > > > > > > > > > > On Saturday, Sep 01, 2018 at 9:42 PM, Fabian A. Santiago > > > > > > <fsanti...@garbage-juice.com (mailto:fsanti...@garbage-juice.com)> > > > > > > wrote: > > > > > > Close, > > > > > > > > > > > > Command needs to be run as hockeypuck user. > > > > > > > > > > > > You need to create an hkp dB and hockeypuck role and grant > > > > > > ownership over the dB (at least that worked for me). > > > > > > > > > > > > Otherwise, it’s working and importing now. Thanks for your help. > > > > > > I’ll advise when it’s done and I can see whether or not I have good > > > > > > recon. > > > > > > > > > > > > -- > > > > > > > > > > > > > On Saturday, Sep 01, 2018 at 7:14 PM, Moritz Wirth > > > > > > > <m...@flanga.io (mailto:m...@flanga.io)> wrote: > > > > > > > > > > > > > > You have to set the filters to get the reconciliation working > > > > > > > with SKS: > > > > > > > > > > > > > > > > > > > > > > > > > > > > [hockeypuck.conflux.recon] > > > > > > > reconAddr=":11370" > > > > > > > version="1.1.6" > > > > > > > filters=["yminsky.dedup", "yminsky.merge"] > > > > > > > > > > > > > > > > > > > > > For Postgresql: > > > > > > > > > > > > > > > > > > > > > [hockeypuck.openpgp.db] driver="postgres-jsonb" dsn="database=hkp > > > > > > > host=/var/run/postgresql port=5432 sslmode=disable" Create the > > > > > > > database and run hockeypuck-load as postgre user - that should be > > > > > > > enough to start with a clean installation (you must use > > > > > > > postgresql > 9.4) - the tables are created by hockeypuck-load - > > > > > > > 100k keys take about 3-5 minutes to be imported so the whole > > > > > > > process should be done in 3-4 hours. In case your import fails, I > > > > > > > can provide a database dump of my MongoDB/PostgreSQL databases. > > > > > > > Regards, Moritz > > > > > > > > > > > > > > Am 02.09.18 um 01:10 schrieb Fabian A. Santiago: > > > > > > > > Could definitely use help on the parameters. And yes it was > > > > > > > > erorring on recon. So that explains why it never caught up. I’d > > > > > > > > appreciate the config help if you could. Thanks. > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > On Saturday, Sep 01, 2018 at 2:14 AM, dirk astrath > > > > > > > > > <dastr...@gmx.de (mailto:dastr...@gmx.de)> wrote: > > > > > > > > > Hello, > > > > > > > > > > > > > > > > > > Postgres ist way faster and sustainable compared to mongodb > > > > > > > > > (tested both > > > > > > > > > on different machines). > > > > > > > > > > > > > > > > > > The recon-parameters on hockeypuck-site needs to be modified > > > > > > > > > so it can > > > > > > > > > synchronize to the network (check the logfiles on sks and > > > > > > > > > hockeypuck size). > > > > > > > > > > > > > > > > > > Unfortunately I don't run any keyserver currently due to > > > > > > > > > several issues, > > > > > > > > > so i need to pull these settings out of a backup ... but can > > > > > > > > > do it if > > > > > > > > > neccessary ... > > > > > > > > > > > > > > > > > > Kind regards, > > > > > > > > > > > > > > > > > > dirk > > > > > > > > > > > > > > > > > > On 31.08.2018 21:06, Fabian A. Santiago wrote: > > > > > > > > > > can anyone on here assist with setting up hockeypuck? > > > > > > > > > > > > > > > > > > > > I've received help prior from a friendly user who got me up > > > > > > > > > > & running > > > > > > > > > > with mongodb. but it was SLOW to import a dump (days) and > > > > > > > > > > never caught > > > > > > > > > > up with my sks keyserver (maybe erroring out on gossip). > > > > > > > > > > > > > > > > > > > > would it be faster using postgresql? > > > > > > > > > > > > > > > > > > > > is there something special to configure in order to get it > > > > > > > > > > to gossip > > > > > > > > > > properly with sks servers as well as other hockeypucks? > > > > > > > > > > > > > > > > > > > > are there any instructions out there for setting up > > > > > > > > > > postgresql properly > > > > > > > > > > to be used with it? > > > > > > > > > > > > > > > > > > > > anything anyone can provide would be great as the > > > > > > > > > > hockeypuck docs site > > > > > > > > > > https://hockeypuck.github.io doesn't contain much in the > > > > > > > > > > way of finer > > > > > > > > > > details. > > > > > > > > > > > > > > > > > > > > thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > > > > Sks-devel mailing list > > > > > > > > > > Sks-devel@nongnu.org (mailto:Sks-devel@nongnu.org) > > > > > > > > > > https://lists.nongnu.org/mailman/listinfo/sks-devel > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ Sks-devel > > > > > > > > mailing list Sks-devel@nongnu.org (mailto:Sks-devel@nongnu.org) > > > > > > > > https://lists.nongnu.org/mailman/listinfo/sks-devel > > > > > > > > > _______________________________________________ Sks-devel mailing list > > > Sks-devel@nongnu.org (mailto:Sks-devel@nongnu.org) > > > https://lists.nongnu.org/mailman/listinfo/sks-devel > > _______________________________________________ > > Sks-devel mailing list > > Sks-devel@nongnu.org > > https://lists.nongnu.org/mailman/listinfo/sks-devel
_______________________________________________ Sks-devel mailing list Sks-devel@nongnu.org https://lists.nongnu.org/mailman/listinfo/sks-devel
