Installation Issues on Ubuntu 20.04

[voicecomms]

Hello,

I am trying to install on Ubuntu 20.04 and it is not letting me install with multiple issue,

Has anyone tried install on Ubuntu 20.04 ?

Regards
CJ

[voicecomms]

There is an issue when you do an upgrade from Ubuntu 16 to 20 and also Mysql Database
below is what I am seeing in ksmpp logs

2022-12-05 16:56:31 [64770] [11] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:31 [64770] [9] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:31 [64770] [15] ERROR: SMPP[(null)] Client no longer connected trying to send pdu bind_transceiver_resp!
2022-12-05 16:56:32 [64770] [10] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:32 [64770] [12] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:36 [64770] [11] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:37 [64770] [9] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:40 [64770] [10] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:40 [64770] [12] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:42 [64770] [7] INFO: Current SMPP load is 0.000000/sec inbound 0.000000/sec outbound
2022-12-05 16:56:44 [64770] [11] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:44 [64770] [9] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:45 [64770] [10] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:45 [64770] [12] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:46 [64770] [11] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:50 [64770] [9] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:50 [64770] [10] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1
2022-12-05 16:56:50 [64770] [12] ERROR: MYSQL: Unable to prepare statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(?) LIMIT 1' at line 1

[m-faraz]

That is a big jump and that error can be one of atleast 4 queries. either open up debug or better yet, recompile the package for 20.04

[IMBOT-INC]

i think you using over 8.0 ver mysql
if you use over 8.0
to change
ksmppd/smpp/lIbsmpp/ smpp_database_mysql.c
902 LINE

" FROM %S WHERE system_id = ? AND password = UPPER(SHA1(UNHEX(SHA1(?)))) LIMIT 1",

and recompile

[voicecomms]

i think you using over 8.0 ver mysql if you use over 8.0 to change ksmppd/smpp/lIbsmpp/ smpp_database_mysql.c 902 LINE

" FROM %S WHERE system_id = ? AND password = UPPER(SHA1(UNHEX(SHA1(?)))) LIMIT 1",

and recompile

Hello @IMBOT-INC Thanks, I will try and update here with your recommended changes for mysql

[voicecomms]

Hello @IMBOT-INC this does not works tried looks like changes @ OS Level, because in Ubuntu 20.04 I am able to install using apt, but manual install does not works from svn or from source

[voicecomms]

Installed on Ubuntu 18.x testing if everything works fine

Regards
CJ