Support

Admin Tools

#36999 Making RSForm!Pro with Google Sheets plugin work with Admin Tools

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
3.10.8
PHP version
7.4.28
Admin Tools version
6.1.5

Latest post by guzabi on Thursday, 21 April 2022 13:25 CDT

guzabi

Hello,

I'm using RSForm! Pro with Google Sheets plugin on my website. I'm not asking for help about this ! I made it work ok. There is a small problem in the interaction with Admin Tools, though.

During configuration, I have to allow Google Sheets API for my website and this is done through Google's 0Auth config. It means that When authorising, the RSForm Component has to request a token, so Google's auth opens up, authenticates, then uses these 2 return URL's :

https://www.petitpoisson.be/administrator/index.php?option=com_rsform&task=plugin&plugin_task=store_google_sheets_access_token&code=4/0AX4XfWioSsRi7KdlJh_Yeh3DgIN0zsl8duxe0fIitpEfmR0cvJykT17_tMpLaYxtvcYbFA&scope=https://www.googleapis.com/auth/spreadsheets

https://www.petitpoisson.be/administrator/index.php?option=com_rsform&scope=https://www.googleapis.com/auth/spreadsheets

 

The first one is the return URL when first getting the token, the second one is the return URL when refreshing it. They are blocked by the hardened .htaccess generated by Admin Tools. I can make this work by disabling The .htaccess or using the original Joomla! one, but I'd like to keep using the hardened one (I'm paying for a very useful product — yours — and want to keep using it). So I'd like to alter my .htaccess to allow access to these. Unfortunately, just pasting them into the "Allow direct access to these files" box in the .htaccess maker does not work (yes, I made them relative).

So, could you please, please help me insert the correct code into my .htaccess ? :-)

 

More information :

I can alter the first return URL so maybe I can write it differently and make use of url rewriting. Here's what I had to tell Google :

https://www.petitpoisson.be/administrator/index.php?option=com_rsform&task=plugin&plugin_task=store_google_sheets_access_token

The second one I can't control (but maybe I could hint the developers to the right direction if I know what it should be).

 

Thank you very much in advance.

Best regards

nicholas
Akeeba Staff
Manager

I can tell you exactly what that is because I've had the same problem setting up SocialLogin with Google login on my dev site and my own blog.

Look at the scope URL parameter. Google is using a stupid scope which looks like a URL :( This is blocked by the “Protect against common file injection attacks” feature in the .htaccess Maker. You need to disable this option.

If this doesn't help please let me know and I'll try to come up with a more complicated set of custom .htaccess rules you can add to your .htaccess file through Admin Tools' interface.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

guzabi

Works like a charm.

Quick and efficient, as ever :-) Thanks Nicholas !!!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!