nextcloud/user_sql

Name: user_sql

Owner: Nextcloud

Description: ? App for authenticating Nextcloud users using SQL

Created: 2017-02-04 07:58:01.0

Updated: 2018-05-11 16:28:39.0

Pushed: 2018-05-11 16:28:37.0

Homepage:

Size: 177

Language: PHP

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

user_sql

Nextcloud SQL user authentication.

Getting Started

1. SSH into your server

2. Get into the apps folder of your Nextcloud installation, for example /var/www/nextcloud/apps

3. Git clone this project

   clone https://github.com/nextcloud/user_sql.git
   

4. Login your Nextcloud as admin

5. Navigate to Apps from the menu and enable the SQL user backend

6. Navigate to Admin from menu and switch to Additional Settings, scroll down the page and you will see SQL User Backend settings

Integrations

WordPress

Thanks to this app, Nextcloud can easily integrate with Wordpress.

In the Nextcloud Column Settings of SQL User Backend, configure it as

e: wp_users
name Column: user_login
word Column: user_pass
yption Type: Joomla > 2.5.18 phppass

JHipster

It is very easy to integrate Nextcloud with JHipster.

Follow the Using the Database instructions in Using Jhipster in development to configure your database. Assume you chose MySQL as JHipster database.

In the Nextcloud Column Settings of SQL User Backend, configure it as

e: jhi_users
name Column: login
word Column: password_hash
yption Type: Joomla > 2.5.18 phppass
 Activate Column: activated
l Column: email

Features

Currently, it supports most of postfixadmin's encryption options, except dovecot and saslauthd. It was tested and developed for a postfixadmin database.

Password changing is disabled by default, but can be enabled in the Admin area. Caution: user_sql does not recreate password salts, which imposes a security risk. Password salts should be newly generated whenever the password changes.

The column autocomplete works only for MySQL and PostgreSQL database which is used to validate form data. If you use other database use occ command to set the application config parameters with domain suffix.

For example to set 'sql_hostname' parameter in default domain use:

Currently supported parameters

l_hostname
l_username
l_password
l_database
l_table
l_driver
l_username
l_password
l_active
l_displayname
l_email
l_gethome
t_active_invert
t_allow_pwchange
t_default_domain
t_strip_domain
t_crypt_type
t_mail_sync_mode
t_enable_gethome
t_gethome_mode
t_gethome
l_group_table
l_group_username
l_group_name

cknowledgments
 repository contains continuation of work done in [this repo](https://www.aboehler.at/hg/user_sql/).

 plugin is heavily based on user_imap, user_pwauth, user_ldap and user_redmine!

Credits

Andreas Boehler for releasing the first version of this application
Johan Hendriks provided his user_postfixadmin
Ed Wildgoose for fixing possible SQL injection vulnerability