Loading...
 
Architecture / Installation

Architecture / Installation


PluginSql not working??

posts: 20

Hello,

Does anyone know why a page with {SQL} will not load in tiki? I have confirmed that my dsn settings are correct by executing the same sql with the same username pw on the box itself - yet when I do the same via tiki - the page hangs.

I have also confirmed that my settings are correct in separate instance of tiki - where the query works!!

Both instances are running Tiki 2.2 - connecting to the same separate mysql db.

I am totally baffled at this point on what is going on....any help is greatly appreciated.

Medha

posts: 289 United States

Don't quote me on this but I'm wondering if the plugin has been disallowed/denied access because it's considered a security risk. I can't remember if this is true or not but I think it's a possibility.

UPDATE:
Also, does anything on the Plugin SQL page on the documentation site help?


posts: 20

I've used the Plugin SQL page to get the sandbox working. So yes - it helped me set up the Dsn, set the permissions and create the query.

The only thing I did differently - is that on the sandbox - I created the permission by doing the sql insert into users_permissions - and on my production box I saw that the permission is created when I set up the DSN.

I have also confirmed that the dsn settings are correct - and that the connection works on the box outside of tiki....


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting