# After Update - Dreamfactory 1.8 Cannot access MYSQL Views in Nginx **URL:** \ **Category:** App Configuration\ **Created:** [October 10, 2014, 11:43am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451 "2014-10-10T11:43:39Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 10, 2014, 11:43am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/1 "2014-10-10T11:43:39Z")
After update, cannot access the views in MYSQL. Please Help. Update : It seems the issue is only with Nginx and not Apache. Server is Ubuntu 14.04. Need it to work with Nginx as dreamfactory performs alot better in Nginx. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [October 10, 2014, 4:47pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/2 "2014-10-10T16:47:00Z")
What about accessing tables rather than views on that same db with Nginx. Does that work for you? ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 10, 2014, 5:55pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/3 "2014-10-10T17:55:45Z")
Yeah, tables are working. Moreover, lets say if I have two services setup. Then, when we go to Roles screen and try to assign Service Access, even if we choose lets say the first service, it lists all the tables of all the services including the tables of dreamfactory. Till 1.78, if selected service A, it only listed the tables and views of Service A. In apache, everything is working fine. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [October 10, 2014, 7:01pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/4 "2014-10-10T19:01:01Z")
There was a bug that was preventing views from working. It’s been fixed and shouldn’t have anything to do with Nginx vs Apache. As for the list of tables under role service access, starting with 1.8.0 that list will include all tables your database user (normally dsp\_user) has access to, not just the dreamfactory ones. I suspect the additional tables are for the selected service but just weren’t shown in 1.7.8. Let us know if you are sure the tables shown are not for the selected service. ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 11, 2014, 9:34am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/5 "2014-10-11T09:34:30Z")
Please see the image below. I am 100% sure that the tables shown are not just for the selected service. It shows all the tables for all the services in 1.80. You will notice that it shows dreamfactory tables and the rds db tables. [The image you are requesting does not exist or is no longer available] ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [October 11, 2014, 12:05pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/6 "2014-10-11T12:05:16Z")
I still think this is expected behavior. Starting with 1.8 when you select a service it shows the tables for all databases for that service (that your user has access to). Your selected service has more than one database. dreamfactory\_1.8 and mysql are different databases in the same service. Try going to phpmyadmin and look for those two databases. ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 11, 2014, 5:18pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/7 "2014-10-11T17:18:52Z")
There are alot more tables listed which I am not able to show a screenshot for. Ill install it in a new server and then confirm. ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 11, 2014, 6:32pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/8 "2014-10-11T18:32:43Z")
Still doing the same. Dreamfactory db is local whereas service is rds. [The image you are requesting does not exist or is no longer available] [The image you are requesting does not exist or is no longer available] This one shows the first two tables of the Service A:- [The image you are requesting does not exist or is no longer available] Again, the issue is not that its showing all but the issue is that its not showing the views. Its working perfectly fine in 1.78 and the 1.8 is working fine in apache. The above screenshots are for server running ubuntu 14.04 and nginx. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [October 13, 2014, 2:50pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/9 "2014-10-13T14:50:56Z")
The fix for views not showing up will be available this week. If you are using a hosted DSP it will just start working. If you have your own DSP you will have to run composer update to get the fix. We are also removing mysql.\* and a few others from the list. ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 13, 2014, 5:28pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/10 "2014-10-13T17:28:16Z")
Thanks. Please post whenever the update is needed. Thanks. ---
**Author:** ![antonyjsmith](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/antonyjsmith/32/1203_2.png) [@antonyjsmith](https://community.dreamfactory.com/u/antonyjsmith)\ **Post date:** [October 14, 2014, 9:10am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/11 "2014-10-14T09:10:21Z")
I’m having a very similar issue, an external mySQL service and configuration which was working perfectly before 1.8 has now stopped working. The schema is blank and nothing appears in the data tab. I’m on an upgraded Bitnami stack running Apache. ---
**Author:** ![antonyjsmith](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/antonyjsmith/32/1203_2.png) [@antonyjsmith](https://community.dreamfactory.com/u/antonyjsmith)\ **Post date:** [October 14, 2014, 9:46am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/12 "2014-10-14T09:46:33Z")
This is all I see in role -\> Service Access tab is this: [The image you are requesting does not exist or is no longer available] ---
**Author:** ![antonyjsmith](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/antonyjsmith/32/1203_2.png) [@antonyjsmith](https://community.dreamfactory.com/u/antonyjsmith)\ **Post date:** [October 14, 2014, 10:12am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/13 "2014-10-14T10:12:57Z")
So it seems the connection string is sensitive to a trailing semi-colon. i.e. this does not work: ``` mysql:host=mydb.com;dbname=mydatabase ``` This does: ``` mysql:host=mydb.com;dbname=mydatabase; ``` Which kind of makes sense, but the fact the connection string builder in the service configuration utility doesn’t append a semi-colon is quite misleading. In addition, despite the fact I’m specifiying the dbname I wish to use, all databases and tables in the database are displayed [with the dbname prefixed if not specified in the connection string]. Which as my db contains quite a lot of other tables is very annoying and begs the question, whats the point in specifying a dbname? Thanks ---
**Author:** ![stadja](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@stadja](https://community.dreamfactory.com/u/stadja)\ **Post date:** [October 14, 2014, 2:32pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/14 "2014-10-14T14:32:52Z")
Well… thank for the info… After my upgrade no remote MYSQL database work anymore… I appended a semi-colon and in my case it still doesn’t work… (maybe I have for the cache to die ?) ``` mysql:host=localhost:3306;dbname=databasename; ``` It’s my connection string… do you see something wrong ? ``` {"error":[{"context":null,"message":"Table "links" does not exist in the database.","code":404}]} ``` is what I get back… but it does exist and it was working… ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 14, 2014, 3:00pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/15 "2014-10-14T15:00:43Z")
I have also noticed that all the databases are being displayed. They have said they will come up with a fix soon, so lets wait. ---
**Author:** ![Mark](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mark/32/69_2.png) [@Mark](https://community.dreamfactory.com/u/Mark)\ **Post date:** [October 14, 2014, 3:06pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/16 "2014-10-14T15:06:10Z")
Yes. This fix is being implemented within the next two days, hopefully by tomorrow. Please be on the lookout for the fix. Thanks, - Mark ---
**Author:** ![selfeky](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/selfeky/32/149_2.png) [@selfeky](https://community.dreamfactory.com/u/selfeky)\ **Post date:** [October 15, 2014, 6:06pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/17 "2014-10-15T18:06:28Z")
I cant access views in apache ---
**Author:** ![Mark](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mark/32/69_2.png) [@Mark](https://community.dreamfactory.com/u/Mark)\ **Post date:** [October 15, 2014, 7:40pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/18 "2014-10-15T19:40:37Z")
Yes, This is related to the upgrade that is pending release. It will be available by the end of day today or tomorrow at the latest. Apologies for the inconvenience. Thanks, Mark ---
**Author:** ![hjais](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@hjais](https://community.dreamfactory.com/u/hjais)\ **Post date:** [October 19, 2014, 6:27am UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/19 "2014-10-19T06:27:31Z")
Hey Mark, Is the update out? ---
**Author:** ![selfeky](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/selfeky/32/149_2.png) [@selfeky](https://community.dreamfactory.com/u/selfeky)\ **Post date:** [October 19, 2014, 2:31pm UTC](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451/20 "2014-10-19T14:31:07Z")
@hjais Not sure if this is a solution or not but it works for me i updated composer using the following: php ./composer.phar update will in the platform (root) folder this will update php common libs of dreamfactory where the fix is. Make sure not to do this on a production instance as im not sure if it is the right thing to do or not [Next page](https://community.dreamfactory.com/t/after-update-dreamfactory-1-8-cannot-access-mysql-views-in-nginx/451.md?page=2)