Hi guys I cannot install wordpress i receive this error
- ApplicationInstallationError
- PackageInstallationError:Object reference not set to an instance of an object.; at SolidCP.Server.Code.WpiHelper.InstallApplication(String appId, List`1 updatedValues, String languageId, EventHandler`1 installStatusUpdatedHandler, EventHandler`1 installCompleteHandler, String& log, String& failedMessage) at SolidCP.Providers.Web.WPIWebApplicationGallery.WPIApplicationGallery.InstallApplication(Int32 UserId, String webAppId, List`1 updatedParameters, String languageId, StringResultObject& result) at SolidCP.Providers.Web.IIs60.InstallGalleryApplication(Int32 UserId, String webAppId, List`1 updatedValues, String languageId)
Hello,
‘root’@’WIN-2J5L7K5GTLI.veselaj.local’ (using password: YES)
Means that your root username or password isn't correct.
Please note that the most common issue is that the root user is locked to "localhost" (it will look something like root@localhost)
The safest way is to make a unique user with full privileges in mysql / mariadb with host % or in your case hostname: WIN-2J5L7K5GTLI.veselaj.local
Once configured in sql and SolidCP Portal (the mysql / mariadb service) it should work out.
Also note that you need the mysql .net connector installed (any version will do).
Regards,
Marco
No problem, glad you solved the first one 🙂
The second one is a bit of a generic one, but i did see it once before when i tried to install directly after fixing the previous problem without starting the application gallery from scratch.
Did you try to go out of the install page, back to your space home page --> then start from scratch --> Application gallery --> Wordpress --> install?
If that doesn't help could you check the installation log file for further information?
I try as you said, now shows this error
- DatabaseUserCreationError
- The operation you requested has failed to complete
Does your database user meet the standard requirements? (in total max char limit of a SQL user is 16 that includes any prefix or suffix you have set), password complexity and so on ?
(most easy way would be to try and create a SQL user directly under the databases tab rather then through the application gallery)
it has prefix its user id "4_databasename" and i do use password complexity
when i create the database from database tab i cannot login to phpmyadmin, i get this error
#2054 - The server requested authentication method unknown to the client
Languagemysqli_real_connect(): The server requested authentication method unknown to the client [mysql_old_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
so i have to login with root to change the password of that user that i create then i can login and install wordpress
hmm, generally when / if the login / password doesn't work it's usually due to complexity miss match.
My personal favorite to test with is something like P@ss1001 (it generally passes most requirements by software)
that being said what mysql version and mysql .net connector version?
I change (I type the same password as i used to create from solidcp) the password in phpmyadmin and works i can login
i use mysql 5.5 and .net connector 6.5.4
Alright, but if you try P@ss1001 within SolidCP it still has the same issue?
(as solidcp passes through code chars used in coding can cause some issues sometimes, it's why a common test pass kind of excludes those possabilities from your issue)
Yeah its the same issue, i can show you if u have TeamViewer
As it's nearly 2 AM here i am about to hit the sack, but i can check it out tomorrow if you want.
As far as the issue goes: it is a configuration issue at some point (as we deployed many mysql and mariadb servers in the past months, i can confirm the code it self does work - in general a default setup without strict mode enabled at installation should suffice without additional modifications, for custom settings the only thing i can confirm is prefix works without issues, i did not test anything else in my deployments.)
can someone support me in this problem?
DatabaseUserCreationError
– The operation you requested has failed to complete
some time i get this
- ApplicationInstallationError
- Failure: The database '4_my_site_db' could not be created. Access denied for user 'root'@'WIN-2J5L7K5GTLI.veselaj.local' (using password: YES)
Hi,
We have not seen this type of error before. We do recommend you create a different user for the database and not use the root login. If you can try make another user with full permissions and try that for me?
Thanks,
Trev
