Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Separate reports database

  • iccsubs
  • iccsubs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months 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
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months 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.
The topic has been locked.
  • iccsubs
  • iccsubs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months 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
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months 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
  • iccsubs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months ago #167024 by iccsubs
Replied by iccsubs on topic Separate reports database
That is correct.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months 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
  • iccsubs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months 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
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months 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.
The topic has been locked.
  • iccsubs
  • iccsubs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months 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
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months ago #167031 by LouisGac
Replied by LouisGac on topic Separate reports database
The topic has been locked.
  • iccsubs
  • iccsubs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months 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
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months ago #167033 by LouisGac
Replied by LouisGac on topic Separate reports database
which version of LimeSurvey are you using?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose