Topic: Mibew Installation error on check-connection

[khsana08]

Hi all,

I have done the installation steps till step 6. Using your web browser visit http://<yourdomain>/mibew/install and
   perform step-by-step installation.

Then I got an error on the browser says:

Correct the mistakes:
Could not connect. Please check server settings in config.yml. Error: SQLSTATE[28000] [1045] Access denied for user 'rafehh_mibew222'@'69.172.198.52' (using password: YES)

Here is my config.myl

Code: [Select]

# IMPORTANT: Before install mibew copy this file to config.yml and fill it with
# your own settings!


# MySQL Database parameters
database:
    host: "netfone.ca"
    port: 3306
    db: "rafehh_mibew"
    login: "rafehh_mibew222"
    pass: "mypasswordhere"
    tables_prefix: ""
    use_persistent_connection: false

# Mail
## This value will be used as sender address in all e-mails Mibew send.
mailbox: mibew@yourdomain.com

## Mailer parameters
mailer:
    # This value determines what kind of mailer will be used. Possible values
    # are "mail" and "smtp".
    #
    # To use standard PHP mail function just set this option to "mail". No
    # additional configs are required in this case.
    #
    # To use SMTP-based solution set this option "smtp". This approach require
    # some extra configuration to be done (see below).
    transport: mail

    # The lines below represents default SMTP mailer configurations. They will
    # be used only if the "transport" option is set to "smtp".
    host: netfone.ca
    port: 25
    user: user
    pass: "khsana0009"
    # The following option determines what kind of encryption should be used.
    # false means no encyption at all. Another values once can use are "ssl" and
    # "tls".
    encryption: false

# Cache subsystem
cache:
    # This value determines where the cached data will be stored. Possible
    # values are "none", "file_system" and "memcached".
    #
    # If "none" is used the caching will be disabled. This option should be used
    # only if none of the other options works.
    #
    # If "file_system" is used the cached data will be stored in files within
    # the "cache/" directory. Notice, that the file system storage does not work
    # on NFS systems bucause exclusive file locks are not supported where.
    #
    # If "memcached" is used the cached data will be stored in Memcached
    # storage. Before using this kind of storage make sure PHP's memcached
    # extension is installed and enabled.
    storage: file_system

    # The lines below represents default Memcached server configurations. They
    # will be used only if the "storage" option is set to "memcached".
    memcached_servers:
        - host: localhost
          port: 11211
          # The "weight" field is optional and can be omitted.
          weight: 0
          # Actually, one can use any number of memcached servers he wants. Just
          # add servers description like the one above.

# Locales
## Native name will be used in this locale
home_locale: en
## If user does not provide known lang
default_locale: en

# A timezone to use. Leave this value empty to use the default timezone from the
# system settings. For the details about available timezones see
# http://php.net/manual/en/timezones.php
timezone: ""

# Plugins
plugins: []

## Exapmle of plugins configuration
# plugins:
#     "VendorName:PluginName":
#         weight: 100
#         some_configurable_value: value
#     "VendorName:AnotherPluginName":
#         very_important_value: "$3.50"

Please let me know if you need further info to my question

Thank you
Khalil

[scalior]

When trying to authenticate to MySQL, the connection is coming from the IP 69.172.198.52. When you created the user rafehh_mibew222, did you also give the user permission to access the database from that IP?

If you can use the mysql command line, you can try to login to the database from the server where your chat server is running.

More information in the MySQL docs.

[khsana08]

When you created the user rafehh_mibew222, did you also give the user permission to access the database from that IP?

Thanks for the reply, I am not sure what you mean, but I attach an image as what I understood from your question

Please check attached.

Thank you

[scalior]

Instead of
 host: "netfone.ca"

Try
 host: localhost


This is my configuration. I noticed that I also don't have quotes (") surrounding the values.
 

Code: [Select]

# MySQL Database parameters
database:
    host: localhost
    port: 3306
    db: wurrdmibew
    login: wumb2
    pass: xxxxxxx
    tables_prefix: inst1_
    use_persistent_connection: false



[khsana08]

Instead of
 host: "netfone.ca"
Try
 host: localhost

THANK YOU VREY MUCH, It works