To get around the multiple database issue, if piwigo and wordpress databases are on the same host, a view can be created in the piwigo database with something like the following:
From within phpmyadmin, with the piwigo database selected enter the following SQL:
CREATE VIEW piwigo_wpusers_view
AS
SELECT *
FROM wp_db_name.wp_users;
This will make a link of the wordpress wp_users table in the piwigo database.
Then, as shown in the previous methods for modifying config.inc.php, set the users_table to the new view:
$conf['users_table'] = 'piwigo_wpusers_view';
This makes it possible to login to piwigo using the wordpress password database. However, I'm still having issues with it automatically logging into the piwigo once it's logged into wordpress.
Anyone else still working on this?
Offline
Just a followup to my previous post. It is important that the webmaster id match the admin id. It's probably safest to make it 1 in both piwigo and wordpress. Having it not match was preventing admin login for piwigo.
Offline
And another followup.
If you are using SSL/TLS for https, then in the wp widget configuration menu, you will have to specify https://www.yourdomain.com in the external URL field. The internal plugin code will prepend http: to the field for internal URLs which will cause problems with https pages containing links to non secure pages/images. My work around was to use the full external https url to the gallery i.e. https://www.example.com/piwigo. (This keeps the "lock" icon next to the address in the browser address bar.)
Last edited by viosca (2019-08-15 08:11:03)
Offline
Hello,
I would like to have more information about the integration between Piwigo and Wordpress.
Is it still current or is the way to present it unusable?
Have a nice day
Offline