douxian1923 2017-10-15 21:03
浏览 56
已采纳

连接超时 - Db - Codeigniter

I am trying to connect to a db from my ec2 instance. It works fine on my local-dev machine. With the same credentials though on my ec2 instance it throws this error. How would I bump up the timeout connection w/ CodeIgniter 3?:

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Connection timed out

Filename: mysqli/mysqli_driver.php

Line Number: 161

Backtrace:

File: /opt/workspace/api.my_app.com/index.php
Line: 292
Function: require_once

Unable to connect to your database server using the provided settings.

Filename: core/CodeIgniter.php

Line Number: 500
  • 写回答

1条回答 默认 最新

  • doujiangqu2823 2017-10-15 23:45
    关注

    Here are the places I would check:

    • EC2 security group rules for IN traffic - it's possible your EC2 instance's IP address isn't being allowed, while your local-dev IP address is. This is especially possible if you're using RDS - make sure port 3306 is open to IN traffic on the RDS from EC2's IP address.

    • if MySQL is installed directly on the EC2 server (I wouldn't recommend this for large traffic use cases!), check your settings in application/config/database.php to make sure you're using the right credentials. In this case, it kind of sounds like the DB HOST is misconfigured - if the IP address is wrong, it'll time out on the connection.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 iqoo11 如何下载安装工程模式
  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?