Announcement

arjoni

Member

Registered: 2015-12-10

Posts: 86

Automated hosting plugin

Hello,

I have installed Automated hosting plugin according to this guide https://github.com/LiveHelperChat/autom … oc/doc.txt .

Now when I create an instance, add the required DNS record, the instance shows "pending initialization".

I run the cronjob manually "sudo -u nginx php cron.php -s site_admin -e instance -c cron/maintain"

and it returns:

Expire status:
Array
(
)
Starting creating customer - 5
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'db_lhc'***'localhost' to database 'lhc_manage_client_5' in /var/www/manager.domain.com/extension/instance/classes/dbhandlers/mysql.php:10
Stack trace:
#0 /var/www/manager.domain.com/extension/instance/classes/dbhandlers/mysql.php(10): PDO->query('DROP DATABASE I...')
#1 /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php(80): erLhcoreClassInstanceDBMysql::deleteDB(5)
#2 /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php(122): erLhcoreClassInstance::deleteDatabase(5)
#3 /var/www/manager.domain.com/extension/instance/modules/lhcron/maintain.php(23): erLhcoreClassInstance::createCustomer(Object(erLhcoreClassModelInstance))
#4 /var/www/manager.domain.com/cron.php(99): include_once('/var/www/manage...')
#5 {main}
  thrown in /var/www/manager.domain.com/extension/instance/classes/dbhandlers/mysql.php on line 10

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'db_lhc'***'localhost' to database 'lhc_manage_client_5' in /var/www/manager.chat.e1.al/extension/instance/classes/dbhandlers/mysql.php:10
Stack trace:
#0 /var/www/manager.domain.com/extension/instance/classes/dbhandlers/mysql.php(10): PDO->query('DROP DATABASE I...')
#1 /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php(80): erLhcoreClassInstanceDBMysql::deleteDB(5)
#2 /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php(122): erLhcoreClassInstance::deleteDatabase(5)
#3 /var/www/manager.domain.com/extension/instance/modules/lhcron/maintain.php(23): erLhcoreClassInstance::createCustomer(Object(erLhcoreClassModelInstance))
#4 /var/www/manager.domain.com/cron.php(99): include_once('/var/www/manage...')
#5 {main}
  thrown in /var/www/manager.domain.com/extension/instance/classes/dbhandlers/mysql.php on line 10

Now why does it want to connect to lhc_manage_client_5 when the database configured is db_lhc (same name for user and database)?

At the tutorial there is this:

"3. In db section add
'database_user_prefix' => 'lhc_manage_client_', // Each new customer database will be created with the following pattern 'lhc_manage_client_'.customer->id. Example: "lhc_manage_customer_23""

I have added this line at my db at settings.php (manager instance):

    'db' =>
    array (
      'host' => '127.0.0.1',
      'user' => 'db_lhc',
      'password' => 'mypassword',
      'database' => 'db_lhc',
      'port' => 3306,
      'database_user_prefix' => 'lhc_manage_client_',
      'use_slaves' => false,
      'db_slaves' =>

I have no idea how to make it work. Can you try to help me?

arjoni

Member

Registered: 2015-12-10

Posts: 86

Re: Automated hosting plugin

Also what is this supposed to mean?

'manager_subdomain' => 'manage',// Change to subdomain where manager itself is located

Should I change it to /var/www/manage.domain.com or manage.domain.com?

PeopleInside

Administrator

From: Italy

Registered: 2014-04-10

Posts: 4,046

Website

Re: Automated hosting plugin

Hi arjoni,
free support I can give in the forum is limited.

I forwarded your request to the chat owner, you should wait for a reply.
Thank you,

have a nice start of the week.

---

PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Automated hosting plugin

It seems your mysql user does not have permission to create a new database...

arjoni

Member

Registered: 2015-12-10

Posts: 86

Re: Automated hosting plugin

Added the required permissions to the database user. Now I get:

Starting creating customer - 1
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lhc_manage_client_1.lh_users_setting' doesn't exist in /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php:139
Stack trace:
#0 /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php(139): PDOStatement->execute()
#1 /var/www/manager.domain.com/extension/instance/modules/lhcron/maintain.php(23): erLhcoreClassInstance::createCustomer(Object(erLhcoreClassModelInstance))
#2 /var/www/manager.domain.com/cron.php(99): include_once('/var/www/manage...')
#3 {main}
  thrown in /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php on line 139

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lhc_manage_client_1.lh_users_setting' doesn't exist in /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php:139
Stack trace:
#0 /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php(139): PDOStatement->execute()
#1 /var/www/manager.domain.com/extension/instance/modules/lhcron/maintain.php(23): erLhcoreClassInstance::createCustomer(Object(erLhcoreClassModelInstance))
#2 /var/www/manager.domain.com/cron.php(99): include_once('/var/www/manage...')
#3 {main}
  thrown in /var/www/manager.domain.com/extension/instance/classes/erlhcoreclassinstance.php on line 139

What does this mean?

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Automated hosting plugin

Perhaps your user now cannot create a tables?

arjoni

Member

Registered: 2015-12-10

Posts: 86

Re: Automated hosting plugin

It has all privileges on *.*

arjoni

Member

Registered: 2015-12-10

Posts: 86

Re: Automated hosting plugin

It creates

        lh_abstract_auto_responder    InnoDB    utf8mb4_general_ci    16,384    16,384    0    1    0    
    lh_abstract_email_template    InnoDB    utf8mb4_general_ci    16,384    0    0    4    ~ 3    
    lh_abstract_proactive_chat_invitation    InnoDB    utf8mb4_general_ci    16,384    16,384    0    1    0    
    lh_canned_msg    InnoDB    utf8mb4_general_ci    16,384    0    0    1    0    
    lh_chat    InnoDB    utf8mb4_general_ci    16,384    131,072    0    1    0    
    lh_chatbox    InnoDB    utf8mb4_general_ci    16,384    16,384    0    3    ~ 1    
    lh_chat_archive_range    InnoDB    utf8mb4_general_ci    16,384    0    0    1    0    
    lh_chat_blocked_user    InnoDB    utf8mb4_general_ci    16,384    16,384    0    1    0    
    lh_chat_config    InnoDB    utf8mb4_general_ci    16,384    0    0         ~ 23    
    lh_chat_online_user    InnoDB    utf8mb4_general_ci    16,384    49,152    0    1    0    
    lh_chat_online_user_footprint    InnoDB    utf8mb4_general_ci    16,384    32,768    0    1    0    
    lh_departament

but nothing else.

Lilo

Member

Registered: 2015-02-26

Posts: 110

Re: Automated hosting plugin

Hi arjoni
Please let me know if you get this sucessfully and help all of us ...I get stuck at creating instances .....Share some info if you coming alright

Lilo

Member

Registered: 2015-02-26

Posts: 110

Re: Automated hosting plugin

Hi Arjoni
Did you manage to win on installing auto hosting?