Page MenuHomePhabricator

ownCloud user_sql PlugInProject
ArchivedPublic

Details

Description

user_sql PlugIn for ownCloud/Nextcloud

Development of user_sql has stopped! v.2.3.1 for Nextcloud, v2.3 for ownCloud are the latest official releases!

Recent Activity

Aug 13 2020

andreas archived ownCloud user_sql PlugIn.
Aug 13 2020, 10:23 PM

Jan 30 2018

yu added a watcher for ownCloud user_sql PlugIn: yu.
Jan 30 2018, 2:36 PM

Jun 20 2017

andreas closed T40: cram-md5 encrptet passwords support ? as Resolved.

Closing, since user_sql is on hold.

Jun 20 2017, 7:56 AM · ownCloud user_sql PlugIn

Jan 11 2017

andreas edited Description on ownCloud user_sql PlugIn.
Jan 11 2017, 4:41 PM

Dec 12 2016

andreas added a comment to T40: cram-md5 encrptet passwords support ?.

Thanks for testing, I'll add it to the next release.
Did you also test password changing?

Dec 12 2016, 10:34 AM · ownCloud user_sql PlugIn
KennyVB added a comment to T40: cram-md5 encrptet passwords support ?.

Hey there! sorry the long time away and answer
how ever! it works perfectly !
thanks

Dec 12 2016, 9:52 AM · ownCloud user_sql PlugIn

Dec 3 2016

andreas added a comment to T40: cram-md5 encrptet passwords support ?.

Could you please test if the latest development version works for you? Here is the direct link: https://www.aboehler.at/hg/user_sql/archive/e6a991d13870.tar.gz

Dec 3 2016, 11:28 AM · ownCloud user_sql PlugIn

Dec 1 2016

KennyVB added a comment to T40: cram-md5 encrptet passwords support ?.

I used postfix admin to set password and I think it uses 'doveadm pw -s CRAM-MD5 -p $password'
and yes the strings in my database is cram-md5

Dec 1 2016, 7:42 AM · ownCloud user_sql PlugIn

Nov 30 2016

andreas triaged T40: cram-md5 encrptet passwords support ? as Normal priority.
Nov 30 2016, 3:07 PM · ownCloud user_sql PlugIn

Nov 19 2016

andreas closed T39: Error connecting to database: Failed to connect to the database: An exception occured in driver: could not find driver as Invalid.

Obviously, you do not have the PDO mySQL driver installed. That's a problem of your NAS, nothing I can do about.

Nov 19 2016, 12:56 PM · ownCloud user_sql PlugIn
KennyVB added a comment to T39: Error connecting to database: Failed to connect to the database: An exception occured in driver: could not find driver.

it's on freenas jail

Nov 19 2016, 10:30 AM · ownCloud user_sql PlugIn
KennyVB created T39: Error connecting to database: Failed to connect to the database: An exception occured in driver: could not find driver.
Nov 19 2016, 10:30 AM · ownCloud user_sql PlugIn

Nov 4 2016

mauro.frigi closed T37: Installation on Nextcloud 10 not possible as Resolved.

Yes, now it works

Nov 4 2016, 11:59 AM · ownCloud user_sql PlugIn
andreas added a comment to T37: Installation on Nextcloud 10 not possible.

OK, user_sql has just been released to the Nextcloud app store. Plus, I changed the way archive folders are created, so now it should also work with the release on OwnCloud's app store.

Nov 4 2016, 10:23 AM · ownCloud user_sql PlugIn
andreas added a comment to T37: Installation on Nextcloud 10 not possible.

This issue includes a fix to the code and does not only involve disabling the app code checker.

Nov 4 2016, 8:28 AM · ownCloud user_sql PlugIn

Nov 3 2016

mauro.frigi added a comment to T37: Installation on Nextcloud 10 not possible.

I have tried your suggestion,

Nov 3 2016, 11:08 PM · ownCloud user_sql PlugIn
andreas added a comment to T37: Installation on Nextcloud 10 not possible.

I'm sorry, NC10 is, of course, supported and it works fine for me. However, I have not yet upgraded to 10.0.1, which you are probably running.

Nov 3 2016, 8:33 PM · ownCloud user_sql PlugIn
andreas added a comment to T37: Installation on Nextcloud 10 not possible.

I never tried it with NC10, as soon as I upgrade, this problem will be fixed.

Nov 3 2016, 4:45 PM · ownCloud user_sql PlugIn
andreas claimed T37: Installation on Nextcloud 10 not possible.
Nov 3 2016, 4:44 PM · ownCloud user_sql PlugIn
mauro.frigi created T37: Installation on Nextcloud 10 not possible.
Nov 3 2016, 4:32 PM · ownCloud user_sql PlugIn

Sep 10 2016

Diffusion closed T18: Sanity-check settings as Resolved by committing rUSQL599b774a4b6a: Check if tables and columns exist before saving them. This fixes T18..
Sep 10 2016, 12:13 PM · ownCloud user_sql PlugIn
andreas closed T34: Database error after reinstall as Invalid.

you're welcome, I'm closing this...

Sep 10 2016, 9:53 AM · ownCloud user_sql PlugIn

Sep 9 2016

thedespo added a comment to T34: Database error after reinstall.

hey, so you were right . when I set the field "User active" to "Block" and "Invert active values" , it works now. Thank you.

Sep 9 2016, 8:12 PM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

By the way: If you go through the Joomla docs you'll notice that the column "activation" is meant for a completely different thing: It controls whether activation emails are to be sent!
You want the column "block" and, of course, need to check the "invert active value" box.

Sep 9 2016, 4:28 PM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

I went over your screenshot of the app configuration again and I think I found your problem: You must activate "Invert Active Value" (I did not bother entering the table for "User Active Column" in the first place)

Sep 9 2016, 4:16 PM · ownCloud user_sql PlugIn
thedespo added a comment to T34: Database error after reinstall.

But my MySql Server ist configured by Plesk. Maybe here are another settings adjusted.

Sep 9 2016, 4:12 PM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

I did not change the configuration of the sql server. I just created a new local user and selcted "Create database with same name and grant all permissions" in phpMyAdmin.

Sep 9 2016, 4:09 PM · ownCloud user_sql PlugIn
thedespo added a comment to T34: Database error after reinstall.

okay, that's strange. maybe its a misconfiguration of my mysql server? can you give me the config of your mysql server? so I can compare it

Sep 9 2016, 4:03 PM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

I just did a fresh installation of Debian Jessie, ownCloud 9.1.0, user_sql 2.3 and Joomla 3.6.2. Everything went without problems, my Joomla user is in the list and is able to login.

Sep 9 2016, 2:36 PM · ownCloud user_sql PlugIn
thedespo added a comment to T34: Database error after reinstall.

Okay, Thanks for your time!

Sep 9 2016, 9:49 AM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

That's really strange. The log doesn't even include information about ownCloud trying to list the users from the user_sql backend.

Sep 9 2016, 9:28 AM · ownCloud user_sql PlugIn

Sep 8 2016

thedespo added a comment to T34: Database error after reinstall.

Yes this is only the one server. i have duplicate the login information's to "default" and now without errors, but its no synchronizing (i cant see the Users of the another Database)

Sep 8 2016, 9:48 PM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

Hm, looks quite fine to me.
Is this the only domain you serve ownCloud on? If yes, what happens if you duplicate your settings for domain "default"?

Sep 8 2016, 9:01 PM · ownCloud user_sql PlugIn
thedespo added a comment to T34: Database error after reinstall.

Hi Andreas, yes i click on "Save" after Verify Settings :)

Sep 8 2016, 8:33 PM · ownCloud user_sql PlugIn
andreas claimed T34: Database error after reinstall.
Sep 8 2016, 10:03 AM · ownCloud user_sql PlugIn
andreas added a comment to T34: Database error after reinstall.

It seems that either saving or loading of the settings fails (you did click on "Save", right?).
Could you give some more info, please:

Sep 8 2016, 10:03 AM · ownCloud user_sql PlugIn
thedespo created T34: Database error after reinstall.
Sep 8 2016, 9:51 AM · ownCloud user_sql PlugIn

Sep 2 2016

buxit closed T33: update for owncloud 9, nextcloud as Resolved.

i have now noticed that the users got copied from the external sql database to the oc_users table (probably by some broken owncloud upgrade in the past). the principal admin acount never was on user_sql and could always log in. with this admin account in "users" i activated "show user backend" — all relevant accounts had "database" written there, instead of SQL.

Sep 2 2016, 9:19 AM · ownCloud user_sql PlugIn

Sep 1 2016

andreas reopened T33: update for owncloud 9, nextcloud as "Open".
Sep 1 2016, 8:55 PM · ownCloud user_sql PlugIn
andreas closed T33: update for owncloud 9, nextcloud as Resolved.

Thanks for the logs. Could you try clearing your browser cache and cookies and logging in again? Did you check from a different computer?

Sep 1 2016, 8:55 PM · ownCloud user_sql PlugIn
buxit added a comment to T33: update for owncloud 9, nextcloud.

i'm not running any extra authentication plugins. the i'm using postgresql as the database backend.

Sep 1 2016, 3:49 PM · ownCloud user_sql PlugIn
andreas added a comment to T33: update for owncloud 9, nextcloud.

That's strange, I'm running on NextCloud 9 for quite some time now (actually, since its release).
I tested it on ownCloud 9.1 just yesterday and I did not notice any problems.

Sep 1 2016, 3:16 PM · ownCloud user_sql PlugIn
buxit created T33: update for owncloud 9, nextcloud.
Sep 1 2016, 3:09 PM · ownCloud user_sql PlugIn

Aug 4 2016

buxit added a watcher for ownCloud user_sql PlugIn: buxit.
Aug 4 2016, 1:00 PM

Apr 23 2016

kril.denis added a comment to T27: Authorize by vbulletin database.

field column in a database - user and secret. but i don't know what kind of encrypt used.

Apr 23 2016, 8:49 PM · ownCloud user_sql PlugIn
andreas closed T27: Authorize by vbulletin database as Invalid.

You need to know the name of the table as well as the columns that vBulletin uses to store its information. Unfortunately, vBulletin is not Open Source, thus I am not able to help you here.

Apr 23 2016, 6:09 PM · ownCloud user_sql PlugIn

Apr 22 2016

kril.denis created T27: Authorize by vbulletin database.
Apr 22 2016, 10:23 PM · ownCloud user_sql PlugIn

Apr 8 2016

andreas closed T21: implements getHome method as Resolved.

Marking it as resolved as it works for me and nobody else complained...

Apr 8 2016, 12:16 PM · ownCloud user_sql PlugIn

Mar 14 2016

royalterra added a watcher for ownCloud user_sql PlugIn: royalterra.
Mar 14 2016, 2:02 AM

Jan 8 2016

andreas added a comment to T21: implements getHome method.

I added this in rUSQL77f7b713334c, rUSQL34606ff7539f and rUSQL5d207457c879

Jan 8 2016, 9:29 AM · ownCloud user_sql PlugIn