Install panel with external server mysql #253
Replies: 5 comments
-
puffrfish wrote at May 13 2016 02:48:40 UTC: It is indeed a bug with the installer. The result is that the permissions get set incorrectly for the PufferPanel MySQL user. You can "fix" this by hardcoding line 81 of the installer https://github.com/PufferPanel/PufferPanel/blob/master/pufferpanel#L81 to have the correct host. You should set this to the IP of the server that PufferPanel is running on, not the MySQL server. On the remote MySQL server you may also have to set skip-name-resolve in the my.cnf in order to prevent it from trying to find the DNS name of the server and giving an error because it's not seeing it as the raw IP. http://www.vionblog.com/skip-name-resolve-to-speed-up-mysql-and-avoid-problems/ |
Beta Was this translation helpful? Give feedback.
-
Doc94 wrote at May 13 2016 02:48:40 UTC: why the same IP of the panel and not the remote mysql server? i dont understant. |
Beta Was this translation helpful? Give feedback.
-
puffrfish wrote at May 13 2016 02:48:40 UTC: Because permissions are set on users depending on where they are coming from, so to the MySQL user it sees the pufferpanel user as coming from the server PufferPanel is running on. So to reiterate if you make newHost="104.168.1.1" replacing 104.168.1.1 with the IP of the PufferPanel sever it should work. Please let me know how it goes. |
Beta Was this translation helpful? Give feedback.
-
Doc94 wrote at May 13 2016 02:48:40 UTC: well finally test with a local mysql server.. with installer default but.. http://prntscr.com/b3nd61 |
Beta Was this translation helpful? Give feedback.
-
puffrfish wrote at May 13 2016 02:48:40 UTC: Please grab the contents of /var/log/nginx/error.log and /var/log/nginx/access.log and paste them to http://paste.ee and give us the URL it takes you to. |
Beta Was this translation helpful? Give feedback.
-
Doc94 wrote at May 13 2016 02:48:40 UTC:
Good, it's a question ....
Try installing the panel but to set the mysql connection, even if you set a different IP to use an external mysql server, the installer tries to do everything using localhost.
It is a bug or some my fault?
Beta Was this translation helpful? Give feedback.
All reactions