There wasnāt any rows in this table. Iām not sure why the install script didnāt insert the user name into the table. So, I added 1.
Not sure where to put the password and what type should it be plain text or MD52 hashed. Also not sure what other columns need to be filled in to this to be a valid row.
Delete config.php, config_override.php, config_si.php files. Drop the database. Set correct permissions and reinstall using commands with admin rights.
I have done this numerous times (see my other post on āInstalling 8.7.1 on Shared Hostingā) and the install script does not create all the tables (outbound_mail is the only table it doesnāt create) and discovered that the 2nd step of the install (database connection, username/password) does not insert the username and password into the User table. (hence the reason why Iām posting this)
To make matters worse, I fail to see anywhere in the various log files the actual messages I see coded in the install.php scripts.
I did that when I copied the files to the sserver. And again after going through the install script (at login screen but before I tried to log in.). What Iām not sure is the chown commnd. Remember this is on a shared hosting so itās the user account thatās the owner of the folder, not the server account.
Thanks ā please note Iām using a shared hosting platform. I donāt need to install the install php modules, database server or create the database. thatās a step I have to do before the install.
This would work if I was running my own Linux server.
So, Iām going through the script and removing the parts I donāt need.
It seems that I canāt run shell scripts on a shared host platform. And I canāt use sudo in the script either.
I had to edit the script and add 1 additional prompt ā the db_host since this is not a ālocalhostā configurationā¦ And comment out a lot of lines ā (install Maria, etc)
However, I will try this script on my local server ā after I build it. Thanks for trying to help.
Yes, local server or a server you control 100%, this will work. This was not design for shared servers, sorry.
Maybe some one in the community could pick up the code and adapt it?
Not all shared hostings are alike. Some of them have more permissions than others.
Lots of people run SuiteCRM successfully on shared hostings but I would say that the hosting needs to be carefully picked before starting, to make sure it has all you need.
One basic thing I would never dispense with is having SSH access through a terminal.
Last try: Check your suitecrm admin password. I noticed that if you use any of these characters ā " ` < > in password you wonāt be able to log in. Also if your copy/paste password touch password field (space/backspace) before pasting. I had some issues with copy/pasting passwords.
I agree. In the case of some shared hosting companies, they limit the scope of what you can do via terminal. With this one, it appears that their bash shell is turned off. What I didnāt try was copy/paste the commands replacing the variables with the correct info.