Documentation

Documentation.Install-DBDeployment-1-11 History

Hide minor edits - Show changes to output

March 20, 2014, at 08:05 PM by razvancrainea -
Changed lines 1-2 from:
!!!!!Documentation -> [[Documentation.Manuals|Manuals]] -> [[Documentation.Manual-1-11|Manual devel]] -> Database Deployment
(:title Database Deployment - devel :)
to:
!!!!!Documentation -> [[Documentation.Manuals|Manuals]] -> [[Documentation.Manual-1-11|Manual 1.11]] -> Database Deployment
(:title Database Deployment - ver 1.11 :)
Changed line 8 from:
|| %color=#185662%[+'''Database Deployment devel'''+]%% ||
to:
|| %color=#185662%[+'''Database Deployment v1.11'''+]%% ||
August 05, 2013, at 03:22 PM by razvancrainea -
Changed lines 1-2 from:
!!!!!Documentation -> [[Documentation.Manuals|Manuals]] -> [[Documentation.Manual-1-11|Manual 1.11]] -> Database Deployment
(:title Database Deployment - ver 1.11 :)
to:
!!!!!Documentation -> [[Documentation.Manuals|Manuals]] -> [[Documentation.Manual-1-11|Manual devel]] -> Database Deployment
(:title Database Deployment - devel :)
Changed line 8 from:
|| %color=#185662%[+'''Database Deployment v1.11'''+]%% ||
to:
|| %color=#185662%[+'''Database Deployment devel'''+]%% ||
August 05, 2013, at 02:08 PM by razvancrainea -
Changed line 4 from:
[- Page for other versions: [[Install-DBDeployment|devel]] 1.9 [[Install-DBDeployment-1-8|1.8]] old versions: [[Install-DBDeployment-1-7|1.7]] [[Install-DBDeployment-1-6|1.6]] [[Install-DBDeployment-1-5|1.5]] [[Install-DBDeployment-1-4|1.4]] -]
to:
(:allVersions Install-DBDeployment 1.11 :)
August 05, 2013, at 12:46 PM by razvancrainea -
Added lines 1-55:
!!!!!Documentation -> [[Documentation.Manuals|Manuals]] -> [[Documentation.Manual-1-11|Manual 1.11]] -> Database Deployment
(:title Database Deployment - ver 1.11 :)
----
[- Page for other versions: [[Install-DBDeployment|devel]] 1.9 [[Install-DBDeployment-1-8|1.8]] old versions: [[Install-DBDeployment-1-7|1.7]] [[Install-DBDeployment-1-6|1.6]] [[Install-DBDeployment-1-5|1.5]] [[Install-DBDeployment-1-4|1.4]] -]

\\

|| %color=#185662%[+'''Database Deployment v1.11'''+]%% ||

||[[Install-CompileAndInstall-1-11|Prev]] || [[Install-DBSchema-1-11|Next]]||
----

After installing your OpenSIPS, most likely you will need to also deploy a database that you could use for various reasons ( DB user authentication, persistent registrations, dialogs, etc ).

----

(:toc-float Table of Content:)

!!! Configuring DB Credentials

Go to the [Install_Path]/etc/opensips/ folder and open the opensipsctlrc file

There take care of the following lines :

* DBENGINE=
** the currently available options MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT
* DBHOST=
** enter the host for your DB engine
* DBNAME=
** the name of the database which will be created
* DBRWUSER=
** the username that will be created in the database for OpenSIPS read/write access
* DBRWPW=
** the password that will be set for the DBRWUSER username
* DBROOTUSER=
** the user that will be used for creating the database, tables and DBRWUSER

!!! Creating the Database

In order to create the DBNAME database that you have provisioned above, run
[@
[Install_Path]/sbin/opensipsdbctl create
@]

When prompted by the opensipsdbctl tool, please enter your DBROOTUSER password.

If you want to create a different database other than the default DBNAME, you can call
[@
[Install_Path]/sbin/opensipsdbctl create my_custom_db_name
@]

The opensipsdbctl tool can also be used for things like taking backups, doing restores, and more. If you want to see the capabilities and help manual for the opensipsdbctl tool, you can run it with no parameters :
[@
[Install_Path]/sbin/opensipsdbctl
@]

Page last modified on March 20, 2014, at 08:05 PM