nextcloud / nextcloud/passman

Passman on Nextcloud (database PostgreSQL)

Open
#434 7 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
JavaScript
Stars
823
Forks
117
Avg merge
1d 21h
Merged PRs (30d)
8

Description

Bug report

Not support PostgreSQL

Steps to reproduce
  1. When trying to add Passman to Nextcloud can't to add (if have PostgreSQL - on MySql work)
Expected behaviour

I relly love passman and hope passman will add support for PostgreSQL database.

Actual behaviour

Tell us what happens instead

Configuration

Operating system: Debian 9 GNU/Linux

Browser: Waterfox

Extensions that might cause interference:

Passman version:

Operating system: Debian 9 GNU/Linux

Web server: Apache

Database: PostgreSQL

PHP version: 7.0

cloud server: Nextcloud

cloud version: 12.0.4

Cloud log
Cloud log
{"reqId":"es9mToE2Ydvuy0BgdnPI","level":3,"time":"2018-01-19T09:15:31+00:00","remoteAddr":"192.168.4.226","user":"ivan","app":"core","method":"POST","url":"\/index.php\/settings\/ajax\/enableapp.php","message":"An exception occurred while executing 'ALTER TABLE oc_passman_share_request ALTER item_id TYPE BIGINT':\n\nSQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column \"item_id\" cannot be cast automatically to type bigint\nHINT:  You might need to specify \"USING item_id::bigint\".","userAgent":"Mozilla\/5.0 (X11; Linux x86_64; rv:56.0) Gecko\/20100101 Firefox\/56.0.3 Waterfox\/56.0.3","version":"12.0.4.3"}


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing Passman activation through Nextcloud's enableapp.php entry point with PostgreSQL and inspect the logged ALTER TABLE failure on oc_passman_share_request.item_id. Done means Passman can be enabled on PostgreSQL without this datatype-mismatch error; the issue does not name a source file or test to run.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.