[librecat-dev] Database connection

[Arash Samadi]

Hi,

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
different data, then it would be problematic to use only one database.
I give it a try and see what happens :)

Cheers,
A.

On 31.05.2016 09:51, Patrick Hochstenbach wrote:

​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:


https://github.com/LibreCat/Catmandu-DBI​


Patrick

------------------------------------------------------------------------
*From:* Arash Samadi <samadi at sub.uni-goettingen.de>
*Sent:* Monday, May 30, 2016 2:43 PM
*To:* Patrick Hochstenbach
*Cc:* librecat-dev at lists.uni-bielefeld.de
*Subject:* Re: [librecat-dev] Database connection
 
Ok,

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
'catmandu.store.yml'? Obviously I need to change the sql-scripts in
'devel' subfolder as well...

Thx,
A.

On 30.05.2016 11:50, Arash Samadi wrote:
Thx Patrick,

Cheers,
A.

On 30.05.2016 11:41, Patrick Hochstenbach wrote:

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.

> On 30 May 2016, at 11:26, Arash Samadi <samadi at sub.uni-goettingen.de> 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 at il: samadi at sub.uni-goettingen.de
> www: http://www.sub.uni-goettingen.de
>
> _______________________________________________
> librecat-dev mailing list
> - send list mails to librecat-dev at lists.uni-bielefeld.de
> - to unsubscribe or change options, visit https://lists.uni-bielefeld.de/mailman2/cgi/unibi/listinfo/librecat-dev
> - project website: http://librecat.org/

Patrick Hochstenbach - digital architect
University Library Ghent
Sint-Hubertusstraat 8 - 9000 Ghent - Belgium
patrick.hochstenbach at ugent.be
+32 (0)9 264 7980


-- 

*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 at il: samadi at sub.uni-goettingen.de <mailto:samadi at sub.uni-goettingen.de>
www: http://www.sub.uni-goettingen.de


-- 

*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 at il: samadi at sub.uni-goettingen.de <mailto:samadi at sub.uni-goettingen.de>
www: http://www.sub.uni-goettingen.de


-- 

*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 at il: samadi at sub.uni-goettingen.de <mailto:samadi at sub.uni-goettingen.de>
www: http://www.sub.uni-goettingen.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.uni-bielefeld.de/mailman2/unibi/public/librecat-dev/attachments/20160531/f77391dd/attachment.html>