Solved Installation error

[itechnify]

Hello guys, my name is Salvador, tryng to install 3CX on my linux server using debian 9 standar, everything went fine until i got this error?

Spoiler: Server error

System.Exception: Error in CreatingCloudServerManagementDatabase.sql: 22023: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) ---> Npgsql.PostgresException: 22023: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<g__ReadMessageLong|0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<g__ReadMessageLong|0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteDbDataReader(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, IDictionary2 parameters) at PostInstall.DBConnection.ExecuteScript(String sqlQuery, IDictionary2 parameters) at _3CXCloudDBManager.DbConnectionExtensions.ExecuteScript(IDBConnection connection, Object configurationStructure, String scriptText, Boolean asResourceName) --- 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.CreateDatabase(Action1 stateChanged) at PostInstall.SetupExecutor.ExecuteSetup(SetupSettings setupSettings, Action1 stateChanged, Action`1 errorNotifier) at PbxWebConfigTool.PbxSetupService.CreatePbxInternal(SetupSettings settings)
OK

thank you in advanced.
Greetings

 

[cobaltit]

Hey Salvador. You gave very little information but my guess is that perhaps already had Postgres on there as part of another service and 3CX doesn't like that. 3CX should be installed by itself, on a plain Debian install, preferably from the 3CX ISO.

 

[itechnify]

well i have installed on on LXC container with proxmox, i know its not listed as a supported hypervisor but i just wanted to give a try since i read in this forums of sucess installation of it with proxmox, so i thought to give it a try, then since it didnt complet the installation installed on a VM using the Debian iso from 3CX, it completed the installation with no error, but it wont open the management console at
https://myip:5001 so still tryng to figuring out whats happening... any help will be appreciated. thanks

 

[itechnify]

i cant just get on the console on my LAN, cant get access from outside to the admin console, ports forwarding are done with pfsense.

 

[JohnS_3CX]

Hi Salvador,

The installation on Debian is only 50% of the procedure. After successful installation you need to run the configuration wizard on port 5015



If this was not completed then there is no management console to connect to yet (or your network environment does not allow you to reach the machine perhaps?).

I would recommend to read this article here and also ensure you are running inside a supported hypervisor https://www.3cx.com/docs/manual/installing-debian-linux-pbx/

 

[itechnify]

just one more question, if i am in the local LAN i can't access the public console through the link that is for outside the lan use? another thing is somehow i forgot the password is there any way i can recover the password? i am using the iso from 3cx debian in a virtual machine using proxmox (i tried container but i get the error shown above)

 

[JohnS_3CX]

Hi Salvador,

It's a networking matter. Allow me to explain a bit better: to access the console of a local PBX, from a local PC, but using the FQDN link for outside use, you will need the following prerequisites as a bare minimum

• HTTPS port of the PBX must be open on the firewall https://www.3cx.com/docs/ports/
• The firewall must allow hairpin traffic (external requests that route back to internal LAN)
• Or - you need to modify your hosts file on the PC to redirect the FQDN to the internal IP
• Or - you need to modify your local DNS server to redirect the FQDN to the internal IP

Your FQDN is usually the form of myname.3cx.com or something similar.

Which password did you forget? If the management console then check your email: you got an email after the setup telling you your system details.

If you forgot the OS password, you will get some extra practice reinstalling the 3CX ISO

 

[itechnify]

alright, since 3CX doesnt send you the password into the email, i got tired trying and waiting for the ip blacklisted to be clear, so i went and got over OVH and got me a basic VPS where i install it with no problems, so my questions are:
1-Is there any problem if i reuse the same licence key? asking cuz it uses the same FQNS so it tends to think i am using (login credentials) it with the old installation NO The vps, so it doesnt let me login, even though i got the previous installation off (proxmox kvm). How to get rid of the previous old installation from where i forgot the password?

 

[StefanW]

if you still face the same issue, fix your locale settings of debian.
ew encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) .

A sample pre 3CX install to be run could be
apt-get update && DEBIAN_FRONTEND=noninteractive apt-get install -y locales
sed -i -e 's/# en_US.UTF-8 UTF-8/en_US.UTF-8 UTF-8/' /etc/locale.gen && \
echo 'LANG="en_US.UTF-8"'>/etc/default/locale && \
dpkg-reconfigure --frontend=noninteractive locales && \

 

[JohnS_3CX]

alright, since 3CX doesnt send you the password into the email, i got tired trying and waiting for the ip blacklisted to be clear, so i went and got over OVH and got me a basic VPS where i install it with no problems, so my questions are:
1-Is there any problem if i reuse the same licence key? asking cuz it uses the same FQNS so it tends to think i am using (login credentials) it with the old installation NO The vps, so it doesnt let me login, even though i got the previous installation off (proxmox kvm). How to get rid of the previous old installation from where i forgot the password?

If you deleted your old instance and started from scratch you should be fine, no passwords are remembered. The OVH instance will update the DNS and your FQDN will start to point to it now.

 

[itechnify]

Interesting.
I removed the old proxmox installation so i can use the one i have on OVH vps, however i cant access the admin console using the FQDN, only with the ip of the OVH Server. not sure why, it should update as you said.
cheers

 

[cobaltit]

DNS TTL on Free licenses is 6 hours so it can take some time. It may also have 'lost' the battle after fighting with the other instance so restarting it might help kick the DNS update.

 

[itechnify]

restart and solved, now the issue is i cant call out, i just can call extension to extension and received calls, but cant call out? thanks for the replies.

 

[JohnS_3CX]

Hi Salvador,

You will need some outgoing rules before you can make outgoing calls

https://www.3cx.com/docs/manual/sip-trunks/#h.3evqdta9sabf

Edit: I will close this thread as the initial issue is now resolved, feel free to open a new thread in case you still have problems after reading the above link.