Separate reports database

More
1 year 1 week ago #166992 by iccsubs
Is it possible to have the built in reports query a replica of the database? If so, how?

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
1 year 1 week ago #167009 by LouisGac
Replied by LouisGac on topic Separate reports database
You can export the whole database of an installation, you have a button for that in the configuration menu.
Then it's up to you to build the queries.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167022 by iccsubs
Replied by iccsubs on topic Separate reports database
What I'm trying to achieve is to have the reports run from a mysql replication slave instead of the main DB.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167023 by LouisGac
Replied by LouisGac on topic Separate reports database
ok: you're trying to generate the statistics from the LimeSurvey Admin Interface, but using another DB. Correct?

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167024 by iccsubs
Replied by iccsubs on topic Separate reports database
That is correct.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167025 by LouisGac
Replied by LouisGac on topic Separate reports database
well... If you copy the whole LimeSurvey database, you can just change the DB settings in the config file. It will work.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167026 by iccsubs
Replied by iccsubs on topic Separate reports database
So there is a separate DB settings configuration just for the statistics section of the platform? If so, where can I find it?

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167027 by LouisGac
Replied by LouisGac on topic Separate reports database
No: there is not.
I'm telling you that if you copy the whole DB, then you can connect LS to that DB.
But it will affect the whole application, not only the stats.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167029 by iccsubs
Replied by iccsubs on topic Separate reports database
OK. So I guess the solution here would be a separate LS instance configured to use the read replica, which is read-only, for the reports as making changes affecting the entire application is not acceptable. How can I disallow the use of statistics? I would like to prevent people from running statistics on the main DB.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167031 by LouisGac

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167032 by iccsubs
Replied by iccsubs on topic Separate reports database
Reportico looks nice but I'm not interested in designing new reports, at least not at the moment. Sometimes my users like to generate reports for fairly large time periods and have found that they can have a significant impact on the database used by users when they are filling surveys. I want to avoid that by not allowing reports to be run on the main installation/DB. Correct me if I'm wrong but, commenting lines 500 and 501 on admin/admin.php would effectively block the functionality, right? I realize it may not be the most elegant way of achieving this. Alternate ideas for achieving what I have described are welcome.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167033 by LouisGac
Replied by LouisGac on topic Separate reports database
which version of LimeSurvey are you using?

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167034 by iccsubs
Replied by iccsubs on topic Separate reports database
Version 1.92+ Build 120919

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167035 by LouisGac
Replied by LouisGac on topic Separate reports database
sorry, this is a very old version and I don't know its code.
I'd rather suggest you to upgrade to the latest version.

Please Log in or Create an account to join the conversation.

More
1 year 1 week ago #167037 by iccsubs
Replied by iccsubs on topic Separate reports database
admin/admin.php
...
499: elseif ($action == 'statistics')
500: {
501: if(bHasSurveyPermission($surveyid,'statistics','read')) {include('statistics.php');}
502: else { include('access_denied.php');}
503: }
...
Commenting lines 501 and 502.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!