Re: databases/mysql55 to databases/mariadb
Andrei Brezan wrote: [snip] > Also what i've noticed is that 'p' as a suffix is for percona. Oops! And I was thinking Percona but for some reason PostgreSQL came out my fingers! DOH! -Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: databases/mysql55 to databases/mariadb
On 03/28/13 19:05, Michael Powell wrote: Andrei Brezan wrote: Hello list, Is there a make.conf option that I can use to replace mysql55-[server,client] with mariadb55-[server,client] or i need to use for example pkg set -o databases/mysql55-client:databases/mariadb55-client? What happens if I want to use one port with mysql dependency and another one with mariadb as dependency? This is just a theoretical question, I don't have such a requirement, yet. All this is on 9.1-RELEASE but I think applies to different versions too. Look at: /usr/ports/Mk/bsd.database.mk I only perused it briefly, but I think you want something such as MYSQL_VER=55m. The 'm', or 'p' suffix switches to either MariaDB or PostgreSQL if I understand correctly. At any rate, this is the file that controls this. If it doesn't work (possibly I've got it wrong), I'd suggest a PR to get it added in. -Mike Hi Mike, Why I'm trying to put this in make.conf is for poudriere to build a local repo. It seems that I needed to add WITH_MYSQL_VER=55m for eg security/amavisd-new to grab maria instead of my. Also what i've noticed is that 'p' as a suffix is for percona. Thanks for the tip, Andrei ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: databases/mysql55 to databases/mariadb
Andrei Brezan wrote: > Hello list, > > Is there a make.conf option that I can use to replace > mysql55-[server,client] with mariadb55-[server,client] or i need to use > for example pkg set -o > databases/mysql55-client:databases/mariadb55-client? > > What happens if I want to use one port with mysql dependency and another > one with mariadb as dependency? This is just a theoretical question, I > don't have such a requirement, yet. > > All this is on 9.1-RELEASE but I think applies to different versions too. > Look at: /usr/ports/Mk/bsd.database.mk I only perused it briefly, but I think you want something such as MYSQL_VER=55m. The 'm', or 'p' suffix switches to either MariaDB or PostgreSQL if I understand correctly. At any rate, this is the file that controls this. If it doesn't work (possibly I've got it wrong), I'd suggest a PR to get it added in. -Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: databases/postgresql: simple mirroring of a database or a whole server
On 01/15/13 13:14, Amitabh Kant wrote: > On Tue, Jan 15, 2013 at 4:24 PM, O. Hartmann > wrote: > >> Hello list. >> >> First, please set me CC, i do not subscribe this list. >> >> I'd like to ask for a mirroring solution of an important databse on my >> installations across at least three boxes. The setup is as follows. >> >> Operating system is FreeBSD 10.0/amd and 9.1-STABLE/amd64. A top of the >> OS there is on all machines in question port >> databases/postgresql92-server|client running. >> >> I have a database that needs to be synchronized/mirrored. A data >> consistency in a narrow timeframe isn't necessary. The database in >> question is a very important literature reference db which is maintained >> via a web interface and this is done mostly from a private box at home, >> which changes the local database set. This database is also used at the >> lab. Usually, I have to dump the db, send it via ssh/scp over the net to >> the target machine and restore it - and this at least three times. Since >> network connectivity isn't available for some technical reasons when I >> maintain the local db at home, this task is a pain, if I forget to >> dump/restore the database. The task maintaining the databases like that >> isn't appreciable. >> >> So, I looked out for a mirroring solution. I came across SLONY I/II, but >> I feel not very comfortable with the complicated setup. Although having >> had a howto, it dind't work properly. So I'm looking for something more >> simple. >> >> The data consistency within short timeframes isn't so important, so a >> mission critical mirroring isn't necessary. But I would be feel better >> having something more "automatic" that is synchronizing more than two or >> three machines automatically when network connectivity is available. >> >> Is there a solution - easy task - to handle such a scenario? >> >> Thanks in advance, >> Oliver >> >> > Since you are using postgresql 9.2, why don't you use the inbuilt > replication that comes with it. You might be interested in this page > http://www.postgresql.org/docs/9.2/static/high-availability.html . > > In case you face any difficulties, u can always head over to pgsql mailing > list. (pgsql-gene...@postgresql.org) > > Amitabh > Thank you very much for this hint! I'm new to the 9.X series, so I didn't realize that there is something new built-in. Valuable hint. Regards, Oliver signature.asc Description: OpenPGP digital signature
Re: databases/postgresql: simple mirroring of a database or a whole server
On Tue, Jan 15, 2013 at 4:24 PM, O. Hartmann wrote: > Hello list. > > First, please set me CC, i do not subscribe this list. > > I'd like to ask for a mirroring solution of an important databse on my > installations across at least three boxes. The setup is as follows. > > Operating system is FreeBSD 10.0/amd and 9.1-STABLE/amd64. A top of the > OS there is on all machines in question port > databases/postgresql92-server|client running. > > I have a database that needs to be synchronized/mirrored. A data > consistency in a narrow timeframe isn't necessary. The database in > question is a very important literature reference db which is maintained > via a web interface and this is done mostly from a private box at home, > which changes the local database set. This database is also used at the > lab. Usually, I have to dump the db, send it via ssh/scp over the net to > the target machine and restore it - and this at least three times. Since > network connectivity isn't available for some technical reasons when I > maintain the local db at home, this task is a pain, if I forget to > dump/restore the database. The task maintaining the databases like that > isn't appreciable. > > So, I looked out for a mirroring solution. I came across SLONY I/II, but > I feel not very comfortable with the complicated setup. Although having > had a howto, it dind't work properly. So I'm looking for something more > simple. > > The data consistency within short timeframes isn't so important, so a > mission critical mirroring isn't necessary. But I would be feel better > having something more "automatic" that is synchronizing more than two or > three machines automatically when network connectivity is available. > > Is there a solution - easy task - to handle such a scenario? > > Thanks in advance, > Oliver > > Since you are using postgresql 9.2, why don't you use the inbuilt replication that comes with it. You might be interested in this page http://www.postgresql.org/docs/9.2/static/high-availability.html . In case you face any difficulties, u can always head over to pgsql mailing list. (pgsql-gene...@postgresql.org) Amitabh ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: databases/php5-odbc vs. libiodbc
On 2010-Jun-15, 19:21, Kyryll A Mirnenko aka Mirya wrote: > Currently the databases/php5-odbc PHP extension is hardcoded to be compiled > with unixODBC backend, so the users that have libiodbc installed (as a > dependency of kde4 ports, for ex.) can't installed the first 'cause those two > ODBC ports conflict with each other. > The php-odbc configure script however says (./configure --help) it can be > compiled with iODBC support (--with-iodbc=/usr/local), but for some reason > simply replacing the configure script arguments for the port (with libiodbc > installed from ports) result in nothing being done: the configure script > creates the Makefile with empty target, so nothing is built actually. > Did anyone have success before with building php5-odbc lniked to iodbc > backend? I've been able have the php5-odbc extension link against libiodbc by applying this patch [1] to lang/php5. I haven't conducted any run-tests, though. Please feel free to report success / failure :) [1] http://people.freebsd.org/~gahr/Makefile.ext.diff -- Pietro Cerutti The FreeBSD Project g...@freebsd.org PGP Public Key: http://gahr.ch/pgp pgpN03aRYEJZy.pgp Description: PGP signature
Re: databases/clip doesn't build
*** Error code 1 Stop in /usr/ports/databases/clip. [EMAIL PROTECTED] /usr/ports/databases/clip]# exit Script done on Sun Feb 25 23:57:04 2007 Basically it (gcc/gmake) are looking for headers / definitions that don't exist in the included files. Please submit the information included above and the configuration script output to the port maintainer. -Garrett already did http://www.freebsd.org/cgi/query-pr.cgi?pr=109485 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: databases/clip doesn't build
Wojciech Puchar wrote:
fails on gtkextra and says that /usr/local/bin/gtk12-config doesn't exist
gtk12-config is here:
gtk12-config is hashed (/usr/X11R6/bin/gtk12-config)
what's wrong?
Script started on Sun Feb 25 23:56:13 2007
[EMAIL PROTECTED] /usr/ports/databases/clip]# make
===> clip-1.1.16.1_1 depends on executable in : bash - found
===> clip-1.1.16.1_1 depends on executable in : wget - found
===> clip-1.1.16.1_1 depends on executable in : xmkmf - found
===> clip-1.1.16.1_1 depends on executable in : gmake - found
===> clip-1.1.16.1_1 depends on executable in : bison - found
===> clip-1.1.16.1_1 depends on file: /usr/local/bin/intltool-extract
- found
===> clip-1.1.16.1_1 depends on executable in : pkg-config - found
===> clip-1.1.16.1_1 depends on shared library: jpeg.9 - found
===> clip-1.1.16.1_1 depends on shared library: png.5 - found
===> clip-1.1.16.1_1 depends on shared library: freetype.9 - found
===> clip-1.1.16.1_1 depends on shared library: gtkextra.17 - not found
===>Verifying install for gtkextra.17 in
/usr/ports/x11-toolkits/gtkextra
===> Vulnerability check disabled, database not found
===> Extracting for gtkextra-0.99.17_2
=> MD5 Checksum OK for gtk+extra-0.99.17.tar.gz.
=> SHA256 Checksum OK for gtk+extra-0.99.17.tar.gz.
===> Patching for gtkextra-0.99.17_2
===> Applying FreeBSD patches for gtkextra-0.99.17_2
===> gtkextra-0.99.17_2 depends on executable in : gmake - found
===> gtkextra-0.99.17_2 depends on file: /usr/local/bin/libtool - found
===> gtkextra-0.99.17_2 depends on executable in : pkg-config - found
===> gtkextra-0.99.17_2 depends on shared library: glib-12.3 - found
===> gtkextra-0.99.17_2 depends on shared library: gtk-12.2 - found
===> gtkextra-0.99.17_2 depends on shared library: X11.6 - found
===> Configuring for gtkextra-0.99.17_2
creating cache ./config.cache
checking for a BSD compatible install... /usr/bin/install -c -o root -g
wheel
checking whether build environment is sane... yes
checking whether gmake sets ${MAKE}... yes
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... found
checking whether build environment is sane... yes
checking for gcc... cc
checking whether the C compiler (cc -O2 -fno-strict-aliasing -pipe
-march=pentium3 ) works... yes
checking whether the C compiler (cc -O2 -fno-strict-aliasing -pipe
-march=pentium3 ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether cc accepts -g... yes
checking for POSIXized ISC... no
checking for cc option to accept ANSI C... none needed
checking for a BSD compatible install... /usr/bin/install -c -o root -g
wheel
checking whether gmake sets ${MAKE}... (cached) yes
checking host system type... i386-portbld-freebsd6.2
checking build system type... i386-portbld-freebsd6.2
checking for ranlib... ranlib
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
updating cache ./config.cache
loading cache ./config.cache within ltconfig
checking for object suffix... o
checking for executable suffix... no
checking for cc option to produce PIC... -fPIC
checking if cc PIC flag -fPIC works... yes
checking if cc supports -c -o file.o... yes
checking if cc supports -c -o file.lo... yes
checking if cc supports -fno-rtti -fno-exceptions ... no
checking if cc static flag -static works... -static
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the linker (/usr/bin/ld) supports shared libraries... yes
checking command to parse /usr/bin/nm -B output... ok
checking how to hardcode library paths into programs... immediate
checking for /usr/bin/ld option to reload object files... -r
checking dynamic linker characteristics... freebsd6.2 ld.so
checking if libtool supports shared libraries... yes
*** Warning: the command libtool uses to detect shared libraries,
*** /usr/bin/file, produces output that libtool cannot recognize.
*** The result is that libtool may fail to recognize shared libraries
*** as such. This will affect the creation of libtool libraries that
*** depend on shared libraries, but programs linked with such libtool
*** libraries will work regardless of this problem. Nevertheless, you
*** may want to report the problem to your system manager and/or to
*** bug-libtool@gnu.org
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for objdir... .libs
creating libtool
updating cache ./config.cache
loading cache ./config.cache
checking whether to enable maintainer-specific portions of Makefiles... no
checking host system type... i386-portbld-freebsd6.2
checking how to run the C preprocessor... cc -E
checking for ANSI C header files... yes
checking for working const... yes
checking f
Re: databases/mysql41-server
Chris Knipe wrote: Anyone have any idea when 4.1.12 will be commited to the ports tree? It's been available for quite some time now... Please test http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/81690 Regards Björn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Databases
On Wed, 22 Oct 2003, E. J. Cerejo wrote: > I just went through the download page of postgresql but I couldn't see > the client for windows, could you send me the link for the client or is > it accessible with IE? For starters most databases don't have "clients" in the sense of a program to connect to use and use/changed/play with the data. Most SQL databases such as PostgreSQL "Serve requests" to "clients". Clients usually come as custom programs done for a particular purpose or administrative types of programs that among other things allow you to interact with the database and it's data. What I believe others where trying to point you to are the ODBC drivers. Basically a series of programs that let yet other programs talk to the database. I would recommend you look into PHP as to not have to worry about the clients. Are you planning on doing this syste/database yourself? Are you familiar with doing programs? There are different ways you could go about this, just let us know your background so we can further comment. For instance if only one user was to update the data and it would be read only for the rest you could get an administration program for PostgreSQL (and there are several both free and commercial) and manually enter the data. For the output to the users I would still recommend PHP (a programming language which would not be all that difficult for you to pickup if you have done some programming). ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Databases
> I just went through the download page of postgresql but I couldn't see > the client for windows, could you send me the link for the client or is > it accessible with IE? As with most things Microsoft, IE sucks, and it really sucks at FTP. Try a real FTP client and/or a mirror. FTP to ftp9.us.postgresql.org (or appropriate mirror), then navigate to /pub/mirrors/postgresql/odbc/versions/msi and find the newest version (7.03 I believe). Also, have a look at these pages: http://gborg.postgresql.org/project/psqlodbc/projdisplay.php http://gborg.postgresql.org/project/psqlodbc/genpage.php?downloads http://gborg.postgresql.org/project/psqlodbc/faq/faq.php ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Databases
E. J. Cerejo wrote: I have a small business and I'm looking to setup a freebsd server. I want to connect about 4 clients to this server running windows XP. The Freebsd server will keep a database of every customer address, phone number, what services that were performed, how much was charged, etc etc. This is basically all I need for now and I was wondering which opensource database would do this in the easiest possible way. Also what software would I use in the client boxes to access this database (input and output). Best regards to all ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" As other have written, MySQL is the way to good. If you buy the FreeBSD CD MySQL is on the CD. All you need to is down load 3.51 ODBC drivers which work great with MS Office, or you can use PHP to write your own web base apps. We are currently using MySQL with ODBC and PHP and really love the fact that we can custom our web apps to the way we want them to work vs. the way out of the box apps work. Also take a look at phpMyAdmin or MySQL Center Control these are great apps to help admin the database. Plus, there are thousand of Open Source programs and code that you can find to help you. Payne ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Databases
[EMAIL PROTECTED] wrote: I have a small business and I'm looking to setup a freebsd server. I want to connect about 4 clients to this server running windows XP. The Freebsd server will keep a database of every customer address, phone number, what services that were performed, how much was charged, etc etc. This is basically all I need for now and I was wondering which opensource database would do this in the easiest possible way. Also what software would I use in the client boxes to access this database (input and output). My suggestion would be either MySQL or PostgreSQL as both have a ODBC clients for Windows. http://www.mysql.com http://www.postgresql.org I just went through the download page of postgresql but I couldn't see the client for windows, could you send me the link for the client or is it accessible with IE? Best regards ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Databases
> I have a small business and I'm looking to setup a freebsd server. I > want to connect about 4 clients to this server running windows XP. The > Freebsd server will keep a database of every customer address, phone > number, what services that were performed, how much was charged, etc > etc. This is basically all I need for now and I was wondering which > opensource database would do this in the easiest possible way. Also > what software would I use in the client boxes to access this database > (input and output). My suggestion would be either MySQL or PostgreSQL as both have a ODBC clients for Windows. http://www.mysql.com http://www.postgresql.org ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: Databases
MySQL + PHP (or Perl) will allow you to use IE on XP. cheers Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of E. J. Cerejo Sent: Wednesday, October 22, 2003 2:45 PM To: freebsd-questions Subject: Databases I have a small business and I'm looking to setup a freebsd server. I want to connect about 4 clients to this server running windows XP. The Freebsd server will keep a database of every customer address, phone number, what services that were performed, how much was charged, etc etc. This is basically all I need for now and I was wondering which opensource database would do this in the easiest possible way. Also what software would I use in the client boxes to access this database (input and output). Best regards to all ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
