<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
well, the reason I asked for prefix, is because te databases have
tables with similar names like 'data'. If this is they are all the
same, so no need for prefix, but if they contain<br>
different data, then it would be problematic to use only one
database.<br>
I give it a try and see what happens :)<br>
<br>
Cheers,<br>
A.<br>
<br>
<div class="moz-cite-prefix">On 31.05.2016 09:51, Patrick
Hochstenbach wrote:<br>
</div>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none">#mid_1464681106017_35073_UGent_be p { margin-top: 0px; margin-bottom: 0px; }
</style>
<p>Yes you can put the three databases in one, you need to change
the DBI strings in catmandu.store.yml. But it is not possible yet
to add a prefix to the tables. You could make a ticket for that
at:<br>
</p>
<p><br>
</p>
<p><a moz-do-not-send="true"
href="https://github.com/LibreCat/Catmandu-DBI">https://github.com/LibreCat/Catmandu-DBI</a><br>
</p>
<p><br>
</p>
<p>Patrick<br>
</p>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
face="Calibri, sans-serif" color="#000000"><b>From:</b> Arash
Samadi <a class="moz-txt-link-rfc2396E" href="mailto:samadi@sub.uni-goettingen.de"><samadi@sub.uni-goettingen.de></a><br>
<b>Sent:</b> Monday, May 30, 2016 2:43 PM<br>
<b>To:</b> Patrick Hochstenbach<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:librecat-dev@lists.uni-bielefeld.de">librecat-dev@lists.uni-bielefeld.de</a><br>
<b>Subject:</b> Re: [librecat-dev] Database connection</font>
<div> </div>
</div>
<div>Ok,<br>
<br>
another question. Is it possible to pack all three databases in
one and just add a prefix for tables using 'DBI::' string? Or
should I make more changes in<br>
'catmandu.store.yml'? Obviously I need to change the sql-scripts
in 'devel' subfolder as well...<br>
<br>
Thx,<br>
A.<br>
<br>
<div class="moz-cite-prefix">On 30.05.2016 11:50, Arash Samadi
wrote:<br>
</div>
Thx Patrick,<br>
<br>
Cheers,<br>
A.<br>
<br>
<div class="moz-cite-prefix">On 30.05.2016 11:41, Patrick
Hochstenbach wrote:<br>
</div>
<pre>You add host/port informatin to the DBI string in data_source. E.g. in catmandu.store.yml:
data_source: "DBI:mysql:database=librecat_system”
Replace that with something like:
DBI:mysql:database=librecat_system;host=some.server.org;port=3307
You can even change the type of database (e.g. PostGRES) if you prefer.
</pre>
<blockquote class=" cite" id="Cite_762942" type="cite">
<pre>On 30 May 2016, at 11:26, Arash Samadi <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:samadi@sub.uni-goettingen.de"><samadi@sub.uni-goettingen.de></a> wrote:
Hi everyone,
so I've successfully installed LibreCat on two different versions of CentOS, 6.7 & 7.1511. Now I try to build a docker image. Before I go any deeper, I wanted to know, how one
can assign an external Database as Storage to LibreCat. I couldn't find any settings, only 'dbproxy' which is using 'unixsocket' and the perl module, which per default uses the
local host 127.0.0.1.
I would appreciate any insights,
Cheers,
A.
--
Arash Samadi
Digitale Biblothek, Bibliotheksysteme (BIS)
Georg-August-Universität Göttingen
Niedersächsische Staats- und Universitätsbibliothek
D-37073 Göttingen
Platz der Göttinger Sieben 1 (Zentralbibliothek, LRC, Raum 2.19)
Tel: +49 39-20726
m@il: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:samadi@sub.uni-goettingen.de">samadi@sub.uni-goettingen.de</a>
www: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.sub.uni-goettingen.de">http://www.sub.uni-goettingen.de</a>
_______________________________________________
librecat-dev mailing list
- send list mails to <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:librecat-dev@lists.uni-bielefeld.de">librecat-dev@lists.uni-bielefeld.de</a>
- to unsubscribe or change options, visit <a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.uni-bielefeld.de/mailman2/cgi/unibi/listinfo/librecat-dev">https://lists.uni-bielefeld.de/mailman2/cgi/unibi/listinfo/librecat-dev</a>
- project website: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://librecat.org/">http://librecat.org/</a>
</pre>
</blockquote>
<pre>Patrick Hochstenbach - digital architect
University Library Ghent
Sint-Hubertusstraat 8 - 9000 Ghent - Belgium
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:patrick.hochstenbach@ugent.be">patrick.hochstenbach@ugent.be</a>
+32 (0)9 264 7980
</pre>
<br>
<div class="moz-signature">-- <br>
<div id="Signiture" style="font-size:11pt">
<p><strong>Arash Samadi</strong><br>
Digitale Biblothek, Bibliotheksysteme (BIS)</p>
<p>Georg-August-Universität Göttingen<br>
Niedersächsische Staats- und Universitätsbibliothek<br>
D-37073 Göttingen</p>
<p>Platz der Göttinger Sieben 1 (Zentralbibliothek, LRC,
Raum 2.19)</p>
<p>Tel: +49 39-20726<br>
m@il: <a moz-do-not-send="true"
href="mailto:samadi@sub.uni-goettingen.de">samadi@sub.uni-goettingen.de</a><br>
www: <a moz-do-not-send="true"
href="http://www.sub.uni-goettingen.de">http://www.sub.uni-goettingen.de</a></p>
</div>
</div>
<br>
<div class="moz-signature">-- <br>
<div id="Signiture" style="font-size:11pt">
<p><strong>Arash Samadi</strong><br>
Digitale Biblothek, Bibliotheksysteme (BIS)</p>
<p>Georg-August-Universität Göttingen<br>
Niedersächsische Staats- und Universitätsbibliothek<br>
D-37073 Göttingen</p>
<p>Platz der Göttinger Sieben 1 (Zentralbibliothek, LRC,
Raum 2.19)</p>
<p>Tel: +49 39-20726<br>
m@il: <a moz-do-not-send="true"
href="mailto:samadi@sub.uni-goettingen.de">samadi@sub.uni-goettingen.de</a><br>
www: <a moz-do-not-send="true"
href="http://www.sub.uni-goettingen.de">http://www.sub.uni-goettingen.de</a></p>
</div>
</div>
</div>
</div>
<br>
<div class="moz-signature">-- <br>
<div id="Signiture" style="font-size: 11pt;">
<p><strong>Arash Samadi</strong><br>
Digitale Biblothek, Bibliotheksysteme (BIS)</p>
<p>Georg-August-Universität Göttingen<br>
Niedersächsische Staats- und Universitätsbibliothek<br>
D-37073 Göttingen</p>
<p>Platz der Göttinger Sieben 1 (Zentralbibliothek, LRC, Raum
2.19)</p>
<p>Tel: +49 39-20726<br>
m@il: <a href="mailto:samadi@sub.uni-goettingen.de">samadi@sub.uni-goettingen.de</a><br>
www: <a href="http://www.sub.uni-goettingen.de">http://www.sub.uni-goettingen.de</a></p>
</div>
</div>
</body>
</html>