If youāre willing to start a new VM I would say it can be a good option - weāre really lost on your current serverā¦
And it could be a good time to upgrade to PHP 7 if you havenāt done so already - much safer and faster.
Here are some of my Ubuntu Server 16.04 install notes that will save you some time and give you some pointers:
Software selection on installation: LAMP, Samba (if you want it), SSH
Get all modules quickly:
apt install zip unzip php-mbstring php7.0-mbstring php-gettext php-xml-parser php7.0-zip php7.0-imap php7.0-gd php7.0-curl sendmail phpmyadmin
You might want to add php-xdebug to that list if itās not production server.
Things to edit in php.ini:
nano /etc/php/7.0/apache2/php.ini
upload_max_size = 16MB (or bigger)
memory_limit=512M
fix error_reporting, add & ~E_STRICT
date.timezone = āEurope/Lisbonā
-also set timezone in the other php.ini of the CLI
/etc/init.d/apache2 restart
-copy files from SuiteCRM package into /var/www/html
cd /var/www/html
sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php
Now install the app via whatever address you have:
http://10.0.0.20/suitecrm/install.php
crontab -e -u www-data
add the folllowing line:
-
-
-
-
- cd /var/www/html; php -f cron.php > /dev/null 2>&1
Good luck!
If I follow your notes and install ubuntu versus centos, after installing a blank iteration of suiteCRM 7.7.8
what issues will I have copying down the code and database from the centos production server?
Thank You PGR.
I changed OS to ubuntu 16.04 server and am now able to run check/repair and save field changes prior to import.
It remains a mystery why I could not restore code and database from centos production server to centos shadow server.
But enough time has been taken I donāt care to pursue the mystery, only to move forward and please the customer.
If you migrate between the two exact same versions, as you are planning to do, it should work pretty well.
There are some advantages to starting from a clean install, but you might lose them if you copy ALL your files over. Better to copy only whatās needed, though sometimes this can be a pain to determine.
Sometimes itās enough to bring over the database, the upload directory, and parts of the custom directory.
Do you have many customizations? Only Studio stuff, or also some custom developments in PHP?
I have php customizations,studio stuff. So far everthing looks good.
for file importing, do I need to first export the csv template? I have the raw access database file in itās structure. Is it best to cut and paste columns or to just run the import on the raw csv making sure to map the fields correctly?
I donāt know exactly what you mean by āfile importingā, but if you mean the database, I normally donāt migrate with CSV exports/imports, I just dump the whole DB and then read the entire thing on the new system.
I canāt check right now, but from memory: you use mysqldump command to produce the file, and then something like
mysql < thefile
on the destination system to replay it (itās a set of commands in plaintext, containing all the CREATE TABLEs and INSERTs necessary).
Google mysqldump, ābackup and restore MySQL databaseā, etc.
I understand the proper mysql restore procedure. I was able to rebuild the database from the Centos7.3 production server onto the Ubuntu 16.04 shadow server.
It appears as all SuiteCRM features and customization were replicated except for the following:
I have a problem importing new contact data using the āimportā feature within SuiteCRM. It fails after exactly 100 records are imported.
If you change the order or the contents of your import, does it still fail at 100? Iām trying to figure out if the difficulty is with a specific record that happens to be number 100, or if itās a matter of quantity. Of course, it should do a lot more than 100 without problemsā¦
No, it is exactly 100 records.
I can use the same csv on the productions server and it displays the dialog 100 of 2500, 20 of 2500 ā¦ until all records are imported. Since it is a productions server I do it after hours and then restore the database. The import does end with about 20 records not imported, but they are displayed in an elegant manner. I think it must have something to do with php scripting. The Ubuntu server is using php7 and the production server is php5.
I have been able to install suiteCRM correctly on my shadow server correctly using the BitNami stack. now working on how to access mysql in that environment. I thank you for your help to this point, I am pursuing another path to getting a usable shadow server.
Iām glad you got the other server working.
I donāt know about the import. Maybe it could be the memory_limit or the timeout setting in php.ini?.. make sure you have generous settings there.