vesta icon indicating copy to clipboard operation
vesta copied to clipboard

Having some issues with php/sql related to softaculous and myvesta

Open shillshocked opened this issue 5 years ago • 9 comments

Trying to reinstall my Wordpress site on a new server remotely through Softaculous. Error that it can't connect to database. I think it might be because "disabled dangerous PHP functions in php.ini." Any way to revert the changes temporarily to do the import?

shillshocked avatar Jan 21 '20 10:01 shillshocked

If i'm not wrong vesta uses own php (5.6) vesta-php package (+ioncube) in admin panel which is used to run softaculous. /usr/local/vesta/php/lib/php.ini and there is not disable_functions= in.

php.ini for sites is located at /etc/php/7.X/fpm/php.ini

I'm able to install wordpress on myvesta fresh install with multiple php and with more disabled functions without any error, could you explain how i can reproduce your issue?

azk1 avatar Jan 21 '20 13:01 azk1

I'm trying to import from another site using import under wordpress install in softaculous. Also, I downloaded it and tried a manual import. Neither succeeded. Furthermore, with the file manager plugin, I can't even see the files I copied, although they exist if I navigate the directories via ssh.

shillshocked avatar Jan 21 '20 17:01 shillshocked

When did you installed Softaculous?

dpeca avatar Jan 21 '20 20:01 dpeca

I just installed yesterday. I was able to make some progress by changing the permissions of some of my files and folders. However, I'm stuck with this error on manual import:

Could not connect to database, please check the Username/Password of your database. If changed, please update the details in Softaculous installations using Edit Details.

I've reset my mysql password and updated it in the manual directories, as well as check that I have the correct password, and yet I still continue to get this error.

Update: I was to make some headway by using my root sql login and password to get the import done. But the website now has an error when I try to load it:

Error establishing a database connection

shillshocked avatar Jan 22 '20 01:01 shillshocked

Alright, I managed to fix it by updating with the new database credentials in wp-config.php

Still, I would like to be able to do remote imports.

shillshocked avatar Jan 22 '20 02:01 shillshocked

And fresh installation of WordPress works fine?

dpeca avatar Jan 22 '20 08:01 dpeca

Yes, wordpress functions normally. The problem is importing with softaculous remotely. I think this is due to the security settings of myvesta.

shillshocked avatar Jan 27 '20 16:01 shillshocked

@shillshocked Hm, not sure I understand you.

I asked - if you go to Softaculous and choose WP and press "Install" on an empty domain, does it works?

What is ''remotely'' import? Where is it in Softaculous?

In other words, describe me exactly what you are doing, step-by-step, so I can reproduce error.

dpeca avatar Jan 27 '20 20:01 dpeca

You have to go into Apps - Wordpress - Import - Remote Import

shillshocked avatar Jan 31 '20 04:01 shillshocked