I’m looking for a replacement for sugarce 6.5 so i’m trying to test this crm.
I made a ubuntu 22.04 VM with php 8.2, mysql 8, apache 2.4.52 and elasticsearch 8. I cloned the latest release of spice in webserver root and configured it according to the docs (i think). www-data is owner of the spicecrm web root dir and has 0755 permissions on cache, custom, media and upload folder. I also activated https and this works as intended. When i complete the installation via webbrowser everything is as expected and i get no errors.
After installation it refreshes the page and shows the login screen. When i fill i my credentials it loads but get stuck on ‘loading language’. Tried several browsers.
Does anyone have an idea what’s the cause and how i can solve it?
2024-07-09 12:11:44 [734][1][FATAL][SQL] {"error":"Table 'spicecrm2.ldap_settings' doesn't exist","query":"SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority"}
2024-07-09 14:13:43 [733][-none-][FATAL][SQL] {"error":"Table 'spicecrm2.ipaddresses' doesn't exist","query":"SELECT count(*) FROM ipaddresses WHERE date_deleted IS NULL AND color='b' AND address = '10.11.100.154' LIMIT 0,1"}
2024-07-09 14:13:43 [733][-none-][FATAL][SQLERROR] Get One Failed:SELECT count(*) FROM ipaddresses WHERE date_deleted IS NULL AND color='b' AND address = '10.11.100.154': MySQL error 1146: Table 'spicecrm2.ipaddresses' doesn't exist
Those errors keep recurring. User that connects to db has all grants on .
This is from the apache2 log:
[Tue Jul 09 12:07:37.216670 2024] [proxy_fcgi:error] [pid 1654] [client 10.11.100.154:49803] AH01071: Got error 'PHP message: Slim Application Error\nType: TypeError\nCode: 0\nMessage: array_values(): Argu>
[Tue Jul 09 12:07:42.110735 2024] [mpm_prefork:notice] [pid 1653] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Jul 09 12:10:33.936850 2024] [ssl:warn] [pid 1475] AH01909: spicecrm.centio.internal:443:0 server certificate does NOT include an ID which matches the server name
[Tue Jul 09 12:10:33.938590 2024] [ssl:error] [pid 1475] AH02604: Unable to configure certificate spicecrm.centio.internal:443:0 for stapling
Please, check server access writes for api/include/SpiceDictionary/system/systemcached.dump
Set the user www-data as the owner.
remove folders api/cache, api/custom, api/media/, api/upload and api/config.php
delete the database that was created
Launch the installer again
Could you login after your new installation on ubuntu?
That’s important to know.
If yes, then you need to follow the next steps described in the installation guide.
Thankyou for your responses, but i have moved to a different product. I understand you cannot respond to all forum posts promptly but i had to find a solution for my clients problem and unfortunately could not wait any longer. You probably have a wonderful product but the ability of getting support from the developers or an active community are very important to my client. I wish you the best in developing your product.
EDIT: I CAN LOGIN!
But Cant use any packages, i just have “users”: Failed to load packages opportunitymanagement
EDIT 2:
I wanted to share my experience with setting up SpiceCRM. During the installation, I noticed that many packages were installed or installed “wrong” even though the system indicated otherwise (like accounts because i cant create a record) . There were numerous error messages, which I hope are just due to ongoing development and will resolve themselves shortly. It’s frustrating that these errors don’t clear up on their own after a few seconds. (maybe its an easy fix to have a better impression)
Despite these initial hurdles, I’m impressed with the project’s potential. It offers many customization options and significant functional power. The short time looking the codebase it seems to be well-designed for developers.
I spent several hours working through these issues (setup), but I’m not deterred. I see a lot of promise in SpiceCRM and look forward to exploring it further.
Just wanted to share my experience and let others know that despite the initial challenges, the project seems promising!
power over spice is power over all
OLD POST:
same problem: Table ‘spicecrm.ldap_settings’ doesn’t exist
2024-08-13 17:22:58 [22][-none-][FATAL][SQL] {“error”:“Table ‘spicecrm.ldap_settings’ doesn’t exist”,“query”:“SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority”}
It seems that the configuration includes SQLEXPRESS for the “Database host instance,” which is meant for SQL Server Express. Since I’m using MySQL, this reference seems incorrect.
I have three containers set up for this application and would like to correct this configuration.