将 Funambol 连接到远程主机上的 MySQL

发布于 2024-10-09 08:15:26 字数 1115 浏览 7 评论 0原文

我正在 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

凉城凉梦凉人心 2024-10-16 08:15:26

您是否允许该用户从该服务器访问该数据库?

如果您尝试从 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?

世界等同你 2024-10-16 08:15:26

谢谢亚当。

你引导我找到了正确的答案。远程主机在 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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文