Unsupported 3CX on a Proxmox LXC - Debian 10 Error

[Brodie Pike]

Hey all I know the Proxmox and LXCs are not officially supported but I've looked around and seen some people claiming to have got 3CX running in a LXC. Now I've set everything and seem to get as far as just complete the install before I get a error that apparently has todo with UTF-8 Encoding with the database. I've reconfigured the LXCs Locale to en_US.UTF-8 and still get the same error. I'm not sure how to progress with this anyone got any tips or just a straight out answer haha. All help would be awesome!

System.Exception: Error in CreatingCloudServerManagementDatabase.sql: 22023: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) ---> Npgsql.PostgresException (0x80004005): 22023: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.<>c__DisplayClass41_0.<g__ReadMessageSequential|0>d.MoveNext() --- End of stack trace from previous location --- at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteScalar(Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteScalar() at PostInstall.DBConnection.ExecuteScriptInternal(NpgsqlConnection connection, String sqlQuery, IDictionary`2 parameters) at PostInstall.DBConnection.ExecuteScript(String sqlQuery, IDictionary`2 parameters) at _3CXCloudDBManager.DbConnectionExtensions.ExecuteScript(IDBConnection connection, Object configurationStructure, String scriptText, Boolean asResourceName) Exception data: Severity: ERROR SqlState: 22023 MessageText: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) Hint: Use the same encoding as in the template database, or use template0 as template. File: dbcommands.c Line: 396 Routine: createdb --- End of inner exception stack trace --- at _3CXCloudDBManager.DbConnectionExtensions.ExecuteScript(IDBConnection connection, Object configurationStructure, String scriptText, Boolean asResourceName) at _3CXCloudDBManager.CloudDBManager.CreateCloudServerManagementDatabase(IDBConnection superuser, CloudServerManagementDatabaseConfiguration configuration) at PostInstall.SetupExecutor.CreateCloudServerManagementDatabase(CloudDBManager cloudDbManager, DBConnection templateConnection) at PostInstall.SetupExecutor.CreateDatabase(Action`1 stateChanged) at PostInstall.SetupExecutor.ExecuteSetup(SetupSettings setupSettings, Action`1 stateChanged, Action`1 errorNotifier) at PbxWebConfigTool.PbxSetupService.CreatePbxInternal(SetupSettings settings)

 

[RCT-CP]

PostgreSQL is used under the hood and likely doesn't understand that the locale should be UTF-8 because it's an LXC. If it were me and I wanted to burn some time on it, I'd suggest setting up pgsql and making sure that's aligned correctly then re-attempting to get 3CX installed. Postgres might be thinking it should be using a different encoding method, but this is somewhat beyond the scope of my knowledge. Or... give in and use a KVM with the ISO. When I hit weird stuff like this I sacrifice some system resources by doing a full VM. Not sure how 'full' your PVE host is, but it will save you a lot of headaches.

I've also run into issues with non-3CX LXC's because it's essentially a Linux jail and whatever is running will conflict with other VMs on the host or the base OS.

 

[mixig]

3cx v16.5, lcx, proxmox v 5.x, working without any issues.
I dont have any connection with proxmox, only with 3cx

 

[Brodie Pike]

3cx v16.5, lcx, proxmox v 5.x, working without any issues.
I dont have any connection with proxmox, only with 3cx

How did you get it working? Are there any settings you specifically used when setting up the LXC? What Debian build is it running? I'm on Proxmox 7