将 Funambol 连接到远程主机上的 MySQL
我正在 Linux 主机上设置 Funambol 8.7（使用 Amazon AWS）。我需要连接到托管在不同服务器上的 MySQL 数据库。
根据管理指南，我继续下载 mysql 连接器并将 jar 放在 /opt/Funambol/tools/jre-1.6.0/lib/ext 中。我更改了 install.properties 文件，如下所示：
dbms=mysql
jdbc.classpath=/opt/Funambol/tools/jre-1.6.0/jre/lib/ext/mysql-connector-java-5.1.14-bin.jar
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://myserver.net/rugcutte_funambol?characterEncoding=UTF-8
jdbc.user=rugcutte_funambo
jdbc.password=funambol
然后我尝试运行安装，但出现以下错误：
/opt/Funambol/ds-server/install/install.xml:452: java.sql.SQLException: Access denied for user 'rugcutte_funambo'@'ec2-50-16-233-200.compute-1.amazonaws.com' (using password: YES)
看来我的 AWS 实例可以成功连接到我的 MySQL 数据库，但它正在尝试使用完全限定的用户名登录不正确：rugcutte_funambo'@'ec2-50-16-233-200.compute-1.amazonaws.com
我也尝试将该行更改为： [电子邮件受保护] 。但我也遇到了类似的错误。
我对 JDBC 比较缺乏经验。设置 install.properties 文件这一部分的正确方法是什么？
I am setting up Funambol 8.7 on a Linux host (using Amazon AWS). I need to connect to a MySQL datbase that is hosted on a different server.
Per the administration guide I went ahead and downloaded the mysql connector and placed the jar in /opt/Funambol/tools/jre-1.6.0/lib/ext. I changed the install.properties file as follows:
dbms=mysql
jdbc.classpath=/opt/Funambol/tools/jre-1.6.0/jre/lib/ext/mysql-connector-java-5.1.14-bin.jar
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://myserver.net/rugcutte_funambol?characterEncoding=UTF-8
jdbc.user=rugcutte_funambo
jdbc.password=funambol
THen I try to run the install, but get the following error:
/opt/Funambol/ds-server/install/install.xml:452: java.sql.SQLException: Access denied for user 'rugcutte_funambo'@'ec2-50-16-233-200.compute-1.amazonaws.com' (using password: YES)
It appears my AWS instance can connect successfully to my MySQL database however it is trying to login with a fully qualified user name that is incorrect: rugcutte_funambo'@'ec2-50-16-233-200.compute-1.amazonaws.com
I tried also to change the line to : [email protected] . But I got a similar error with that as well.
I am relatively inexperienced to JDBC. What is the proper way to set up this section of the install.properties file?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您是否允许该用户从该服务器访问该数据库？
如果您尝试从 Funambol 服务器的命令行建立相同的 mysql 连接，会发生什么？
Did you enable access to that database with that user from that server?
What happens if you try and just make the same mysql connection from the command line from your Funambol server?
谢谢亚当。
你引导我找到了正确的答案。远程主机在 cPanel 中有一个区域用于配置远程数据库访问主机。所以我需要将运行 Funambol 的源主机添加到我的访问主机列表中。
之后，我运行了安装，它似乎在远程主机上运行的数据库中正确创建了表。
Thanks Adam.
You led me to the correct answer. The remote host has an area in cPanel to configure Remote Database Access Hosts. So I did, need to add my source host that is running Funambol, to my list of access hosts.
After this I ran the install and it did, appear to create the tables properly in the database running on my remote host.