<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css" style="display:none"></style> </head> <body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;"> <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 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 face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Arash Samadi <samadi@sub.uni-goettingen.de><br> <b>Sent:</b> Monday, May 30, 2016 2:43 PM<br> <b>To:</b> Patrick Hochstenbach<br> <b>Cc:</b> librecat-dev@lists.uni-bielefeld.de<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 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 class="moz-txt-link-abbreviated" href="mailto:samadi@sub.uni-goettingen.de">samadi@sub.uni-goettingen.de</a> www: <a 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 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 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 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 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 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> <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> </div> </div> </body> </html>