If you can grab it in text mode (from Putty, for example), then you can use a find-and-replace to hide your username by swapping it for something else.
Anyway, now that you have SSH access, just reapply all permissions, it might magically solve all your problems.
So in SSH I set the rigths again;
chmod -R 755 .
chmod -R 775 cache custom modules themes data upload
chmod 775 config_override.php 2>/dev/null
(sudo is not needed says my provider)
I donât see any difference, Show Leads, etc all not working, no dashboard, progress indicator keeps turning;
The browser dev. console show errors, like this last ones after home refresh:
So I was able to use chmod (although my provider says it is not necessary because this goes automatic on uploading) on all files/folder -R
But I canât use sudo, i.e. if I use sudo chown xxx:xxx manifest.php then I get
-bash: sudo: command not found
Same error if try crontab
No changes so far, still no content on Show , the Admin Menu seems to work, in Shedule I see 14 job, some Inactive.
On myhost I have no cronjobs, not sure where I can see âdifferent usersâ cronjobs?
A[Mon Jun 25 19:58:42.356925 2018] [error] [pid 11692] mod_proxy_fcgi.c(848): [client 81.83.9.82:58448] AH01071: Got error âPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_base has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 321\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_fault has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1455\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_xmlschema has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1744\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soapval has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 2924\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soap_transport_http has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 3227\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_server has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 4733\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; wsdl has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 6069\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_parser has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 8205\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_client has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 9057\nâ
[Mon Jun 25 19:59:22.889221 2018] [error] [pid 18234] mod_proxy_fcgi.c(848): [client 81.83.9.82:58633] AH01071: Got error âPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_base has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 321\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_fault has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1455\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_xmlschema has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 1744\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soapval has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 2924\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; soap_transport_http has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 3227\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_server has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 4733\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; wsdl has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 6069\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_parser has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 8205\nPHP message: PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; nusoap_client has a deprecated constructor in /data/sites/web/xxxxxbe/subsites/crm.xxxxx.be/include/nusoap/nusoap.php on line 9057\nâ
All those âdeprecatedâ errors are safe to ignore. Weâll take care of those when weâre preparing to make some older PHP versions unsupported.
If you canât use sudo, just try the command without sudo. Your hosting might let you use some (restrained) versions of those commands.
As for the crontab, if you use âcrontab -u usernameâ you will see each userâs crontab.
Your hosting is probably right, maybe none of this is necessary because if they set the ownerships for you, and donât let them change them, then they should be right.
Basically, all you need to check is that if your web server is running under user âjoebloggsâ, then the files in that âls -alâ command are owned by âjoebloggsâ. If some of them arenât, you need to set ownerships. If after setting ownerships they break again, you need to check crontab user because itâs likely your cron jobs that are messing things up.
I understand the rights, I was able to use chmod and chown -R on all files/folders. Now I canât see any user/group with other than my name.
The providers says to open crontab manually in ssh for edit with vi, in folder /etc.
There I have only this line:
*/5 * * * * cd /data/sites/web/xxxxbe/subsites/crm.xxxx.be; php -f cron.php > /dev/null 2>&1
In the meantime I setup a complete new v7.8.3 on another host. I was able ro restore a DB and it seems to work fine. Now I can try the Upgrade here.
Is there a way to see a CRM version or a DB date in de SQL backup file?
Can I import a DB from v7.8.20 into a v7.8.3? Does the version matters?
I noticed that Search donât return any result? I enter like %text in the top right box, but I get an emptu result with basic search on it. Do I need to repair an index somehow?
Is there a way to see a CRM version or a DB date in de SQL backup file?
You can see the upgrade_history table, sort by date to see the latest âinstalledâ package. This has upgrades, Iâm not sure what it has on a clean installâŚ
Can I import a DB from v7.8.20 into a v7.8.3? Does the version matters?
Normally it is not advised to import a DB into anything except the exact version where it was exported.
I noticed that Search donât return any result? I enter like %text in the top right box, but I get an emptu result with basic search on it. Do I need to repair an index somehow?
Yes you might have to set up cron jobs so AOD will index again, which might take hours with lots of data, or force a Reindex if necessary (see https://pgorod.github.io/Reindex-AOD/ )
Have you tried simply migrating your 7.8.3 to the new server, and trying the upgrade there? Maybe the problem youâre getting wonât happen on the new serverâŚ
alright, so on my test hosting the upgrade worked fine, now I have a working v7.10.6
I did need to re-set the rights 775 and 755 on all files/folders before the upgraded version worked fine.
But the search functions still only seems to find recent edited items. I added the crontab code 4h ago, maybe it takes more time? Is there a way to check crontab is OK?
Maybe I need to do the manual steps mentioned before.
So what steps are best to move my working test host setup back to the original host?
Itâs possible that Reindexing takes more than 4 hours, but youâd have to have a LOT of data for that to happen. Itâs also possible, that there is no Reindexing taking place, and that explains why only recently created or edited items are going into the index.
I gave you a link above explaining how to force reindexing.
But before that⌠I am still not content that your ownerships/permissions are properly installed. Our talk is too vague for me to know, and you have weird things (like âI did need to re-set the rightsâ) which make me suspect something is still not right.
You need to achieve exactly and surely this:
the web server user name is X
the files and directories are all chownâed to X
the crontab that runs cron jobs is Xâs crontab, not the crontab of another user.
If youâre getting permissionsâ degradation (you set things right, they become wrong afterwards) one of these things isnât right.
The index is OK.
It was me, doing a wrong search, i.e. %carp doesnât find carparts, I do need to enter the full word, like %carparts before it show.
Somehow I thought this worked earlier with the short version, or like this %carp%. No diffrence in result with 1 or 2 % signs.
About the migration, no the version donât match, on my test host I have 7.10.6, but on the original host I canât the upgrade to work, it is stuck at 7.8.20.
But why do I need the orginal host data? All I need is in the test host on the latest version.
Can I just delete all files and move the others from the test host? Then export en import the DB?
I think I need to make myself more clear.
The test host is already on v7.10. So if I like to move this good working set to my original host. I think I need to fresh install there v7.10 and then migrate the database. Or can I just copy all the files and folders with filezilla instead of the install?
Or maybe I just start using this host, but then I like to change the folder, can move the files 1 level higher? Like crm.domain.com/suitercrm to crm.domain.com, is that possible or do I need to change config somehow?
Thanks for all the effort so far, Iâm getting real close to a final solution.
What you want to do is not possible, you need to do what you donât want to do, which is what I described above.
You canât move 7.8 data into a 7.10, unless you do a much more tedious and risky process of exporting and importing individual tables, including relationship tables, while adapting to any structural changes. Itâs really not worth it.
You said you couldnât upgrade your 7.8.20, why is that? If you can solve that problem you will get more options.
Iâm afraid there is a misunderstanding here.
My initial problem was that I got stuck on v7.8.20 because when I try to upgrade to v7.10 the setup wizzard didânt get any further after uploading the upgrade package. Whatever I tried, rights, cache,⌠no luck.
So I started a new install of suitecrm 7.8.20 on a test server import my DB from the orginal and there I could do the upgrade to 7.10 without issues.
Now I would like to copy the working 7.10 on the test server to the orginal location where the non-upgradeable 7.8.20 still is.
Ok, I thought your 7.10 was a clean install without any data. If you imported all the data when it was still in version 7.8.10, then it should be ok - unless you have new data from this past week or so that you need to include? If you do, youâre back to the problem I was saying in my previous post.
There are two moves you can do with SuiteCRM
Migration to a clean installation (this means merging database and custom files into a fresh SuiteCRM on a different server).
Upgrade the server (this can only be done through upgrader scripts, never through simple file copy
So the rule is: you should never attempt the two at the same time. If you need both (go to a new server with a newer version), you have to do one first, until itâs successful, then the other. So you migrate the old version, and then upgrade OR you upgrade first, and then migrate it.
It seems you are asking about a third option
Just move everything!
So are you ok to simply WIPE OUT what you have in the old server, and migrate all files and entire database, as it is now in the new server?
Yes my test server works fine and seems complete, altough I notice 1 glitch in the Lead view, the column E-mail shows the e-mail twice, first in bold red with the dotted line and immediatly there after a second time in normal text, with no space between the two.
Contact and Account view is OK with only the red email. I tried removing E-mail from the layout in Studio and then re-adding it but it stays the same.
Also I personalised the Lead Edit view and this modifactions seems lost and is back to standard now somehow. But that is a small thing to do over again.
So now Iâm considering 2 options:
Deleting the corrupt setup on the old server. Then moving the setup from the test server to the original location. Therefor I would erase all files/folders and DB on the old server and start a new fresh v7.10 setup (the same version as on the test server) and then migrating the DB.
Forgetting the orginal server and keeping the setup on test server, all seems OK there. But ideally I like to move it to a folder higher up, now it is in crm.testdomain.be/suitecrm and I like to have it in crm.testdomain.be just like it was on the orginal server on another domain.
Can I just the move the files/folders 1 folder higher?
About the folder locations of the files. Now on my test setup, Admin profile, tab Advanced, section calendar Options, I see the current folder location for Publish and iCal location. But I canât change these fields, do I need to Reset User Preferences, in order to actualise these?
About the Email showing double, can you please post a screenshot? If you have trouble uploading here, use https://pasteboard.co
About moving to the old server, I probably donât even have to install a fresh 7.10. there, you can simply move the entire SuiteCRM directory and the database, it should work.
Check config.php if youâre changing domain name (entries site_url and host_name)
You can move one level up, as long as you adjust settings on your Web server configuration accordingly. Donât forget to set correct ownerships/permissions.
Iâm not sure I understand your issue with the iCal folders, but that might be solved with what I said above regarding config.php entries.