<html>
<head>
<base href="https://wiki.asterisk.org/wiki">
<link rel="stylesheet" href="/wiki/s/en/2171/18/9/_/styles/combined.css?spaceKey=AST&forWysiwyg=true" type="text/css">
</head>
<body style="background: white;" bgcolor="white" class="email-body">
<div id="pageContent">
<div id="notificationFormat">
<div class="wiki-content">
<div class="email">
<h2><a href="https://wiki.asterisk.org/wiki/display/AST/SQLite3+astdb+back-end">SQLite3 astdb back-end</a></h2>
<h4>Page <b>edited</b> by <a href="https://wiki.asterisk.org/wiki/display/~twilson">Terry Wilson</a>
</h4>
<br/>
<h4>Changes (1)</h4>
<div id="page-diffs">
<table class="diff" cellpadding="0" cellspacing="0">
<tr><td class="diff-snipped" >...<br></td></tr>
<tr><td class="diff-unchanged" >h5. Solution <br>Run 'which astdb2sqlite3' from a terminal. If no filenames are displayed, then astd2sqlite3 has not be installed. Check if the distro includes it in another asterisk related package, or download the Asterisk 10 source from [the Asterisk.org website|http://downloads.asterisk.org/pub/telephony/asterisk] and follow the normal build instructions. Instead of running 'make install', manually run 'utils/astdb2sqlite3 /var/lib/asterisk/astdb' from the Asterisk source directory, replacing '/var/lib/asterisk' with the 'astdbdir' directory listed in asterisk.conf. After the conversion, the distro-supplied Asterisk should successfully run. <br></td></tr>
<tr><td class="diff-added-lines" style="background-color: #dfd;"> <br>h4. Migrating back from Asterisk 1.8 to Asterisk 10 <br>If migrating back to Asterisk 1.8 from Asterisk 10, it is possible to convert the SQLite 3 internal database back to the Berkeley DB format that Asterisk 1.8 uses by using the astdb2bdb utility found in the utils/ directory of the Asterisk 10 source. To build, make sure that astdb2bdb is selected in the Utilities section when running 'make menuselect'. Running 'utils/astdb2bdb /var/lib/asterisk/astdb.sqlite3' (replacing '/var/lib/asterisk' with the 'astdbdir' directory listed in asterisk.conf) will produce a file named 'astdb' in the current directory. Back up any existing astdb file in the astdbdir directory and replace it with the newly created astdb file. <br></td></tr>
</table>
</div> <h4>Full Content</h4>
<div class="notificationGreySide">
<h6><a name="SQLite3astdbback-end-Onthispage"></a>On this page</h6>
<p>Asterisk 10 uses SQLite 3 for its internal database instead of the Berkeley DB database used by Asterisk 1.8. Every effort has been made to make this transition as automatic and painless for users as possible. This page will describe the upgrade process, any potential problems, and the appropriate solutions to those problems.</p>
<h4><a name="SQLite3astdbback-end-Theupgradeprocess"></a>The upgrade process</h4>
<p>Asterisk 10 will attempt to upgrade any existing old-style Berkeley DB internal database to the new SQLite 3 database format. This conversion process is accomplished at run-time with the astdb2sqlite3 utility which builds by default in Asterisk 10. The astdb2sqlite3 utility will also be forcibly built even if deselected using menuselect if the build process determines that there is an old-style Berkeley DB and no new SQLite3 DB exists.</p>
<p>When Asterisk 10 is run, as part of the initialization process it checks for the existence of the SQLite3 database. If it doesn't exist and an old-style Berkeley DB does exist, it will attempt to convert the Berkeley DB to the SQLite3 format. If no existing database exists, a new SQLite 3 database will be created. If the conversion fails, a warning will be displayed with instructions describing possible fixes and Asterisk will exit.</p>
<h4><a name="SQLite3astdbback-end-Symptoms"></a>Symptoms</h4>
<h4><a name="SQLite3astdbback-end-.%2Fconfiguredisplaysthewarning%3APleaseinstalltheSQLite3developmentpackage."></a>./configure displays the warning: *** Please install the SQLite3 development package.</h4>
<h5><a name="SQLite3astdbback-end-Cause"></a>Cause</h5>
<p>To build Asterisk 10, the SQLite 3 development libraries must be installed.</p>
<h5><a name="SQLite3astdbback-end-Solution"></a>Solution</h5>
<p>On Debian-based distros including Ubuntu, these libraries may be installed by running 'sudo apt-get install libsqlite3-dev'. For Red Hat-based distros including Fedora and Centos these libraries may be installed by running (as root) 'yum install sqlite3-devel'.</p>
<h4><a name="SQLite3astdbback-end-Asteriskexitsdisplayingthewarning%3ADatabaseconversionfailed%21"></a>Asterisk exits displaying the warning: *** Database conversion failed!</h4>
<h5><a name="SQLite3astdbback-end-Cause"></a>Cause</h5>
<p>Asterisk 10 could not find the astdb2sqlite3 utility to convert the old Berkeley DB to SQLite 3.</p>
<h5><a name="SQLite3astdbback-end-Solution"></a>Solution</h5>
<p>Make sure that astdb2sqlite3 is selected for build in the Utilities section when running 'make menuselect'. Be sure to re-run 'make' and 'make install' after selecting astdb2sqlite3 for build.</p>
<h5><a name="SQLite3astdbback-end-Cause"></a>Cause</h5>
<p>Asterisk is unable to write to the directory specified in asterisk.conf as the 'astdbdir'</p>
<h5><a name="SQLite3astdbback-end-Solution"></a>Solution</h5>
<p>SQLite 3 creates a journal file in the 'astdbdir' specified in asterisk.conf. It is important that this directory is writable by the user Asterisk runs as. This involves either modifying the permissions of the 'astdbdir' directory listed in asterisk.conf, or changing the 'astdbdir' option to a directory for which the user running Asterisk already has write permission. This is generally only a problem if Asterisk is run as a non-root user.</p>
<h5><a name="SQLite3astdbback-end-Cause"></a>Cause</h5>
<p>If Asterisk 10 was installed via a distro-specific package, it is possible that the distro forgot to package the astdb2sqlite3 utility.</p>
<h5><a name="SQLite3astdbback-end-Solution"></a>Solution</h5>
<p>Run 'which astdb2sqlite3' from a terminal. If no filenames are displayed, then astd2sqlite3 has not be installed. Check if the distro includes it in another asterisk related package, or download the Asterisk 10 source from <a href="http://downloads.asterisk.org/pub/telephony/asterisk" class="external-link" rel="nofollow">the Asterisk.org website</a> and follow the normal build instructions. Instead of running 'make install', manually run 'utils/astdb2sqlite3 /var/lib/asterisk/astdb' from the Asterisk source directory, replacing '/var/lib/asterisk' with the 'astdbdir' directory listed in asterisk.conf. After the conversion, the distro-supplied Asterisk should successfully run.</p>
<h4><a name="SQLite3astdbback-end-MigratingbackfromAsterisk1.8toAsterisk10"></a>Migrating back from Asterisk 1.8 to Asterisk 10</h4>
<p>If migrating back to Asterisk 1.8 from Asterisk 10, it is possible to convert the SQLite 3 internal database back to the Berkeley DB format that Asterisk 1.8 uses by using the astdb2bdb utility found in the utils/ directory of the Asterisk 10 source. To build, make sure that astdb2bdb is selected in the Utilities section when running 'make menuselect'. Running 'utils/astdb2bdb /var/lib/asterisk/astdb.sqlite3' (replacing '/var/lib/asterisk' with the 'astdbdir' directory listed in asterisk.conf) will produce a file named 'astdb' in the current directory. Back up any existing astdb file in the astdbdir directory and replace it with the newly created astdb file.</p>
</div>
<div id="commentsSection" class="wiki-content pageSection">
<div style="float: right;" class="grey">
<a href="https://wiki.asterisk.org/wiki/users/removespacenotification.action?spaceKey=AST">Stop watching space</a>
<span style="padding: 0px 5px;">|</span>
<a href="https://wiki.asterisk.org/wiki/users/editmyemailsettings.action">Change email notification preferences</a>
</div>
<a href="https://wiki.asterisk.org/wiki/display/AST/SQLite3+astdb+back-end">View Online</a>
|
<a href="https://wiki.asterisk.org/wiki/pages/diffpagesbyversion.action?pageId=19005573&revisedVersion=3&originalVersion=2">View Changes</a>
|
<a href="https://wiki.asterisk.org/wiki/display/AST/SQLite3+astdb+back-end?showComments=true&showCommentArea=true#addcomment">Add Comment</a>
</div>
</div>
</div>
</div>
</div>
</body>
</html>