- Posts: 8
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Separate reports database
- iccsubs
- Topic Author
- Offline
- New Member
Less
More
6 years 3 weeks ago #166992
by iccsubs
Separate reports database was created by iccsubs
Is it possible to have the built in reports query a replica of the database? If so, how?
The topic has been locked.
- LouisGac
- Visitor
6 years 3 weeks 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.
Then it's up to you to build the queries.
The topic has been locked.
- iccsubs
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
6 years 3 weeks 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.
The topic has been locked.
- LouisGac
- Visitor
6 years 3 weeks 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?
The topic has been locked.
- iccsubs
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
6 years 3 weeks ago #167024
by iccsubs
Replied by iccsubs on topic Separate reports database
That is correct.
The topic has been locked.
- LouisGac
- Visitor
6 years 3 weeks 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.
The topic has been locked.
- iccsubs
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
6 years 3 weeks 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?
The topic has been locked.
- LouisGac
- Visitor
6 years 3 weeks 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.
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.
The topic has been locked.
- iccsubs
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
6 years 3 weeks 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.
The topic has been locked.
- LouisGac
- Visitor
6 years 3 weeks ago #167031
by LouisGac
Replied by LouisGac on topic Separate reports database
also, maybe this will interest you:
www.reportico.org/site/index.php
and:
github.com/reportico-web/limesurvey-reportico
www.reportico.org/site/index.php
and:
github.com/reportico-web/limesurvey-reportico
The topic has been locked.
- iccsubs
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
6 years 3 weeks 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.
The topic has been locked.
- LouisGac
- Visitor
6 years 3 weeks ago #167033
by LouisGac
Replied by LouisGac on topic Separate reports database
which version of LimeSurvey are you using?
The topic has been locked.