database (Forum tag)http://www.turnkeylinux.org/forum/term/400/0/feed
enOpenLDAP sync db from master to slavehttp://www.turnkeylinux.org/forum/support/20150211/openldap-sync-db-master-slave
<p>Hi,<br />
&nbsp;</p>
<p>I have setup my OpenLDAP appliance which is working fine.</p>
<p>How can i setup an LDAP sync of the ldap db between 2 ldap servers? The master would sync everything to the slave.</p>
<p><br />
Kr,</p>
<p>Joeri</p>http://www.turnkeylinux.org/forum/support/20150211/openldap-sync-db-master-slave#commentsSupportdatabaseopenldapsyncWed, 11 Feb 2015 20:57:10 +0000Joeri Feyen17075 at http://www.turnkeylinux.orgError establishing a database connectionhttp://www.turnkeylinux.org/forum/support/20140812/error-establishing-database-connection
<p>My TurnKeyLinux installation [<span>Debian 7.2 (wheezy)] WordPress installation keeps losing connection to the database.</span></p>
<p>If I reboot the server it will come back online for a few hours but then eventually loses the connection to the database again.&nbsp;</p>
<p><span>Error displayed on the url is &quot;Error establishing a database connection&quot;</span></p>
<p>I&#39;ve already verified that all available updates for WordPress and plugins are installed</p>
<p>Running WordPress 3.9.2</p>
<p>&nbsp;</p>http://www.turnkeylinux.org/forum/support/20140812/error-establishing-database-connection#commentsSupportconnectiondatabaseerrorTue, 12 Aug 2014 14:43:39 +0000Joe Marcellais15979 at http://www.turnkeylinux.orgOracle XE 11ghttp://www.turnkeylinux.org/forum/general/20130813/oracle-xe-11g
<p>Hello,<br />
<br />
I have made my very first effort to install Oracle XE 11g on TKL.<br />
<br />
Because Oracle XE doesn&#39;t fullfill following <a href="https://github.com/turnkeylinux-apps/tkldev/blob/master/docs/development/new.rst" rel="nofollow">requirements</a> you have set for a TurnKey appliance:</p>
<ul>
<li>
Open source <em>(Oracle XE is not)</em></li>
<li>
No proprietry software, binaries, database dumps, etc <em>(Oracle XE is only available as a ready made binary (RPM) package)</em></li>
<li>
Compliance with the Debian Policy and Filesystem Hierarchy Standard (FHS) <em>(Oracle XE is targetted to run on Oracle Linux)</em></li>
</ul>
<p>I don&#39;t expect it never to be a part of the official appliance family even <a href="http://www.oracle.com/technetwork/products/express-edition/overview/index.html" rel="nofollow">Oracle claims</a> that Oracle XE is:</p>
<blockquote>
<p><br />
It&#39;s [Oracle XE] free to develop, deploy, and distribute; fast to download; and simple to<br />
administer.</p>
</blockquote>
<p>But I have not read <a href="http://www.oracle.com/technetwork/licenses/database-11g-express-license-459621.html" rel="nofollow">the license</a> (and even if I had read it I might have not understood the legal jargon).<br />
<br />
However I have found a slim Oracle XE installation very useful as I&#39;m currently working with Oracle technologies.<br />
<br />
Also Oracle provides <a href="http://www.oracle.com/technetwork/community/developer-vm/index.html" rel="nofollow">virtual machine images</a> including Oracle XE database, but those packages are often bloated.<br />
<br />
Because of the unclear licensing and a few unresolved technical issues (I&#39;m not an unix nor Oracle admin) I have made a decision that the virtual appliance doesn&#39;t include Oracle XE out-of-the box but rather provides a ready made platform where installation of Oracle XE is very easy from the end user point of view.<br />
<br />
I&#39;ll address the technical issues in other posts.<br />
<br />
Appliance TKLDev sources with instructions how to install Oracle XE are available in GitHub:<br />
<br />
<a href="https://github.com/janihur/turnkey-oracle-xe-11g/tree/initial-dev" title="https://github.com/janihur/turnkey-oracle-xe-11g/tree/initial-dev" rel="nofollow">https://github.com/janihur/turnkey-oracle-xe-11g/tree/initial-dev</a><br />
<br />
Ready made ISO image is available for download:<br />
<br />
<a href="http://vm.jani-hur.net/turnkey-oracle-xe-11g.iso" title="http://vm.jani-hur.net/turnkey-oracle-xe-11g.iso" rel="nofollow">http://vm.jani-hur.net/turnkey-oracle-xe-11g.iso</a><br />
&nbsp;</p>http://www.turnkeylinux.org/forum/general/20130813/oracle-xe-11g#commentsGeneraldatabaseoracleTue, 13 Aug 2013 05:36:35 +0000Jani Hur5162 at http://www.turnkeylinux.orgDatabase connection Errorhttp://www.turnkeylinux.org/forum/support/20130613/database-connection-error
<p>While trying to clone the server&nbsp; we are getting the <strong>&quot;&quot;Database connection Error&quot;&quot;</strong> where the live website is working fine.<br />
<br />
root@wordpress www/wordpress# mysql -u wordpress -p<br />
Enter password:<br />
ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/var/run/mysqld/mysqld.sock&#39; (2)<br />
<br />
Which we managed to fix by creating the socket files.<br />
<br />
<br />
But facing the below issue now:<br />
<br />
root@wordpress ~# mysql -u root -p<br />
Enter password:<br />
ERROR 1045 (28000): Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: YES)<br />
<br />
As it&#39;s cloned server we are using the same root password which is used by the live server .<br />
<br />
<br />
Please help</p>http://www.turnkeylinux.org/forum/support/20130613/database-connection-error#commentsSupportaccess denied for userclone issuedatabasemysqlThu, 13 Jun 2013 20:34:54 +0000DevWeb5025 at http://www.turnkeylinux.orgAutoreply SMS from databasehttp://www.turnkeylinux.org/forum/general/20130115/autoreply-sms-database
<p>&nbsp;</p>
<p>I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers (based on keywords) from a database and send it back in SMS to the customer&rsquo;s mobile phone. For example I will use Microsoft SQL Express as the database server. I found a software, OzekiSMS Gateway that can handle SMS receiving and sending. The database connection is the question. How should I organize the data in the database? Is this the best way as they recommend? (<a href="http://www.ozekisms.com/index.php?owpn=392" rel="nofollow">http://www.ozekisms.com/index.php?owpn=392&amp;info=users-and-applications/autoreplydatabase-user</a>)</p>
<p>&nbsp;</p>
<p>For example:</p>
<p><strong>&gt; select * from autoreplymessage;</strong></p>
<p><strong>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyword&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; msg</strong></p>
<p><strong>----------&nbsp; ------------------------------ -------------------------------------</strong></p>
<p><strong>&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; default&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; There is no data for this keyword.</strong></p>
<p><strong>&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red is a good color.</strong></p>
<p><strong>&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Blue is not the best option.</strong></p>
<p>&nbsp;</p>
<p>Please share with me your suggestions.</p>
<p>Bye,</p>
<p>&nbsp;</p>
<p>Leslie</p>http://www.turnkeylinux.org/forum/general/20130115/autoreply-sms-database#commentsGeneralautoreplydatabasegatewaysmsTue, 15 Jan 2013 14:42:39 +0000LeslieJohn4465 at http://www.turnkeylinux.orgSuggestion: Ingres 10.1 Community Editionhttp://www.turnkeylinux.org/forum/general/20120418/suggestion-ingres-101-community-edition
<p>Hi,</p>
<p>&nbsp; I suggest that a virtual appliance for the Ingres 10.1 DBMS Community Edition,&nbsp;<a href="http://www.actian.com/downloads/ingres#community" rel="nofollow">http://www.actian.com/downloads/ingres#community</a>, would be an excellent addition to the portfolio of database virtual appliances.</p>
<p>&nbsp; The Ingres DBMS is a commercially used database management system that supports applications via the JDBC protocol.</p>
<p>Regards,</p>
<p>&nbsp; Jason</p>http://www.turnkeylinux.org/forum/general/20120418/suggestion-ingres-101-community-edition#commentsGeneraldatabaseingresrequestsuggestionWed, 18 Apr 2012 04:32:21 +0000Jason TEPOORTEN3398 at http://www.turnkeylinux.orgTKLBAM - what about test and live data?http://www.turnkeylinux.org/forum/support/20110224/tklbam-what-about-test-and-live-data
<p>
Hello,</p>
<p>
I am in a team working on a Wordpress-based web app, and we have a development process that goes local-&gt;test server-&gt;live server. It seems to me that TKLBAM could allow us to move through these steps by backing up one step and restoring at the next. I am assuming databases changes are migrated.</p>
<p>
However, I am confused about how to handle the data - the live server has data on it being changed by other people, which we don&#39;t want to lose by accidentally overwriting with a backup from the test server.</p>
<p>
I feel I need something a bit like &quot;git stash&quot; on the production server.</p>
<p>
Any ideas?</p>
<p>
Thanks,</p>
<p>
&nbsp;</p>
<p>
Jonathan Lister</p>http://www.turnkeylinux.org/forum/support/20110224/tklbam-what-about-test-and-live-data#commentsSupportdatabasetklbamwordpressThu, 24 Feb 2011 11:20:03 +0000Jonathan Lister2086 at http://www.turnkeylinux.org