Htaccess causing errors after install

D3rv · 3 November 2021 16:09

ok i will try with apache2 im not familiar with it so may take some tinkering lol

D3rv · 3 November 2021 16:15

does this look right for apache config

<VirtualHost *:80>
     ServerAdmin www-data
     DocumentRoot /var/www/suitecrm/public
     ServerName bmfcrm.ddns.net
 

     <Directory /var/www/suitecrm/public>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/error.log
     CustomLog ${APACHE_LOG_DIR}/access.log combined
    
     <Directory /var/www/suitecrm/public>
            RewriteEngine on
            RewriteBase /
            RewriteCond %{REQUEST_FILENAME} !-f
            RewriteRule ^(.*) index.php [PT,L]
    </Directory>
</VirtualHost>

clemente.raposo · 3 November 2021 16:21

Hi @D3rv,

yes. Though I would remove the following, that should already be included in the .htaccess on /var/www/suitecrm/public

D3rv:

     <Directory /var/www/suitecrm/public>
            RewriteEngine on
            RewriteBase /
            RewriteCond %{REQUEST_FILENAME} !-f
            RewriteRule ^(.*) index.php [PT,L]
    </Directory>

D3rv · 3 November 2021 16:26

ok last question for now i try to log in and it tells me the username password is worng anyway to reset it

clemente.raposo · 3 November 2021 16:39

Hi @D3rv,

There is a known issue on this install process with passwords that with some special chars. This may be the issue you are facing.

This issue has been fixed, though not sure it went on RC or if was afterwards.

If you password has special chars that aren’t supported by urls. You need to go to your .env.local that should look something like:

"DATABASE_URL=\"mysql://<username>:<password>@<host>:<port>/<dbName>\"";

Then replace whatever you have on <password> with a version where the special chars are URL encoded

D3rv · 3 November 2021 16:41

im currently just reinstalling it to try and start fresh thanks for your help so far

D3rv · 3 November 2021 17:07

ok hopefully this will be the last problem i shave but i get this now

clemente.raposo · 3 November 2021 17:09

Hi @D3rv,

Could you check the php error log please? Is there any error there?

Another log to check is /public/legacy/suitecrm.log

D3rv · 3 November 2021 17:21

Wed Nov  3 16:43:02 2021 [16691][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:44:01 2021 [19921][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:45:02 2021 [21373][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:46:01 2021 [21589][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:47:02 2021 [21627][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:48:01 2021 [21654][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:49:02 2021 [21671][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:50:01 2021 [22137][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:51:01 2021 [22168][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:52:02 2021 [22185][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:53:01 2021 [22209][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:54:02 2021 [22226][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:55:01 2021 [22243][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:56:02 2021 [23559][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:57:01 2021 [23578][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:58:01 2021 [23602][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:59:01 2021 [23620][-none-][FATAL] cron.php: missing expected allowed_cron_users entry in config.php. No cron user checks will occur.
Wed Nov  3 16:59:38 2021 [21567][1][FATAL] User update error: Temp User is not retrieved at ID 1, boolean given
Wed Nov  3 16:59:38 2021 [21567][1][FATAL] Email address save error

clemente.raposo · 3 November 2021 17:59

Thanks @D3rv

Could you also check php error log. It should be in /var/log/apache2/error.log

D3rv · 3 November 2021 19:00

   Wed Nov 03 19:12:48.399762 2021] [mpm_prefork:notice] [pid 29580] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[Wed Nov 03 19:12:48.544846 2021] [mpm_prefork:notice] [pid 29580] AH00163: Apache/2.4.38 (Raspbian) configured -- resuming normal operations
[Wed Nov 03 19:12:48.544896 2021] [core:notice] [pid 29580] AH00094: Command line: '/usr/sbin/apache2'
[Wed Nov 03 19:12:55.279903 2021] [core:alert] [pid 27243] [client 81.101.43.59:58486] /var/www/suitecrm/public/legacy/.htaccess: Invalid command 'Option', perhaps misspelled or defined by a module not included in the server configuration, referer: http://bmfcrm.ddns.net/

D3rv · 3 November 2021 19:25

i finally got it the ,htaccess file had some errors in it, not sure how as i hvent touched it but seams to be working now

Now i have to figure out how to integrate it with xero and ill have half the puzzle solved lol

clemente.raposo · 4 November 2021 12:46

Hi @D3rv,

Glad to know you were able to solve it.

D3rv · 8 November 2021 19:29

Well i thought i was making progress but not his is happening

D3rv · 8 November 2021 19:39

its ok i got it .htaccess was messed up

clemente.raposo · 9 November 2021 09:46

Hi @D3rv,

Great. After changing .htaccess it started working correctly, right?

jang430 · 10 July 2022 00:58

Why do you have all those lines in htaccess? Mine doesn’t have any of those. Just

RewriteEngine on
RewriteCond %{HTTP_HOST} ^crm.nxx.ph$ [NC,OR]
RewriteCond %{HTTP_HOST} ^crm.nxx.ph.com$
RewriteCond %{REQUEST_URI} !/suitecrm/public/
RewriteRule (.*) /suitecrm/public/$1 [L]

Is this the reason I’m getting all the undefined errors when I create Quotation? All line items gives me Undefined.

dipeshpatel · 10 July 2022 02:04

Please check your file permission. There is some issues either create a new language file in Cache directory or read the file. Do below steps

Remove “Cache” directory
Change values in config.php file
‘dir_mode’ => octdec(‘0777’),
‘file_mode’ => octdec(‘0777’),
Repair and Rebuild

Let me know in case it does not work.

Thanks
Dipesh

jang430 · 10 July 2022 02:08

Delete cache directory under suitecrm altogether?
Where can I see config.php file?
Where do I select Repair and Rebuild? Inside Suitecrm?

pgr · 10 July 2022 16:11

There are two cache directories, in the root folder, another under public/legacy
config.php is also under public/legacy - any file system search could have told you this
Inside SuiteCRM UI, under Admin / Repairs, you will find Quick Repair and Rebuild.