POLR is really hard to install on alpine (I got it working)- or How to manually create an admin ID

[symgryph]

Howto Install POLR on alpine with Caddy

This isn't a complete doc, but mainly you need to follow directions, except they FAIL. After that, follow manual setup with relevant drirections.

Finally, to add an admin user to the database, you need something like THIS:

INSERT INTO users VALUES(1,'admin','hashtedpw','admin@polr.me','127.0.0.1','recoverysecret','admin','1',NULL,0,'60','2021-09-20 06:41:11','2021-09-20 06:41:11',NULL);

this will NOT work as typed in. to get the hashed password:

php -r "echo password_hash('YOURADMINPASSWORDINTHECLER', PASSWORD_BCRYPT, ['cost' => 8]) . PHP_EOL;"

to get a recovery key:

at /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 100 | head -n 1

To get the valid date:

date '+%Y-%m-%d %H:%M:%S'

Hope this helps someone else.

Thomas

[akhiljalagam]

Howto Install POLR on alpine with Caddy

This isn't a complete doc, but mainly you need to follow directions, except they FAIL. After that, follow manual setup with relevant drirections.

Finally, to add an admin user to the database, you need something like THIS:

INSERT INTO users VALUES(1,'admin','hashtedpw','admin@polr.me','127.0.0.1','recoverysecret','admin','1',NULL,0,'60','2021-09-20 06:41:11','2021-09-20 06:41:11',NULL);

this will NOT work as typed in. to get the hashed password:

php -r "echo password_hash('YOURADMINPASSWORDINTHECLER', PASSWORD_BCRYPT, ['cost' => 8]) . PHP_EOL;"

to get a recovery key:

at /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 100 | head -n 1

To get the valid date:

date '+%Y-%m-%d %H:%M:%S'

Hope this helps someone else.

Thomas

update at /dev/urandom to cat /dev/urandom

[alexkowel]

Thanks, this helped a lot!

[tkaefer]

You could use my Dockerfile for polr, as it is using alpine as the base: https://github.com/tkaefer/polr/blob/master/Dockerfile