Hi all
I have a problem about SQL request in DHIS2
When I request the table User in front end, I see this message, but for now, I want to have some situation about User in my extence DHIS2
SQL query contains references to protected tables
How can help me?
Regards
Carlos
Carlos Nyembwe
I’m just a Computer Scientist
Skype*: carloscnk1***
Cell*: (+243)813166381***
**Find me in: | Google Plus | **Linkedin | Facebook | Twitter |
Hi Carlos,
This has been put into place as a measure to prevent the potential accidental exposure of usernames and password hashes.
You can perform the query using a direct connection to the database, but DHIS2 should block any SQL views with references to some protected tables.
Regards,
Jason Pickering
On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe nyembwe@gmail.com wrote:
Hi all
I have a problem about SQL request in DHIS2
When I request the table User in front end, I see this message, but for now, I want to have some situation about User in my extence DHIS2
SQL query contains references to protected tables
How can help me?
Regards
Carlos
–
Carlos Nyembwe
I’m just a Computer Scientist
Skype*: carloscnk1***
Cell*: (+243)813166381***
**Find me in: | Google Plus | **Linkedin | Facebook | Twitter |
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
thanks Jason,
I understand you well but, I’m sorry for that because I don’t have the local database now, I have to download it
On Tue, Jul 25, 2017 at 10:22 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Carlos,
This has been put into place as a measure to prevent the potential accidental exposure of usernames and password hashes.
You can perform the query using a direct connection to the database, but DHIS2 should block any SQL views with references to some protected tables.
Regards,
Jason Pickering
–
On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe nyembwe@gmail.com wrote:
Hi all
I have a problem about SQL request in DHIS2
When I request the table User in front end, I see this message, but for now, I want to have some situation about User in my extence DHIS2
SQL query contains references to protected tables
How can help me?
Regards
Carlos
–
Carlos Nyembwe
I’m just a Computer Scientist
Skype*: carloscnk1***
Cell*: (+243)813166381***
**Find me in: | Google Plus | **Linkedin | Facebook | Twitter |
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
Carlos Nyembwe
I’m just a Computer Scientist
Skype*: carloscnk1***
Cell*: (+243)813166381***
**Find me in: | Google Plus | **Linkedin | Facebook | Twitter |
The other alternative is to use the API of course. What exactly are you trying to achieve?
On Tue, Jul 25, 2017 at 11:28 AM, Carlos Nyembwe nyembwe@gmail.com wrote:
thanks Jason,
I understand you well but, I’m sorry for that because I don’t have the local database now, I have to download it
–
On Tue, Jul 25, 2017 at 10:22 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Carlos,
This has been put into place as a measure to prevent the potential accidental exposure of usernames and password hashes.
You can perform the query using a direct connection to the database, but DHIS2 should block any SQL views with references to some protected tables.
Regards,
Jason Pickering
–
Carlos Nyembwe
I’m just a Computer Scientist
Skype*: carloscnk1***
Cell*: (+243)813166381***
**Find me in: | Google Plus | **Linkedin | Facebook | Twitter |
On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe nyembwe@gmail.com wrote:
Hi all
I have a problem about SQL request in DHIS2
When I request the table User in front end, I see this message, but for now, I want to have some situation about User in my extence DHIS2
SQL query contains references to protected tables
How can help me?
Regards
Carlos
–
Carlos Nyembwe
I’m just a Computer Scientist
Skype*: carloscnk1***
Cell*: (+243)813166381***
**Find me in: | Google Plus | **Linkedin | Facebook | Twitter |
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049