That was it, thanks. On Friday, 24 November 2017 07:08:20 UTC, Ivan Necas wrote: > > 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] <javascript:>> > 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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.
