Seeing the facts, that the connection seems to work from scripts but not from the service, I would recommend trying `setenforce 0` for start to rule out SELinux could be the case here
-- Ivan čt 23. 11. 2017 v 20:57 odesílatel <[email protected]> napsal: > Hi, im running into this issue with foreman 1.15 and an external rds mysql > database > > the installation from a fresh new ami: > > foreman-installer \ > --foreman-db-type=mysql \ > --foreman-db-host=host.us-west-2.rds.amazonaws.com \ > --foreman-db-database=foreman \ > --foreman-db-username=foreman \ > --foreman-db-password=password > > I can telnet the db host from the server port 3306 and connect with the > same credentials from /etc/foreman/database.yaml from the command line > using the mysql command. > > The instalation does create the tables inside the database, so the > connection can be possible from the host. > > after that:: > > Web application could not be started > > Can't connect to MySQL server on > 'engineering.ctkb3rwlea2h.us-west-2.rds.amazonaws.com' (13) (Mysql2::Error) > > /opt/theforeman/tfm/root/usr/share/gems/gems/mysql2-0.4.5/lib/mysql2/client.rb:89:in > `connect' > > /opt/theforeman/tfm/root/usr/share/gems/gems/mysql2-0.4.5/lib/mysql2/client.rb:89:in > `initialize' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in > `new' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in > `mysql2_connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:438:in > `new_connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:448:in > `checkout_new_connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in > `acquire_connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:349:in > `block in checkout' > /opt/rh/rh-ruby22/root/usr/share/ruby/monitor.rb:211:in `mon_synchronize' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:348:in > `checkout' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:263:in > `block in connection' > /opt/rh/rh-ruby22/root/usr/share/ruby/monitor.rb:211:in `mon_synchronize' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:262:in > `connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:571:in > `retrieve_connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_handling.rb:113:in > `retrieve_connection' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activerecord-4.2.5.1/lib/active_record/connection_handling.rb:87:in > `connection' > > /opt/theforeman/tfm/root/usr/share/gems/gems/ancestry-2.2.1/lib/ancestry/has_ancestry.rb:46:in > `has_ancestry' > /usr/share/foreman/app/models/concerns/nested_ancestry_common.rb:7:in > `block in <module:NestedAncestryCommon>' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activesupport-4.2.5.1/lib/active_support/concern.rb:120:in > `class_eval' > > /opt/rh/sclo-ror42/root/usr/share/gems/gems/activesupport-4.2.5.1/lib/active_support/concern.rb:120:in > `append_features' > /usr/share/foreman/app/models/taxonomy.rb:5:in `include' > /usr/share/foreman/app/models/taxonomy.rb:5:in `<class:Taxonomy>' > /usr/share/foreman/app/models/taxonomy.rb:1:in `<top (required)>' > > /opt/rh/rh-ruby22/root/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:54:in > `require' > /opt/rh/rh-ruby22/root/usr/share/rubygems/rubygems/core_ext/ker > > -- > You received this message because you are subscribed to the Google Groups > "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
