How to install Alembic and create pjsip tables in asterisk 13.13

Question

[[email protected] ~]# pip install alembic
-bash: pip: command not found
[[email protected] ~]# yum install pip
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Determining fastest mirrors
 * base: mirrors.unifiedlayer.com
 * extras: ftp.osuosl.org
 * updates: centos.pymesolutionsweb.com
No package pip available.
Error: Nothing to do
[[email protected] ~]#

Answer 1

Follow the below steps

>yum install python-pip
>pip install alembic
>yum install python-dateutil
>yum install MySQL-python

to create pjsip tables

  >cd YOUR ASTERISK PATH/contrib/ast-db-manage
  >nano config.ini.sample

Next, edit the config.ini.sample file and change the sqlalchemy.url
option, e.g. sqlalchemy.url = mysql://root:[email protected]/asterisk

  >cp config.ini.sample config.ini
  >alembic -c config.ini upgrade head

Answer 2

For Centos 8
use the below command:

yum install python-alembic