problem installing when APP server is different from DB server.

kremrem · 2017-08-27 17:22:52

At the localhost - all OK.
On hosting - step 1 -> step 2 -> step 3 ->step 1.... But all folder permission is green.
Then I tryed copy local installed version with importing tables to remote server with correct settings manually.
Answer: Cannot connect to database. If you are installing application please use /index.php/install/install url. If you keep getting this error please check that application can write to cache folder and cgi.fix_pathinfo = 1
I think - some settings cashed from local host. Where it clean?
I can`t find answer on forum. Help.

May be problem at this - DB server and APP server is different servers?

Last edited by kremrem (2017-08-27 18:54:58)

PeopleInside · 2017-08-27 20:41:19

Hi, welcome in the live chat forum.

If you try to transfer a localhost install to web you can have issue.
Please try to do a clean install on the web.
Instructions here:
https://forum.livehelperchat.com/viewtopic.php?id=2193

If you really need transfer the localhost install and you are unable to do please follow the commercial link on my signature,
support will be not free.

kremrem · 2017-08-27 20:58:05

no. I need clean app. But it is not possible - in my happening APP server is different from DB server. Your app cant work with it!

PeopleInside · 2017-08-27 21:02:45

I cannot understand you.
What set you followed for install LHC?
What you mean with APP server is different from DB server?

kremrem · 2017-08-27 21:04:39

Your script can not work if the database server is on a different host address

Last edited by kremrem (2017-08-27 21:05:24)

PeopleInside · 2017-08-27 21:06:07

I think can work if you set different address and not localhost and if the server allow external database.
There are commercial support if you need.

kremrem · 2017-08-27 21:10:17

Can not. From my host all scripts are normally connected to the same host's database. And I would not go through the installation step 2 if the connection was not established. You can check it yourself. This does not require paid support. But your script still very much is pleasant to me and I went the way to apply it.

Last edited by kremrem (2017-08-27 21:12:46)

PeopleInside · 2017-08-27 21:12:54

Topic solved.
Commercial info is on my signature.

If you want you can do a celan install on web as I said and not try to use the local install.

PeopleInside · 2017-08-27 21:23:39

What address do you put inside localhost?

Servers should allow use of external database.
If you think you found a bug please open a GitHub report here:
https://github.com/LiveHelperChat/livehelperchat/issues

Thank you.

Last edited by PeopleInside (2017-08-27 21:24:30)

suporte.agencialink · 2017-11-01 20:00:05

Hi, I have the same problem.

I unzipped the files, and uploaded to my server. Then I run the install script.
It asks for the database credentials, then the admin credentials.
After the admin credentials, the installation goes back to step 1.

I have double-checked the database password, the database server ip address and port, but no luck.

PeopleInside · 2017-11-01 22:33:55

Hi suporte.agencialink,
thank you for your message. Please check server error logs.

Can you share here the link where you live install is?
Maybe I can give a quick check you can check on the developers tools of the browser if some errors happen.

suporte.agencialink · 2017-11-06 11:23:40

Hi, here's the link:
http://chat.agencialink.com

When I use a local database (localhost), the installer works. But when I use a remote database (using ip address or hostname), the installer fails.

suporte.agencialink · 2017-11-06 11:24:45

If you want, you can use this link for testing purposes - nobody is using it yet.
Thank you!

PeopleInside · 2017-11-06 11:27:31

suporte.agencialink wrote:

When I use a local database (localhost), the installer works. But when I use a remote database (using ip address or hostname), the installer fails.

Maybe this depends from your server configuration.
If you think there are issue with Live helper chat please follow link on my signature "Commercial Support / GitHub"

Have a great day!

Last edited by PeopleInside (2017-11-06 11:28:33)

suporte.agencialink · 2017-11-07 11:46:20

Now I got it.

The problem is that my database server does not have the utf8mb4 collate. It has nothing to do with being an external or local server.

To work around this, change the line 55 in the file lhc_web/lib/core/lhcore/lhdb.php. Change "utf8mb4" to "utf8" and "utf8mb4_unicode_ci" to "utf8_unicode_ci". Then, run the installer again, and it should work.

PeopleInside · 2017-11-07 12:00:12

In my server and install no issue.
Thanks for share the solution that work for you

Last edited by PeopleInside (2017-11-07 12:01:28)

Announcement

#1 2017-08-27 17:22:52

problem installing when APP server is different from DB server.

#2 2017-08-27 20:41:19

Re: problem installing when APP server is different from DB server.

#3 2017-08-27 20:58:05

Re: problem installing when APP server is different from DB server.

#4 2017-08-27 21:02:45

Re: problem installing when APP server is different from DB server.

#5 2017-08-27 21:04:39

Re: problem installing when APP server is different from DB server.

#6 2017-08-27 21:06:07

Re: problem installing when APP server is different from DB server.

#7 2017-08-27 21:10:17

Re: problem installing when APP server is different from DB server.

#8 2017-08-27 21:12:54

Re: problem installing when APP server is different from DB server.

#9 2017-08-27 21:23:39

Re: problem installing when APP server is different from DB server.

#10 2017-11-01 20:00:05

Re: problem installing when APP server is different from DB server.

#11 2017-11-01 22:33:55

Re: problem installing when APP server is different from DB server.

#12 2017-11-06 11:23:40

Re: problem installing when APP server is different from DB server.

#13 2017-11-06 11:24:45

Re: problem installing when APP server is different from DB server.

#14 2017-11-06 11:27:31

Re: problem installing when APP server is different from DB server.

#15 2017-11-07 11:46:20

Re: problem installing when APP server is different from DB server.

#16 2017-11-07 12:00:12

Re: problem installing when APP server is different from DB server.

Board footer