ASTPP 5 installation Error

Hi Guys,
I am trying to install ASTPP version 5, and the installation is givining me the following error
Installing dependencies for ASTPP
Creating neccessary locations and configuration files …
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER ‘astppuser’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘RwVQ*LJId’ at line 1
ERROR 1273 (HY000) at line 174: Unknown collation: ‘utf8mb4_0900_ai_ci’
ERROR 1146 (42S02) at line 40: Table ‘astpp.menu_modules’ doesn’t exist
Failed to start freeswitch.service: Unit freeswitch.service not found.
Failed to enable unit: File freeswitch.service: No such file or directory
sed: can’t read /etc/freeswitch/autoload_configs/switch.conf.xml: No such file or directory
sed: can’t read /etc/freeswitch/autoload_configs/switch.conf.xml: No such file or directory
sed: can’t read /etc/freeswitch/autoload_configs/switch.conf.xml: No such file or directory
sed: can’t read /etc/freeswitch/autoload_configs/switch.conf.xml: No such file or directory
touch: cannot touch ‘/etc/freeswitch/dialplan/astpp.xml’: No such file or directory
touch: cannot touch ‘/etc/freeswitch/directory/astpp.xml’: No such file or directory
touch: cannot touch ‘/etc/freeswitch/sip_profiles/astpp.xml’: No such file or directory
Failed to restart freeswitch.service: Unit freeswitch.service not found.
Failed to enable unit: File freeswitch.service: No such file or directory
Generating a RSA private key

tting up monit (1:5.20.0-6+deb9u2) …
Processing triggers for systemd (232-25+deb9u13) …
Processing triggers for man-db (2.7.6.1-2) …
monit.service is not a native service, redirecting to systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable monit
sed: can’t read /etc/logrotate.d/php7.3-fpm: No such file or directory
sed: can’t read /etc/logrotate.d/php7.3-fpm: No such file or directory
FS restarting…!
Failed to restart freeswitch.service: Unit freeswitch.service not found.
FS restarted…

never seen this error before . I also tried to install the ASTPP version 4 and after install I was getting nginx error and could not login on the webpage . any idua what the issue is ?

There is an issue they still have not resolved in the install script because they are using 3rd party repos to install mysql instead of just using MariaDB from the distro,

ANd oddly, they are using third party repo for PHP 7.4 when it is available in Debian 11 one.

1 Like

Apparently, on March, 17th, Freeswitch changed their repository and now it requires a token to download the binary files so this is another part of the script that fails and needs to be adjusted.

The same issues.
There are more issues when installing ASTPP v4 or v5 on Centos 7
it seems ASTPP community will be retired

Get TOKEN First

https://freeswitch.org/confluence/display/FREESWITCH/HOWTO+Create+a+SignalWire+Personal+Access+Token

Next

Edit CODE install: EX:
wget --http-user=signalwire --http-password=$TOKEN -O /usr/share/keyrings/signalwire-freeswitch-repo .gpg https: //freeswitch .signalwire.com /repo/deb/debian-release/signalwire-freeswitch-repo .gpg

Or they could just download the source and compile it on the local machine.

1 Like

Is there any document that you can point to on how to download the source and do it ?

Did you put a token in there?

Thansk for the email. The command worked successfully. example i used this.
wget --http-user=myeamili@gmail.com --http-password=pat_xxxxxxxxxxxz -O /usr/share/keyrings/signalwire-freeswitch-repo.gpg https://freeswitch.signalwire.com/repo/deb/debian-release/signalwire-freeswitch-repo.gpg

I can see the file created signalwire-freeswitch-repo.gpg . but when i go back to run the install.sh it fails freeswitch install.

This is how i am installing ASTPP
wget --no-check-certificate https://raw.githubusercontent.com/iNextrix/ASTPP/v4.0.1/install.sh -O install.sh

chmod +x install.sh

./install.sh

Looks like its failing for sql install and freeswitch both on authentication. Have the sql guys implementd similar authentication ??

_________Install log

After this operation, 85.2 MB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
mysql-server mysql-common mysql-community-client-plugins mysql-community-client-core mysql-community-client mysql-client
mysql-community-server-core mysql-community-server
E: There were unauthenticated packages and -y was used without --allow-unauthenticated
odbc/
odbc/libmyodbc8S.so
odbc/libmyodbc8w.so
odbc/libmyodbc8a.so

sed: can’t read /etc/mysql/mysql.conf.d/mysqld.cnf: No such file or directory
sed: can’t read /etc/mysql/mysql.conf.d/mysqld.cnf: No such file or directory
sed: can’t read /etc/mysql/mysql.conf.d/mysqld.cnf: No such file or directory
Synchronizing state of mysql.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable mysql
Failed to enable unit: Refusing to operate on linked unit file mysql.service
Installing FREESWITCH
Reading package lists… Done
Building dependency tree
Reading state information… Done
gnupg2 is already the newest version (2.1.18-8~deb9u4).
0 upgraded, 0 newly installed, 0 to remove and 14 not upgraded.
–2022-04-08 15:23:43-- https://files.freeswitch.org/repo/deb/freeswitch-1.8/fsstretch-archive-keyring.asc
Resolving files.freeswitch.org (files.freeswitch.org)… 2803:d000:fffe::174, 190.102.98.174
Connecting to files.freeswitch.org (files.freeswitch.org)|2803:d000:fffe::174|:443… connected.
HTTP request sent, awaiting response… 401 Unauthorized

Username/Password Authentication Failed.

Tahnks Ibrahim,
I have another question is there a way to upload a file to change the language of the platform

This is called thread hijacking. Make a new thread

Hello @voicecloud ,

We have updated the script for version- 5 ,
You can now download the script from here https://www.astppbilling.org/download

Please let us know here if any you have any other concern.

Thank you

I have successfully managed to install astpp 5 on debian version 10 on AWS. thanks for your help.