great module - separate servers for database and web
sapark - July 15, 2008 - 14:39
| Project: | Natural Sort |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Great module.
Request to work with separate servers for database and web. Does it already, did I do something wrong?
I got error that natsort.install.mysql needed to be installed after installing the file.
Also, got error from restore of database where natural sort was working (database and web on same server) to a different database (database and web on separate servers):
execute command denied to user@xxx.xxx.xxx.xxx for laws.natsort_initialize query call netsort_initialize () in
/var/www/html/laws/includes/database/mysql.ini line 172
Thanks
#1
It's "already". The software you're using on your "web server", and that includes Drupal and all modules, has no idea the "database server" is remote.
When you run 'natsort.install.mysql' pay attention: you probably got some error message.
You need to run 'natsort.install.mysql' on the "different database" too. The utility programs that copy databases around usually deal only with data. But natsort added some code to your database, and those programs may not copy code, only data. You need to run 'natsort.install.mysql' on your new database to install this code.