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"
databases/mysql55 to databases/mariadb
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. Thank you, Andrei Brezan ___ 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"
databases/postgresql: simple mirroring of a database or a whole server
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 signature.asc Description: OpenPGP digital signature
Re: ports/158374: databases/firebird21-client coredumps
Hi everyone, I'm posting this to the bug and to freebsd-questions in case anyone can help me out with advice on how to investigate further. This is in regards to: http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/158374 I'm not sure if I jumped the gun on submitting the PR because the fix only partially fixed it and the next problem may or may not be related. = Actually I played with this further and maybe these things are pertinent: Everything works fine on a FreeBSD 9 VM I have: FreeBSD 9.0-CURRENT #3: Sun Apr 3 20:41:14 PDT 2011 gcc (GCC) 4.2.2 20070831 prerelease [FreeBSD] I never had to patch anything and it is the exact same version of Firebird (and PHP). I did try patching the FreeBSD 8.2 machine (as described in the other PR) and it only sortof worked It connects to a firebird database and everything seems fine (it outputs data from the database) until the end of the script where it still segfaults. I should point out that php scripts that don't connect to firebird don't segfault and I tried eliminating all other extentsions. I'm not sure how to get a better backtrace (I tried compiling php/php-extenstions/firebird with debug and they aren't stripped): # gdb php php.core #0 0x00080193a2d2 in ?? () [New Thread 8017041c0 (LWP 100293)] # file /usr/local/lib/php/20090626-debug/interbase.so /usr/local/lib/php/20090626-debug/interbase.so: ELF 64-bit LSB shared object, x86-64, version 1 (FreeBSD), dynamically linked, not stripped /usr/local/lib/libfbclient.so.2.1.3: ELF 64-bit LSB shared object, x86-64, version 1 (FreeBSD), dynamically linked, not stripped gcc on the FreeBSD 8.2 box: gcc (GCC) 4.2.1 20070719 Thanks, Mike PS Firebird itself works fine if run from isql-fb. ___ 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"
can't build graphics/xfig-3.2.5b on 8.2-STABLE nor databases/p5-DBD-Oracle with lang/perl5.14
First there is the xfig issue: No matter what the setting is for I18N (WITH or WITHOUT) there is this: cc -c -O2 -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/local/include/libpng -I/usr/local/include/X11 -I. -I/usr/local/include -DCSRG_BASED -DFUNCPROTO=15 -DNARROWPROTO -DUSE_INLINE -DUSE_XPM -DXAW3D -DXAW3D1_5E -DUSE_JPEG -DI18N -DNEWARROWTYPESe_edit.c e_edit.c: In function 'generic_window': e_edit.c:3214: warning: cast from pointer to integer of different size e_edit.c: In function 'str_panel': e_edit.c:4252: error: 'XtNinternational' undeclared (first use in this function) e_edit.c:4252: error: (Each undeclared identifier is reported only once e_edit.c:4252: error: for each function it appears in.) *** Error code 1 Stop in /usr/ports/graphics/xfig/work/xfig.3.2.5b. *** Error code 1 Stop in /usr/ports/graphics/xfig. *** Error code 1 I tracked this down to a problem in the Imakefile around line 153: #define I18N This line was not commented out when building xfig using: # make install (and WITHOUT_I18N=true inside /var/db/ports/xfig/options) Looking further I found these two lines: -XCOMM #define I18N +#define I18N inside the /usr/ports/graphics/xfig/files/patch-Imakefile patch file. I think this may be incorrect. After commenting out the #define in the Imakefile, the build of xfig was successful. Secondly, I found that building databases/p5-DBD-Oracle when Perl 5.14 (from lang/perl5.14) was present failed in the compilation of the Oracle.c file. It seems that several Perl constants sv_undef, sv_yes, and sv_no (and others) changed between Perl 5.12.3 and Perl 5.14 to PL_sv_undef, PL_yes, and PL_sv_no, respectively. I didn't take the time to debug this further since I had other Perl 5.14 issues that forced me to completely rebuild my system from scratch starting with Perl 5.12.3 (lang/perl5.12) this time. Once I had Perl 5.12.3 built, databases/p5-DBD-Oracle built just fine. My other problems with Perl 5.14 were observed trying to launch apache2 (2.2.19) with mod_perl2 (2.0.5). Those problems also went away once I rebuilt my ports starting with Perl 5.12.3 version. This makes me suspect Perl 5.14 changes or the effect those changes have had on other ports in the ports tree. Regards, web... -- William Bulley Email: w...@umich.edu 72 characters width template ->| ___ 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
databases/php5-odbc vs. libiodbc
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? ___ 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: upgrade of databases/sqlite3 to 3.6.11 fails
it is generate by the libtool code at /usr/local/bin/libtool edit that file (search for the words "not ending" and comment those 2 lines, re-install the package For me it works... Sergio ___ 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: /usr/ports/databases/dbf segmentation fault
Hi; Problem solved - the source dbf file is somehow corrupted when downloaded from an NT server to a PPC G4 Mac over a Microsoft RDC client connection. This is a repeatable result. Used rdesktop to download the files directly onto the trusty FreeBSD machine and it works fine that way. Cheers, Tom On 10/01/2009, at 12:16 PM, Tom Mende wrote: Hi; Hoping for some help on this application that converts dbf files into csv format. I'm not sure if the problem is with the source dbf file ... my usage / syntax ... and/or something else... BACKGROUND... >uname -rs FreeBSD 7.0-RELEASE >dbf --version dBase Reader and Converter V. 0.8.3.1, (c) 2002 - 2004 by Bjoern Berg ...intalled as a port from /usr/ports/databases/dbf ...make install clean ...chmod 777 cardfile.dbf # to avoid permissions problems >ls -l cardfile* -rwxrwxrwx 1 tom tom 549139 Jan 9 18:32 cardfile.dbf >dbf --view-info ~/cardfile.dbf -- File statistics dBase version.: Visual FoxPro (without memo) Date of last update...: 1908-12-15 Number of records.: 625 (0271d) Length of header..: 2888 (0b48d) Record length.: 874 (036ad) Columns in file...: 89 Rows in file..: 625 +---+---+---+--- +---+ | field name| type | field adress | length| field dec.| +---+---+---+--- +---+ | CF_NAME | C |1 | 45 | 0 | | CF_REGNAME | C | 2e | 45 | 0 | |CF_ID | C | 5b | 8 | 0 | | CF_CODE | C | 63 | 8 | 0 | |CF_EDI_ID | C | 6b | 13 | 0 | | CABN | C | 78 | 14 | 0 | | CPARENT_ID | C | 86 | 8 | 0 | |LINACTIVE | L | 8e | 1 | 0 | |LCUSTOMER | L | 8f | 1 | 0 | |LSUPPLIER | L | 90 | 1 | 0 | |LCREDITOR | L | 91 | 1 | 0 | |LEMPLOYEE | L | 92 | 1 | 0 | |LPROSPECT | L | 93 | 1 | 0 | | LSALESPERS | L | 94 | 1 | 0 | | CINVOICEST | C | 95 | 35 | 0 | | CINVOICES2 | C | b8 | 35 | 0 | | CINVOICECI | C | db | 20 | 0 | | CINVOICES3 | C | ef | 3 | 0 | | CINVOICEPO | C | f2 | 6 | 0 | | CINVOICECO | C | f8 | 25 | 0 | | CINVOICEPH | C | 111 | 20 | 0 | | CINVOICEFA | C | 125 | 20 | 0 | | CINVOICEC2 | C | 139 | 25 | 0 | | CEMAIL | C | 152 | 35 | 0 | | CMOBILE | C | 175 | 15 | 0 | | CDEFSHIPLO | C | 184 | 20 | 0 | | CDEFINVFOR | C | 198 | 1 | 0 | | CDEFSELLCU | C | 199 | 3 | 0 | | CDEFBUYCUR | C | 19c | 3 | 0 | | CDEFSALESR | C | 19f | 8 | 0 | | LPARTIALSH | L | 1a7 | 1 | 0 | | CDEFDEPT | C | 1a8 | 3 | 0 | | LWEBACCOUN | L | 1ab | 1 | 0 | |CWEBLOGIN | C | 1ac | 15 | 0 | | CWEBPASSWD | C | 1bb | 15 | 0 | | CGROUPCODE | C | 1ca | 4 | 0 | |CSORTCODE | C | 1ce | 4 | 0 | |LPRICECAT | L | 1d2 | 1 | 0 | |NPRICECAT | I | 1d3 | 4 | 0 | | IPM_ID | I | 1d7 | 4 | 0 | | LPRICEDISC | L | 1db | 1 | 0 | |NDISCOUNT | N | 1dc | 7 | 4 | | LTAXEXEMPT | L | 1e3 | 1 | 0 | | CREASON | C | 1e4 | 25 | 0 | | CF_BALANCE | Y | 1fd | 8 | 4 | | NLIMIT | Y | 205 | 8 | 4 | | NTERMS | N | 20d |
/usr/ports/databases/dbf segmentation fault
Hi; Hoping for some help on this application that converts dbf files into csv format. I'm not sure if the problem is with the source dbf file ... my usage / syntax ... and/or something else... BACKGROUND... >uname -rs FreeBSD 7.0-RELEASE >dbf --version dBase Reader and Converter V. 0.8.3.1, (c) 2002 - 2004 by Bjoern Berg ...intalled as a port from /usr/ports/databases/dbf ...make install clean ...chmod 777 cardfile.dbf # to avoid permissions problems >ls -l cardfile* -rwxrwxrwx 1 tom tom 549139 Jan 9 18:32 cardfile.dbf >dbf --view-info ~/cardfile.dbf -- File statistics dBase version.: Visual FoxPro (without memo) Date of last update...: 1908-12-15 Number of records.: 625 (0271d) Length of header..: 2888 (0b48d) Record length.: 874 (036ad) Columns in file...: 89 Rows in file..: 625 +---+---+---+--- +---+ | field name| type | field adress | length| field dec.| +---+---+---+--- +---+ | CF_NAME | C |1 | 45 | 0 | | CF_REGNAME | C | 2e | 45 | 0 | |CF_ID | C | 5b | 8 | 0 | | CF_CODE | C | 63 | 8 | 0 | |CF_EDI_ID | C | 6b | 13 | 0 | | CABN | C | 78 | 14 | 0 | | CPARENT_ID | C | 86 | 8 | 0 | |LINACTIVE | L | 8e | 1 | 0 | |LCUSTOMER | L | 8f | 1 | 0 | |LSUPPLIER | L | 90 | 1 | 0 | |LCREDITOR | L | 91 | 1 | 0 | |LEMPLOYEE | L | 92 | 1 | 0 | |LPROSPECT | L | 93 | 1 | 0 | | LSALESPERS | L | 94 | 1 | 0 | | CINVOICEST | C | 95 | 35 | 0 | | CINVOICES2 | C | b8 | 35 | 0 | | CINVOICECI | C | db | 20 | 0 | | CINVOICES3 | C | ef | 3 | 0 | | CINVOICEPO | C | f2 | 6 | 0 | | CINVOICECO | C | f8 | 25 | 0 | | CINVOICEPH | C | 111 | 20 | 0 | | CINVOICEFA | C | 125 | 20 | 0 | | CINVOICEC2 | C | 139 | 25 | 0 | | CEMAIL | C | 152 | 35 | 0 | | CMOBILE | C | 175 | 15 | 0 | | CDEFSHIPLO | C | 184 | 20 | 0 | | CDEFINVFOR | C | 198 | 1 | 0 | | CDEFSELLCU | C | 199 | 3 | 0 | | CDEFBUYCUR | C | 19c | 3 | 0 | | CDEFSALESR | C | 19f | 8 | 0 | | LPARTIALSH | L | 1a7 | 1 | 0 | | CDEFDEPT | C | 1a8 | 3 | 0 | | LWEBACCOUN | L | 1ab | 1 | 0 | |CWEBLOGIN | C | 1ac | 15 | 0 | | CWEBPASSWD | C | 1bb | 15 | 0 | | CGROUPCODE | C | 1ca | 4 | 0 | |CSORTCODE | C | 1ce | 4 | 0 | |LPRICECAT | L | 1d2 | 1 | 0 | |NPRICECAT | I | 1d3 | 4 | 0 | | IPM_ID | I | 1d7 | 4 | 0 | | LPRICEDISC | L | 1db | 1 | 0 | |NDISCOUNT | N | 1dc | 7 | 4 | | LTAXEXEMPT | L | 1e3 | 1 | 0 | | CREASON | C | 1e4 | 25 | 0 | | CF_BALANCE | Y | 1fd | 8 | 4 | | NLIMIT | Y | 205 | 8 | 4 | | NTERMS | N | 20d | 3 | 0 | | NSUPPLIERL | Y | 210 | 8 | 4 | | CSUPPLIERB | C | 218 | 10 | 0 | | CSUPPLIER2 | C | 222 | 11 | 0 | |NDISCDAYS | N | 22d | 2 | 0 | | NDISCPCENT | N | 22f |
Re: Moving user/group databases
> > On Sep 7, 2007, at 2:51 PM, [EMAIL PROTECTED] wrote: > >>> At 03:52 PM 9/7/2007, [EMAIL PROTECTED] wrote: >>>> All of my FreeBSD servers boot from CD, and we are going to be >>>> having >>>> several temporary employees coming and going over the next 6-12 >>>> months. >>>> Is it possible to move the user/group databases from their >>>> location in >>>> /etc (which is read only on my CDs) to another location? >>>> >>>> I have read the man page concerning pw and still do not >>>> understand what I >>>> should be doing. Any suggestions, or direction to a how-to would be >>>> greatly appreciated. >>>> >>>> Thanks, >>>> >>>> >>>> Jay >>> >>> The simplest way would be to put a symbolic link from /etc to a >>> writable >>> location. You will need to re-make your boot CD to have this change. >>> >>> -Derek >>> >>> -- >>> This message has been scanned for viruses and >>> dangerous content by MailScanner, and is >>> believed to be clean. >>> MailScanner thanks transtec Computers for their support. >>> >>> >> >> I have recreated the CD with the sym links, and I still run into a >> problem >> because adduser tries to create temporary files in /etc. If I >> remember >> correctly, the files it tries to create are /etc/passwd.XX. >> >> I was able to get pw to work to add the user accounts, but now I am >> trying >> to set the password for new account, and have hit the temp file snag. >> >> Is this something which can be reconfigured in pw.conf? >> >> Thanks, >> >> >> Jay > > It sounds like you made a link for /etc/master_passwd. I'm pretty > sure what DR meant was a symlink for the entire /etc directory: > > /etc -> /somewhere_writable/etc/ > > You need this because adduser also has to rewrite /etc/passwd and / > etc/group when you add/delete users. This means copying your entire / > etc hierarchy somewhere writable; naturally I don't know if this is > acceptable in your organization. > > OK. I have been able to get this to work the way I wanted to. This is what I have done. Create symbloic links in /etc to a rw directory for passwd, master.passwd, group, pw.db, spwd.db. This directory is not located on the CD. Use pw to add users, change passwords, etc. To add a user. pw -V /location/of/directory adduser -n username -h 0 Using the -h 0, you are prompted to enter the password for the user. To modify a user. pw -V /location/of/directory usermod -h 0 Changes the password for the user. Thanks to everyone for their help. Jay ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Moving user/group databases
On Sep 7, 2007, at 2:51 PM, [EMAIL PROTECTED] wrote: At 03:52 PM 9/7/2007, [EMAIL PROTECTED] wrote: All of my FreeBSD servers boot from CD, and we are going to be having several temporary employees coming and going over the next 6-12 months. Is it possible to move the user/group databases from their location in /etc (which is read only on my CDs) to another location? I have read the man page concerning pw and still do not understand what I should be doing. Any suggestions, or direction to a how-to would be greatly appreciated. Thanks, Jay The simplest way would be to put a symbolic link from /etc to a writable location. You will need to re-make your boot CD to have this change. -Derek -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks transtec Computers for their support. I have recreated the CD with the sym links, and I still run into a problem because adduser tries to create temporary files in /etc. If I remember correctly, the files it tries to create are /etc/passwd.XX. I was able to get pw to work to add the user accounts, but now I am trying to set the password for new account, and have hit the temp file snag. Is this something which can be reconfigured in pw.conf? Thanks, Jay It sounds like you made a link for /etc/master_passwd. I'm pretty sure what DR meant was a symlink for the entire /etc directory: /etc -> /somewhere_writable/etc/ You need this because adduser also has to rewrite /etc/passwd and / etc/group when you add/delete users. This means copying your entire / etc hierarchy somewhere writable; naturally I don't know if this is acceptable in your organization. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Moving user/group databases
>> At 03:52 PM 9/7/2007, [EMAIL PROTECTED] wrote: >>>All of my FreeBSD servers boot from CD, and we are going to be having >>>several temporary employees coming and going over the next 6-12 months. >>>Is it possible to move the user/group databases from their location in >>>/etc (which is read only on my CDs) to another location? >>> >>>I have read the man page concerning pw and still do not understand what >>> I >>>should be doing. Any suggestions, or direction to a how-to would be >>>greatly appreciated. >>> >>>Thanks, >>> >>> >>>Jay >> >> The simplest way would be to put a symbolic link from /etc to a writable >> location. You will need to re-make your boot CD to have this change. >> >> -Derek >> >> -- >> This message has been scanned for viruses and >> dangerous content by MailScanner, and is >> believed to be clean. >> MailScanner thanks transtec Computers for their support. >> >> > > I have recreated the CD with the sym links, and I still run into a problem > because adduser tries to create temporary files in /etc. If I remember > correctly, the files it tries to create are /etc/passwd.XX. > > I was able to get pw to work to add the user accounts, but now I am trying > to set the password for new account, and have hit the temp file snag. > > Is this something which can be reconfigured in pw.conf? > > Thanks, > > > Jay > > > OK. After some more digging, this is what I have found that I think will work. pw -V ///etc other information for user. vipw -d ///etc and make the necessary password changes, etc. The only hangup I have now is how to generate the encrypted password. Any suggestions would be greatly appreciated. The passwords in my passwd file start with $1$ which, if I remember correctly, is DES encryption. Thanks, Jay ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Moving user/group databases
On Friday 07 September 2007 23:51:43 [EMAIL PROTECTED] wrote: > > At 03:52 PM 9/7/2007, [EMAIL PROTECTED] wrote: > >>All of my FreeBSD servers boot from CD, and we are going to be having > >>several temporary employees coming and going over the next 6-12 months. > >>Is it possible to move the user/group databases from their location in > >>/etc (which is read only on my CDs) to another location? > >> > >>I have read the man page concerning pw and still do not understand what I > >>should be doing. Any suggestions, or direction to a how-to would be > >>greatly appreciated. > >> > >>Thanks, > >> > >> > >>Jay > > > > The simplest way would be to put a symbolic link from /etc to a writable > > location. You will need to re-make your boot CD to have this change. > > > > -Derek > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > MailScanner thanks transtec Computers for their support. > > I have recreated the CD with the sym links, and I still run into a problem > because adduser tries to create temporary files in /etc. If I remember > correctly, the files it tries to create are /etc/passwd.XX. > > I was able to get pw to work to add the user accounts, but now I am trying > to set the password for new account, and have hit the temp file snag. > > Is this something which can be reconfigured in pw.conf? pw -V /writeable/etc/ -- Mel ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Moving user/group databases
> At 03:52 PM 9/7/2007, [EMAIL PROTECTED] wrote: >>All of my FreeBSD servers boot from CD, and we are going to be having >>several temporary employees coming and going over the next 6-12 months. >>Is it possible to move the user/group databases from their location in >>/etc (which is read only on my CDs) to another location? >> >>I have read the man page concerning pw and still do not understand what I >>should be doing. Any suggestions, or direction to a how-to would be >>greatly appreciated. >> >>Thanks, >> >> >>Jay > > The simplest way would be to put a symbolic link from /etc to a writable > location. You will need to re-make your boot CD to have this change. > > -Derek > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > MailScanner thanks transtec Computers for their support. > > I have recreated the CD with the sym links, and I still run into a problem because adduser tries to create temporary files in /etc. If I remember correctly, the files it tries to create are /etc/passwd.XX. I was able to get pw to work to add the user accounts, but now I am trying to set the password for new account, and have hit the temp file snag. Is this something which can be reconfigured in pw.conf? Thanks, Jay ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Moving user/group databases
At 03:52 PM 9/7/2007, [EMAIL PROTECTED] wrote: All of my FreeBSD servers boot from CD, and we are going to be having several temporary employees coming and going over the next 6-12 months. Is it possible to move the user/group databases from their location in /etc (which is read only on my CDs) to another location? I have read the man page concerning pw and still do not understand what I should be doing. Any suggestions, or direction to a how-to would be greatly appreciated. Thanks, Jay The simplest way would be to put a symbolic link from /etc to a writable location. You will need to re-make your boot CD to have this change. -Derek -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks transtec Computers for their support. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Moving user/group databases
All of my FreeBSD servers boot from CD, and we are going to be having several temporary employees coming and going over the next 6-12 months. Is it possible to move the user/group databases from their location in /etc (which is read only on my CDs) to another location? I have read the man page concerning pw and still do not understand what I should be doing. Any suggestions, or direction to a how-to would be greatly appreciated. Thanks, Jay ___ 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
*** 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
databases/clip doesn't build
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 fil
Re: /usr/ports/databases/db42 >sudo make install clean
On Wed, 10 Jan 2007, David Nicholas Kayal wrote: > ===> Vulnerability check disabled, database not found > ===> Extracting for db42-4.2.52_4 Once and for all: 4.2.52_4 is a hint your ports tree isn't up to date. Can people please get used (and be prodded) to update their ports tree as a first attempt to remedy their port problems? This issue got fixed on April 14 last year... -- Matthias Andree ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: /usr/ports/databases/db42 >sudo make install clean
On Jan 10, 2007, at 9:51 AM, David Nicholas Kayal wrote: [ ... ] FreeBSD intextual.switch.wordnetworks.net 6.1-RELEASE FreeBSD 6.1- RELEASE #0: Sun May 7 04:42:56 UTC 2006 [EMAIL PROTECTED]:/ usr/obj/usr/src/sys/SMP i386 I'm actually trying to install subversion, but am running into this problem that prevents me from accomplishing that. Any help would be appreciated. Have you updated your ports tree? IIRC, Oracle acquired SleepyCat (who wrote the BDB software), and the URLs to download the tarballs have changed... -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
/usr/ports/databases/db42 >sudo make install clean
===> Vulnerability check disabled, database not found ===> Extracting for db42-4.2.52_4 => MD5 Checksum mismatch for bdb/db-4.2.52.tar.gz. => SHA256 Checksum mismatch for bdb/db-4.2.52.tar.gz. => MD5 Checksum OK for bdb/patch.4.2.52.1. => SHA256 Checksum OK for bdb/patch.4.2.52.1. => MD5 Checksum OK for bdb/patch.4.2.52.2. => SHA256 Checksum OK for bdb/patch.4.2.52.2. => MD5 Checksum OK for bdb/patch.4.2.52.3. => SHA256 Checksum OK for bdb/patch.4.2.52.3. => MD5 Checksum OK for bdb/patch.4.2.52.4. => SHA256 Checksum OK for bdb/patch.4.2.52.4. ===> Refetch for 1 more times files: bdb/db-4.2.52.tar.gz bdb/db-4.2.52.tar.gz ===> Vulnerability check disabled, database not found => db-4.2.52.tar.gz doesn't seem to exist in /usr/ports/distfiles/bdb. => Attempting to fetch from http://downloads.sleepycat.com/. fetch: http://downloads.sleepycat.com/db-4.2.52.tar.gz: size mismatch: expected 4073147, actual 3919271 => Attempting to fetch from ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/bdb/. fetch: ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/bdb/db-4.2.52.tar.gz: size mismatch: expected 4073147, actual 3919271 => Couldn't fetch it - please try to retrieve this => port manually into /usr/ports/distfiles/bdb and try again. *** Error code 1 Stop in /usr/ports/databases/db42. *** Error code 1 Stop in /usr/ports/databases/db42. FreeBSD intextual.switch.wordnetworks.net 6.1-RELEASE FreeBSD 6.1-RELEASE #0: Sun May 7 04:42:56 UTC 2006 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/SMP i386 I'm actually trying to install subversion, but am running into this problem that prevents me from accomplishing that. Any help would be appreciated. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: Externally connecting to databases?
Make sure that "skip-networking" is commented out or removed from /etc/my.cnf You may be 'turned off' there. You will need to stop - start mysql if you change this setting. mjt > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > john Mish III > Sent: Friday, 15 December 2006 8:56 AM > To: [EMAIL PROTECTED] > Subject: Externally connecting to databases? > > I have mysqld installed (4.1) on my FreeBSD 6.1 box. I need a totally > different box to connect to those databases through PHP scripts. I've > already tried editing hosts.allow in the /etc/ folder, but no > effect. Does > FreeBSD need to be restarted after these changes are done, or > just inetd, > cause I've tried inetd forcerestart, but it does nothing. > When I run my PHP > script, it waits a couple seconds, then shows a completly blank page. > > _ > View Athlete's Collections with Live Search > http://sportmaps.live.com/index.html?source=hmemailtaglinenov0 > 6&FORM=MGAC01 > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "[EMAIL PROTECTED]" > --- The information transmitted in this e-mail is for the exclusive use of the intended addressee and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of it, or the taking of any action in reliance upon this information by persons and/or entities other than the intended recipient is prohibited. If you received this in error, please inform the sender and/or addressee immediately and delete the material. E-mails may not be secure, may contain computer viruses and may be corrupted in transmission. Please carefully check this e-mail (and any attachment) accordingly. No warranties are given and no liability is accepted for any loss or damage caused by such matters. --- ### This e-mail message has been scanned for Viruses by Bytecraft ### ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Externally connecting to databases?
I have mysqld installed (4.1) on my FreeBSD 6.1 box. I need a totally different box to connect to those databases through PHP scripts. I've already tried editing hosts.allow in the /etc/ folder, but no effect. Does FreeBSD need to be restarted after these changes are done, or just inetd, cause I've tried inetd forcerestart, but it does nothing. When I run my PHP script, it waits a couple seconds, then shows a completly blank page. _ View AthleteÂ’s Collections with Live Search http://sportmaps.live.com/index.html?source=hmemailtaglinenov06&FORM=MGAC01 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Mirroring GNATS locally - /usr/ports/databases/gnats marked as forbidden
On 9/5/06 15:06, "Frank Steinborn" <[EMAIL PROTECTED]> wrote: > Hello, > > I want to mirror the FreeBSD-GNATS db at home, as shown in the > Committers Guide. However, gnats in Ports is marked as forbidden. Can > I safely use GNATS4 instead? Is it compatible to GNATS3 databases? Nope. I just run a local copy with the setuid bit taken off. Ceri -- That must be wonderful! I don't understand it at all. -- Moliere ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Mirroring GNATS locally - /usr/ports/databases/gnats marked as forbidden
Hello, I want to mirror the FreeBSD-GNATS db at home, as shown in the Committers Guide. However, gnats in Ports is marked as forbidden. Can I safely use GNATS4 instead? Is it compatible to GNATS3 databases? Thanks! Frank ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: ports/databases/mysql50-server: where is mysql_upgrade ?
In the last episode (Feb 22), James Long said: > Section 5.6.2 of the MySQL 5.0 docs says: > > 5.6.2. mysql_upgrade -- Check Tables for MySQL Upgrade > > mysql_upgrade should be executed each time you upgrade MySQL. It > checks all tables in all databases for incompatibilities with the > current version of MySQL Server. > > After installing mysql50-server, there is no mysql_upgrade on > my system: At the bottom of that section is this sentence: mysql_upgrade was added in MySQL 5.0.19. It supersedes the older mysql_fix_privilege_tables script. 5.0.19 hasn't been released yet, but I expect that when it is, and the port is updated to build it, the command will be available. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
ports/databases/mysql50-server: where is mysql_upgrade ?
Section 5.6.2 of the MySQL 5.0 docs says: 5.6.2. mysql_upgrade -- Check Tables for MySQL Upgrade mysql_upgrade should be executed each time you upgrade MySQL. It checks all tables in all databases for incompatibilities with the current version of MySQL Server. After installing mysql50-server, there is no mysql_upgrade on my system: pe850 : 19:44:15 /root# [1]+ Done( /usr/libexec/locate.updatedb ) pe850 : 19:44:27 /root# locate mysql_upgrade pe850 : 19:44:32 /root# I am building a new server with MySQL 5.0.18 running on FreeBSD 6.1-PRERELEASE and importing data from 3.22.32 running on 4.4-STABLE. Where can I locate mysql_upgrade? Thanks, Jim ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
MIS Databases development
How can i develop my MIS databases software with mysql in freebsd. i used to be borland delphi(since no kylix under freebsd), thanks - Meet your soulmate! Yahoo! Asia presents Meetic - where millions of singles gather ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
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]"
databases/mysql41-server
Hi, Anyone have any idea when 4.1.12 will be commited to the ports tree? It's been available for quite some time now... Thanks, Chris. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: /usr/ports/databases/mysql(-devel)?
> In the last episode (Sep 14), Steve Bertrand said: >> I'm attempting to install freeradius from ports, but it heavily >> relies upon mysql-devel being installed. >> >> In 4.7 it was actually in ports. Now, it does not appear to be >> there. >> There is however, an option in the makefile which is disabled >> (--without-debug). If I enable this configure option, is this >> effectively installing all the devel stuff for MySQL? > > There was never a mysql-devel port afaik; the mysql ports have always > been numbered. The freeradius port currently depends on mysql 4.0.x, > which should get built and installed automatically by the ports system > when you try and build freeradius. Ok, I thought there was one. Yesterday, I was trying to install FreeRADIUS on a box that already had MySQL installed on it (from source, not ports) and it was having a problem locating rlm_sql_mysql.so. Searching, I found I had to install mysql-devel. This morning, I am installing on a fresh install (5.2.1), and actually never crossed my mind to install freeradius port first, and let it handle the mysql dependencies. I am trying that now... Tks for the reminder, that ports will build in their own dependencies ;o) Steve > -- > Dan Nelson > [EMAIL PROTECTED] > ___ > [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]"
Re: /usr/ports/databases/mysql(-devel)?
In the last episode (Sep 14), Steve Bertrand said: > I'm attempting to install freeradius from ports, but it heavily > relies upon mysql-devel being installed. > > In 4.7 it was actually in ports. Now, it does not appear to be there. > There is however, an option in the makefile which is disabled > (--without-debug). If I enable this configure option, is this > effectively installing all the devel stuff for MySQL? There was never a mysql-devel port afaik; the mysql ports have always been numbered. The freeradius port currently depends on mysql 4.0.x, which should get built and installed automatically by the ports system when you try and build freeradius. What problem are you having building the freeradius port, exactly? -- Dan Nelson [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
/usr/ports/databases/mysql(-devel)?
I'm attempting to install freeradius from ports, but it heavily relies upon mysql-devel being installed. In 4.7 it was actually in ports. Now, it does not appear to be there. There is however, an option in the makefile which is disabled (--without-debug). If I enable this configure option, is this effectively installing all the devel stuff for MySQL? Tks, Steve ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Update Databases from Webserver
FreeBSD Mail Lists wrote: > Richard, > Thanks for your reply. I thought there was something terribly wrong with > that logic. So I thought I would ask in this mail list since people have > been great here in the past about everything else I wanted to know. > Are there any security lists in relation to ecommerce that you would > recommend? So I can stop annoying everyone else here. I just don't want > to make anymore mistakes than I have to starting down this road. I don't really know of any good security list... I'd sure be happy to HEAR of one, mind you. To be honest, I suspect there isn't really a good security list, because this is simply the kind of thing that so *FEW* people actually do, that there isn't a critical mass of people doing it and needing help for a good mailing list to exist. Please don't take my "tone" as being annoyed. I basically just wanted to "scare" you into *NOT* doing what you plan to do. It's incredibly dangerous, and carries an inordinate amount of risk. If you absolutely *MUST* do this, hire a security expert to help you design/program it. It's just not a good idea to do what you said you wanted to do on your own your first time. If your boss/manage won't accept that, tell them you'll need all their personal credit cards for testing purposes until you're SURE the system is secure and safe from thieves. They may change their tune at that point. -- Like Music? http://l-i-e.com/artists.htm ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: Update Databases from Webserver
> -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-freebsd- > [EMAIL PROTECTED] On Behalf Of Peter Risdon > Sent: Tuesday, September 07, 2004 1:14 PM > To: FreeBSD Mail Lists > Cc: Questions > Subject: Re: Update Databases from Webserver > > FreeBSD Mail Lists wrote: > > Peter, Thanks for your response. In response to > > > >> You don't say why you'd want to do this. If you want to allow > >> customers of an e-commerce site to avoid repeating their details > >> whenever they want to buy, perhaps consider basing the payment > >> backend around PayPal. The need for users to authenticate in order > >> to make a payment hasn't brought e-Bay to its knees. > > > > > > Pretty much the end result would be Amazon like with the customer > > being able to choose a previously used card. Is this possible > > without storing credit card numbers or using paypal? > > > > Well, yes, this is a convenience. But there's a very good reason why you > only find this at very big online retailers like Amazon: It's a biggie. > All the replies you had that I've seen point this out one way or another. Exactly right, I would look for a credit card processing company that supports the functionality you are looking for and use their existing functionality and let them absorb the liability if something horrible were to happen. You generally don't want to be the company or person that is responsible for exposing financial information. Jason > > Peter. > ___ > [EMAIL PROTECTED] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions- > [EMAIL PROTECTED]" ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Update Databases from Webserver
FreeBSD Mail Lists wrote: Peter, Thanks for your response. In response to You don't say why you'd want to do this. If you want to allow customers of an e-commerce site to avoid repeating their details whenever they want to buy, perhaps consider basing the payment backend around PayPal. The need for users to authenticate in order to make a payment hasn't brought e-Bay to its knees. Pretty much the end result would be Amazon like with the customer being able to choose a previously used card. Is this possible without storing credit card numbers or using paypal? Well, yes, this is a convenience. But there's a very good reason why you only find this at very big online retailers like Amazon: It's a biggie. All the replies you had that I've seen point this out one way or another. Peter. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Update Databases from Webserver
Peter, Thanks for your response. In response to > You don't say why you'd want to do this. If you want to allow customers > of an e-commerce site to avoid repeating their details whenever they > want to buy, perhaps consider basing the payment backend around PayPal. > The need for users to authenticate in order to make a payment hasn't > brought e-Bay to its knees. Pretty much the end result would be Amazon like with the customer being able to choose a previously used card. Is this possible without storing credit card numbers or using paypal? Anyway thanks everyone for their replies thus far any input helps. -Troy -Original message- From: Peter Risdon [EMAIL PROTECTED] Date: Tue, 7 Sep 2004 07:18:22 -0600 To: FreeBSD Mail Lists [EMAIL PROTECTED] Subject: Re: Update Databases from Webserver > I'm afraid the awful truth is that if you need to ask this question > here, you shouldn't be storing other people's credit card details on > your server. > > > If you want to use the numbers to confirm identity or something, you > could store an encrypted version of the number and use that for comparison. > > But to start storing plaintext CC details on your system without being > deeply expert in all the security issues raised would be very dangerous. > And the high degree of monitoring needed for such a system would make it > uneconomical without commensurately high volumes of business. > > Peter. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Update Databases from Webserver
On Mon, 6 Sep 2004, FreeBSD Mail Lists wrote: I would like to see how other people are updating backend databases (postgresql on FreeBSD, internal network) from a webserver (apache,php on FreeBSD, dmz network) through a firewall. Pretty much what I am trying to learn is how to take private information (credit card numbers, etc.) and write it to a backend database without leaving any huge holes for hacking. Should this be done or am I barking up the wrong tree, I'm afraid the awful truth is that if you need to ask this question here, you shouldn't be storing other people's credit card details on your server. You don't say why you'd want to do this. If you want to allow customers of an e-commerce site to avoid repeating their details whenever they want to buy, perhaps consider basing the payment backend around PayPal. The need for users to authenticate in order to make a payment hasn't brought e-Bay to its knees. If you want to use the numbers to confirm identity or something, you could store an encrypted version of the number and use that for comparison. But to start storing plaintext CC details on your system without being deeply expert in all the security issues raised would be very dangerous. And the high degree of monitoring needed for such a system would make it uneconomical without commensurately high volumes of business. Peter. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Update Databases from Webserver
On Mon, 6 Sep 2004, FreeBSD Mail Lists wrote: > I would like to see how other people are updating backend databases > (postgresql on FreeBSD, internal network) from a webserver (apache,php > on FreeBSD, dmz network) through a firewall. Pretty much what I am > trying to learn is how to take private information (credit card numbers, > etc.) and write it to a backend database without leaving any huge holes > for hacking. Should this be done or am I barking up the wrong tree, > should there be an intermediary step? I have been trying to find > information books/web that gives a real nuts and bolts way of trying to > do this stuff and am not having a lot of luck. Any pointers books or > sites would be appreciated. First thing to consider - do you -have- to store things like credit card numbers ? Most clearing houses can be negotiated with on-line; during the transaction and all you need to capture is an authorization ack. That already makes things a lot safer. Secondly - carefully consider what you need to have on your webserver; do you really have to store a name/address there long term; or is a login and some preferences enough ? Thirdly consider making the flow a one way street: using things like a PGP email with just the public key on the web server; i.e. shunt any private information into an encrypted email - send it to your systems in-house; and only have the decryption key behind the firewall; and thus only keeping the bare essentials on your server. Dw ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Update Databases from Webserver
On Mon, Sep 06, 2004 at 10:55:42PM -0600 or thereabouts, FreeBSD Mail Lists wrote: > Richard, > Thanks for your reply. I thought there was something terribly wrong > with that logic. So I thought I would ask in this mail list since > people have been great here in the past about everything else I > wanted to know. > Are there any security lists in relation to ecommerce that you > would recommend? So I can stop annoying everyone else here. > I just don't want to make anymore mistakes than I have to > starting down this road. Stop talking like that. You are not annoying anyone in here. You asked the question, you got the replies. Richard wrote nice email. But it would be much better and less painful for you, if you could run your credit card transactions using services of your Bank, or maybe by some kind of well know and trustworthy billing system. Why should you have dreamless nights? Credit card info is very *very* sensitive information. So ask yourself, do you really need to have all the stress or can you leave it to your bank/billing partner (although for small fee)? And mainly, are you well known to your customers, even to those which are new? Because if I am about to give someone my credit card info I will not trust to e-commerce application provider, but to well known bank or such. Cheers, Martin Hudec > > -Original message- > From: "Richard Lynch" [EMAIL PROTECTED] > Date: Mon, 6 Sep 2004 17:22:54 -0600 > To: "FreeBSD Mail Lists" [EMAIL PROTECTED] > Subject: Re: Update Databases from Webserver > > > FreeBSD Mail Lists wrote: > > > I would like to see how other people are updating backend databases > > > (postgresql on FreeBSD, internal network) from a webserver (apache,php on > > > FreeBSD, dmz network) through a firewall. Pretty much what I am trying to > > > learn is how to take private information (credit card numbers, etc.) and > > > write it to a backend database without leaving any huge holes for hacking. > > > Should this be done or am I barking up the wrong tree, should there be an > > > intermediary step? I have been trying to find information books/web that > > > gives a real nuts and bolts way of trying to do this stuff and am not > > > having a lot of luck. Any pointers books or sites would be appreciated. > > > > The most common answer is "Don't do that" > > > > 99.9% of e-commerce sites have absolutely no business storing credit > > card numbers on any hardware they own. > > > > They should simply run the transaction through their Merchant Account > > (bank) computer using a secure connection, and the software provided by > > their Merchant Account (bank). > > > > If you need a recurring charge, you can run your charge through the > > Merchant Account as a "recurring charge" (whoda thunk it?) and the > > Merchant Account software will give you back a unique transaction # to > > refer to if you ever need to cancel THAT particular recurring charge. You > > would store only that transaction number, and *NOT* the customer's credit > > card charge. > > > > In the unlikely event that you really *ARE* in the 0.01% of servers > > that needs to store credit card info... Well, it's kinda scare that > > you're asking here, rather than a security mailing list, but here is *ONE* > > solution that may be worth considering. > > > > I am posting to the list so that others can tell us just how inadequate > > this is. > > > > You should also be aware that by no means am I an "expert" -- I am simply > > describing what has been described to me as the "right way" (tm) to do > > this. > > > > My information may be out of date. (It's been awhile.) > > > > I chose to let the Merchant Account (bank) worry about keeping credit card > > numbers safe, rather than do all of the following. > > > > You probably should too. > > > > Depending on the current interpretation of existing laws, you, the web > > developer, may or may not be held responsible for *ANY* damages that > > result from your work -- no matter how faultless you may be in reality. > > We're talking legalities here, not reality. > > > > Did I mention that you really shouldn't be doing this at all? Good. > > > > > > > > First, your servers *MUST* be in a physically secure location, with access > > limited to *ONLY* people you really really really trust. > > > > No software in the world will do you any damn good if a not-so-honest > > person can
Re: Update Databases from Webserver
Troy, Maybe the 'commercial question' that should be asked is.. "Why do you need this highly troublesome data within your system?" NOTE : I am not expecting you to answer that here in public forum, but maybe you as (potential) sysadmin should be asking it of your CEO, CIO, legal pipple, etc etc. You want to be sure that you have very good paper covering _your_ nether regions! ;-o my 0.02c worth mjt On Tue, 2004-09-07 at 14:55, FreeBSD Mail Lists wrote: > Richard, > Thanks for your reply. I thought there was something terribly wrong with that > logic. So I thought I would ask in this mail list since people have been great here > in the past about everything else I wanted to know. > Are there any security lists in relation to ecommerce that you would recommend? So > I can stop annoying everyone else here. I just don't want to make anymore mistakes > than I have to starting down this road. > > Thanks again, > > Troy > > -Original message- > From: "Richard Lynch" [EMAIL PROTECTED] > Date: Mon, 6 Sep 2004 17:22:54 -0600 > To: "FreeBSD Mail Lists" [EMAIL PROTECTED] > Subject: Re: Update Databases from Webserver > > > FreeBSD Mail Lists wrote: > > > I would like to see how other people are updating backend databases > > > (postgresql on FreeBSD, internal network) from a webserver (apache,php on > > > FreeBSD, dmz network) through a firewall. Pretty much what I am trying to > > > learn is how to take private information (credit card numbers, etc.) and > > > write it to a backend database without leaving any huge holes for hacking. > > > Should this be done or am I barking up the wrong tree, should there be an > > > intermediary step? I have been trying to find information books/web that > > > gives a real nuts and bolts way of trying to do this stuff and am not > > > having a lot of luck. Any pointers books or sites would be appreciated. > > > > The most common answer is "Don't do that" > > > > 99.9% of e-commerce sites have absolutely no business storing credit > > card numbers on any hardware they own. > > > > They should simply run the transaction through their Merchant Account > > (bank) computer using a secure connection, and the software provided by > > their Merchant Account (bank). > > > > If you need a recurring charge, you can run your charge through the > > Merchant Account as a "recurring charge" (whoda thunk it?) and the > > Merchant Account software will give you back a unique transaction # to > > refer to if you ever need to cancel THAT particular recurring charge. You > > would store only that transaction number, and *NOT* the customer's credit > > card charge. > > > > In the unlikely event that you really *ARE* in the 0.01% of servers > > that needs to store credit card info... Well, it's kinda scare that > > you're asking here, rather than a security mailing list, but here is *ONE* > > solution that may be worth considering. > > > > I am posting to the list so that others can tell us just how inadequate > > this is. > > > > You should also be aware that by no means am I an "expert" -- I am simply > > describing what has been described to me as the "right way" (tm) to do > > this. > > > > My information may be out of date. (It's been awhile.) > > > > I chose to let the Merchant Account (bank) worry about keeping credit card > > numbers safe, rather than do all of the following. > > > > You probably should too. > > > > Depending on the current interpretation of existing laws, you, the web > > developer, may or may not be held responsible for *ANY* damages that > > result from your work -- no matter how faultless you may be in reality. > > We're talking legalities here, not reality. > > > > Did I mention that you really shouldn't be doing this at all? Good. > > > > > > > > First, your servers *MUST* be in a physically secure location, with access > > limited to *ONLY* people you really really really trust. > > > > No software in the world will do you any damn good if a not-so-honest > > person can waltz in and play around with the hardware! > > > > If you *CANNOT* guarantee that the hardware in question can *ONLY* be > > accessed by trusted individuals, than you should stop reading right here > > and now. > > > > This rules out shared servers, co-location (IMHO), and almost all > > corporate servers, which need too many people of limited trust va
Re: Update Databases from Webserver
Richard, Thanks for your reply. I thought there was something terribly wrong with that logic. So I thought I would ask in this mail list since people have been great here in the past about everything else I wanted to know. Are there any security lists in relation to ecommerce that you would recommend? So I can stop annoying everyone else here. I just don't want to make anymore mistakes than I have to starting down this road. Thanks again, Troy -Original message- From: "Richard Lynch" [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 17:22:54 -0600 To: "FreeBSD Mail Lists" [EMAIL PROTECTED] Subject: Re: Update Databases from Webserver > FreeBSD Mail Lists wrote: > > I would like to see how other people are updating backend databases > > (postgresql on FreeBSD, internal network) from a webserver (apache,php on > > FreeBSD, dmz network) through a firewall. Pretty much what I am trying to > > learn is how to take private information (credit card numbers, etc.) and > > write it to a backend database without leaving any huge holes for hacking. > > Should this be done or am I barking up the wrong tree, should there be an > > intermediary step? I have been trying to find information books/web that > > gives a real nuts and bolts way of trying to do this stuff and am not > > having a lot of luck. Any pointers books or sites would be appreciated. > > The most common answer is "Don't do that" > > 99.9% of e-commerce sites have absolutely no business storing credit > card numbers on any hardware they own. > > They should simply run the transaction through their Merchant Account > (bank) computer using a secure connection, and the software provided by > their Merchant Account (bank). > > If you need a recurring charge, you can run your charge through the > Merchant Account as a "recurring charge" (whoda thunk it?) and the > Merchant Account software will give you back a unique transaction # to > refer to if you ever need to cancel THAT particular recurring charge. You > would store only that transaction number, and *NOT* the customer's credit > card charge. > > In the unlikely event that you really *ARE* in the 0.01% of servers > that needs to store credit card info... Well, it's kinda scare that > you're asking here, rather than a security mailing list, but here is *ONE* > solution that may be worth considering. > > I am posting to the list so that others can tell us just how inadequate > this is. > > You should also be aware that by no means am I an "expert" -- I am simply > describing what has been described to me as the "right way" (tm) to do > this. > > My information may be out of date. (It's been awhile.) > > I chose to let the Merchant Account (bank) worry about keeping credit card > numbers safe, rather than do all of the following. > > You probably should too. > > Depending on the current interpretation of existing laws, you, the web > developer, may or may not be held responsible for *ANY* damages that > result from your work -- no matter how faultless you may be in reality. > We're talking legalities here, not reality. > > Did I mention that you really shouldn't be doing this at all? Good. > > > > First, your servers *MUST* be in a physically secure location, with access > limited to *ONLY* people you really really really trust. > > No software in the world will do you any damn good if a not-so-honest > person can waltz in and play around with the hardware! > > If you *CANNOT* guarantee that the hardware in question can *ONLY* be > accessed by trusted individuals, than you should stop reading right here > and now. > > This rules out shared servers, co-location (IMHO), and almost all > corporate servers, which need too many people of limited trust value to be > able to access them to keep them up. > > Next, you need a SECOND server which will be used to hold credit card > info, and that second computer will *NOT* be connected to the Internet > (directly) > > You put an extra NIC in your web-server, and run a cross-over cable to the > SECOND server, the extra one, which will hold the credit card numbers. > > You limit ethernet access to that second computer which will hold credit > cards so that *ONLY* the one computer connected to it via the cross-over > cable will be allowed to connect. > > The "extra" NIC in the web-server and the SECOND server are both on a > separate sub-net from everything else in your system. IE, the only > interface cards in your entire organization that utilize the IP address > space in question are those two (2) NICs. > > You then make 100%
Re: Update Databases from Webserver
FreeBSD Mail Lists wrote: > I would like to see how other people are updating backend databases > (postgresql on FreeBSD, internal network) from a webserver (apache,php on > FreeBSD, dmz network) through a firewall. Pretty much what I am trying to > learn is how to take private information (credit card numbers, etc.) and > write it to a backend database without leaving any huge holes for hacking. > Should this be done or am I barking up the wrong tree, should there be an > intermediary step? I have been trying to find information books/web that > gives a real nuts and bolts way of trying to do this stuff and am not > having a lot of luck. Any pointers books or sites would be appreciated. The most common answer is "Don't do that" 99.9% of e-commerce sites have absolutely no business storing credit card numbers on any hardware they own. They should simply run the transaction through their Merchant Account (bank) computer using a secure connection, and the software provided by their Merchant Account (bank). If you need a recurring charge, you can run your charge through the Merchant Account as a "recurring charge" (whoda thunk it?) and the Merchant Account software will give you back a unique transaction # to refer to if you ever need to cancel THAT particular recurring charge. You would store only that transaction number, and *NOT* the customer's credit card charge. In the unlikely event that you really *ARE* in the 0.01% of servers that needs to store credit card info... Well, it's kinda scare that you're asking here, rather than a security mailing list, but here is *ONE* solution that may be worth considering. I am posting to the list so that others can tell us just how inadequate this is. You should also be aware that by no means am I an "expert" -- I am simply describing what has been described to me as the "right way" (tm) to do this. My information may be out of date. (It's been awhile.) I chose to let the Merchant Account (bank) worry about keeping credit card numbers safe, rather than do all of the following. You probably should too. Depending on the current interpretation of existing laws, you, the web developer, may or may not be held responsible for *ANY* damages that result from your work -- no matter how faultless you may be in reality. We're talking legalities here, not reality. Did I mention that you really shouldn't be doing this at all? Good. First, your servers *MUST* be in a physically secure location, with access limited to *ONLY* people you really really really trust. No software in the world will do you any damn good if a not-so-honest person can waltz in and play around with the hardware! If you *CANNOT* guarantee that the hardware in question can *ONLY* be accessed by trusted individuals, than you should stop reading right here and now. This rules out shared servers, co-location (IMHO), and almost all corporate servers, which need too many people of limited trust value to be able to access them to keep them up. Next, you need a SECOND server which will be used to hold credit card info, and that second computer will *NOT* be connected to the Internet (directly) You put an extra NIC in your web-server, and run a cross-over cable to the SECOND server, the extra one, which will hold the credit card numbers. You limit ethernet access to that second computer which will hold credit cards so that *ONLY* the one computer connected to it via the cross-over cable will be allowed to connect. The "extra" NIC in the web-server and the SECOND server are both on a separate sub-net from everything else in your system. IE, the only interface cards in your entire organization that utilize the IP address space in question are those two (2) NICs. You then make 100% sure that you simply cannot get to that SECOND box from anywhere else in the organization. What is quite well-documented is that you use SSL (and ONLY SSL) to allow the customer to get their credit card info to your web-server. You then write some routines to get the credit card numbers from your web-server through your second NIC to the second server. These routines get the fine-tooth code-review treatment, by multiple people. They should be mind-numbingly simple, clearly documented, and do the absolute minimum possible to conduct your business. You test these routines every way you can think of to see how they can be broken. You hire an outside security audit team to test your server and routines to see how they can be broken. You use something like tripwire to raise nine kinds of hell if anything changes on the portion of the web-server that talks to the SECOND machine, and, of course, if anything (other than data) changes on the SECOND machine. Under *NO* circumstances should the routines *EVER* store the credit card numbers in any file, database, shared memory, or anything less t
Update Databases from Webserver
Hello, I would like to see how other people are updating backend databases (postgresql on FreeBSD, internal network) from a webserver (apache,php on FreeBSD, dmz network) through a firewall. Pretty much what I am trying to learn is how to take private information (credit card numbers, etc.) and write it to a backend database without leaving any huge holes for hacking. Should this be done or am I barking up the wrong tree, should there be an intermediary step? I have been trying to find information books/web that gives a real nuts and bolts way of trying to do this stuff and am not having a lot of luck. Any pointers books or sites would be appreciated. Thanks for your time. Troy ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Mirroring Mysql databases - and secure tunneling, while I'm at it.
Andy Holyer wrote: I've looked in the docs, and used google, and I need a quick steer as to the best way to proceed. Our company is running two servers: one is a public web/mail/dns server sitting in a rack at Telecity, the other one is sitting here right next to me, and should never be seen outside of the office. Both are running FreeBSD-CURRENT. Both carry MySQL databases: the public one will carry cyrus mail, and authentication data for a radius server, the private one will carry our customer account data. What I'd like to do, following my principle that buildings tend to burn down one at a time, is to set the two databases to mirror each other, so that we would be able to reconstitute either database if the need were to arise. I'd like this to be as easy and automatic as possible. Is there a standard vanilla way of doing this, or do I have to get inventive? Database replication is a standard feature of mysql. Look in the mysql docs for the word replication. PWR. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Mirroring Mysql databases - and secure tunneling, while I'm at it.
I've looked in the docs, and used google, and I need a quick steer as to the best way to proceed. Our company is running two servers: one is a public web/mail/dns server sitting in a rack at Telecity, the other one is sitting here right next to me, and should never be seen outside of the office. Both are running FreeBSD-CURRENT. Both carry MySQL databases: the public one will carry cyrus mail, and authentication data for a radius server, the private one will carry our customer account data. What I'd like to do, following my principle that buildings tend to burn down one at a time, is to set the two databases to mirror each other, so that we would be able to reconstitute either database if the need were to arise. I'd like this to be as easy and automatic as possible. Is there a standard vanilla way of doing this, or do I have to get inventive? On the same tack, I'd like to have an encrypted pipe between the two servers (over which this company-confidential data will travel). Since one of the servers is behind a NAT (and soon will be behind a firewall, too), I'd like to use CIPE rather then IPSec. Am I correct in finding that CIPE is not implemented on FreeBSD? Do i have to use IPSec? Thanks for any leads. --- Andy Holyer, Technical stuff Hedgehog Broadband, 11 Marlborough Place Brighton BN1 1UB 08451 260895 x 241 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: How can I rebuild prots databases?
On Fri, Mar 05, 2004 at 03:06:18PM -0500, stan wrote: > On Fri, Mar 05, 2004 at 05:09:06AM -0800, Kris Kennaway wrote: > > On Fri, Mar 05, 2004 at 07:18:45AM -0500, stan wrote: > > > > > > > > > I'm getting things like this when I run portupgrade: > > > > > > > > > > > > > > ! (pgaccess-0.98.6)(missing origin) > > > > > > > ! (acroread-3.02) (missing origin) > > > > > > > ! (netscape-wrapper-2000.07.07)(missing origin) > > > > > Well I spent about 3 hours yesterday afternoon filling in package names to pkgdb > > > -F's prompts, > > > and I still can't get portupfrade to work :-) > > > > OK, that's a different problem than you told us about above. > > > > Please be more specific: in what way does portupgrade not work for > > you? Include sample output showing the problem(s). > > OK, look at this session: > > > Script started on Fri Mar 5 13:15:11 2004 > You have mail. > wateral# runsocks portupgrade -arR -l /home/stan/report > cd: can't cd to /usr/ports/X11/XFree86-4 > make: don't know how to make all-depends-list. Stop > > ^C > Interrupted. > wateral# > [Kwateral# ^Dexit > > Script done on Fri Mar 5 13:34:03 2004 > > As you can see, it just hangs there. That's 19 minutes with just the first > error, which is caused by a typo in my setting up things by hand (should be > x11, not X11). pkgd is not allowing me to fix that either. > > Any sugestiosn? For each package that has been set to the wrong location, use the -o option to portupgrade (perhaps with the -f option) to rebuild it from the correct location. Kris pgp0.pgp Description: PGP signature
Re: How can I rebuild prots databases?
On Fri, Mar 05, 2004 at 05:09:06AM -0800, Kris Kennaway wrote: > On Fri, Mar 05, 2004 at 07:18:45AM -0500, stan wrote: > > > > > > > I'm getting things like this when I run portupgrade: > > > > > > > > > > > > ! (pgaccess-0.98.6)(missing origin) > > > > > > ! (acroread-3.02) (missing origin) > > > > > > ! (netscape-wrapper-2000.07.07)(missing origin) > > > Well I spent about 3 hours yesterday afternoon filling in package names to pkgdb > > -F's prompts, > > and I still can't get portupfrade to work :-) > > OK, that's a different problem than you told us about above. > > Please be more specific: in what way does portupgrade not work for > you? Include sample output showing the problem(s). OK, look at this session: Script started on Fri Mar 5 13:15:11 2004 You have mail. wateral# runsocks portupgrade -arR -l /home/stan/report cd: can't cd to /usr/ports/X11/XFree86-4 make: don't know how to make all-depends-list. Stop ^C Interrupted. wateral# [Kwateral# ^Dexit Script done on Fri Mar 5 13:34:03 2004 As you can see, it just hangs there. That's 19 minutes with just the first error, which is caused by a typo in my setting up things by hand (should be x11, not X11). pkgd is not allowing me to fix that either. Any sugestiosn? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: How can I rebuild prots databases?
On Fri, Mar 05, 2004 at 07:18:45AM -0500, stan wrote: > > > > > I'm getting things like this when I run portupgrade: > > > > > > > > > > ! (pgaccess-0.98.6)(missing origin) > > > > > ! (acroread-3.02) (missing origin) > > > > > ! (netscape-wrapper-2000.07.07)(missing origin) > Well I spent about 3 hours yesterday afternoon filling in package names to pkgdb > -F's prompts, > and I still can't get portupfrade to work :-) OK, that's a different problem than you told us about above. Please be more specific: in what way does portupgrade not work for you? Include sample output showing the problem(s). Kris pgp0.pgp Description: PGP signature
Re: How can I rebuild prots databases?
On Thu, Mar 04, 2004 at 05:06:29PM -0800, Kris Kennaway wrote: > On Thu, Mar 04, 2004 at 04:36:21PM -0500, stan wrote: > > On Thu, Mar 04, 2004 at 11:52:32AM -0800, Kris Kennaway wrote: > > > On Thu, Mar 04, 2004 at 08:07:54AM -0500, stan wrote: > > > > I'n updating a bunch of older (around 4.2) machines. On ne of them I seem > > > > to have managed to toatly muck up the ports dayabases :0( > > > > > > > > I'm getting things like this when I run portupgrade: > > > > > > > > ! (pgaccess-0.98.6)(missing origin) > > > > ! (acroread-3.02) (missing origin) > > > > ! (netscape-wrapper-2000.07.07)(missing origin) > > > > > > Whichever way you go you'll have to either reinstall these ports by > > > hand or tell portupgrade where they live in the ports tree (see > > > e.g. the -o flag to portupgrade). You installed them before the ports > > > collection started recording the location of the port used to install > > > the package, so you can rebuild the databases as much as you like, but > > > it won't fix it :) > > > > > > AH, that explains what's goin on. > > > > Is there a way to do this without spending a whole day or so doing things > > manually? > > I told you above how you'll have to go about solving it. It shouldn't > take more than a couple of minutes. Well I spent about 3 hours yesterday afternoon filling in package names to pkgdb -F's prompts, and I still can't get portupfrade to work :-) What do I need to delete to just start from scratch, and build this by had? Is portdb -F the correct way to be building it by hand? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: How can I rebuild prots databases?
On Thu, Mar 04, 2004 at 04:36:21PM -0500, stan wrote: > On Thu, Mar 04, 2004 at 11:52:32AM -0800, Kris Kennaway wrote: > > On Thu, Mar 04, 2004 at 08:07:54AM -0500, stan wrote: > > > I'n updating a bunch of older (around 4.2) machines. On ne of them I seem > > > to have managed to toatly muck up the ports dayabases :0( > > > > > > I'm getting things like this when I run portupgrade: > > > > > > ! (pgaccess-0.98.6)(missing origin) > > > ! (acroread-3.02) (missing origin) > > > ! (netscape-wrapper-2000.07.07)(missing origin) > > > > Whichever way you go you'll have to either reinstall these ports by > > hand or tell portupgrade where they live in the ports tree (see > > e.g. the -o flag to portupgrade). You installed them before the ports > > collection started recording the location of the port used to install > > the package, so you can rebuild the databases as much as you like, but > > it won't fix it :) > > > AH, that explains what's goin on. > > Is there a way to do this without spending a whole day or so doing things > manually? I told you above how you'll have to go about solving it. It shouldn't take more than a couple of minutes. Kris pgp0.pgp Description: PGP signature
Re: How can I rebuild prots databases?
On Thu, Mar 04, 2004 at 11:52:32AM -0800, Kris Kennaway wrote: > On Thu, Mar 04, 2004 at 08:07:54AM -0500, stan wrote: > > I'n updating a bunch of older (around 4.2) machines. On ne of them I seem > > to have managed to toatly muck up the ports dayabases :0( > > > > I'm getting things like this when I run portupgrade: > > > > ! (pgaccess-0.98.6)(missing origin) > > ! (acroread-3.02) (missing origin) > > ! (netscape-wrapper-2000.07.07)(missing origin) > > Whichever way you go you'll have to either reinstall these ports by > hand or tell portupgrade where they live in the ports tree (see > e.g. the -o flag to portupgrade). You installed them before the ports > collection started recording the location of the port used to install > the package, so you can rebuild the databases as much as you like, but > it won't fix it :) AH, that explains what's goin on. Is there a way to do this without spending a whole day or so doing things manually? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: How can I rebuild prots databases?
On Thu, Mar 04, 2004 at 08:07:54AM -0500, stan wrote: > I'n updating a bunch of older (around 4.2) machines. On ne of them I seem > to have managed to toatly muck up the ports dayabases :0( > > I'm getting things like this when I run portupgrade: > > ! (pgaccess-0.98.6)(missing origin) > ! (acroread-3.02) (missing origin) > ! (netscape-wrapper-2000.07.07)(missing origin) Whichever way you go you'll have to either reinstall these ports by hand or tell portupgrade where they live in the ports tree (see e.g. the -o flag to portupgrade). You installed them before the ports collection started recording the location of the port used to install the package, so you can rebuild the databases as much as you like, but it won't fix it :) Kris pgp0.pgp Description: PGP signature
Re: How can I rebuild prots databases?
On Thursday 04 March 2004 05:07 am, stan wrote: > I'n updating a bunch of older (around 4.2) machines. On ne of them I > seem to have managed to toatly muck up the ports dayabases :0( > > I'm getting things like this when I run portupgrade: > > ! (pgaccess-0.98.6)(missing origin) > ! (acroread-3.02) (missing origin) > ! (netscape-wrapper-2000.07.07)(missing origin) > > I think the best plan is to completly rebuild from scratch the > databases that contain available ports, and the ports that are > installed on this machine. I've tried various combinations of pkgdb > -F and pkgd -Uu. to no avail. > > Can I just remove all of these databases, and rebuiold them from > scratch? If so, how do I acomplish this? Try portsdb -fu but I think I would manually instally ruby-1.8, ruby18-bdb1-0.2.2, and portupgrade first. Kent -- Kent Stewart Richland, WA http://users.owt.com/kstewart/index.html ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
How can I rebuild prots databases?
I'n updating a bunch of older (around 4.2) machines. On ne of them I seem to have managed to toatly muck up the ports dayabases :0( I'm getting things like this when I run portupgrade: ! (pgaccess-0.98.6)(missing origin) ! (acroread-3.02) (missing origin) ! (netscape-wrapper-2000.07.07)(missing origin) I think the best plan is to completly rebuild from scratch the databases that contain available ports, and the ports that are installed on this machine. I've tried various combinations of pkgdb -F and pkgd -Uu. to no avail. Can I just remove all of these databases, and rebuiold them from scratch? If so, how do I acomplish this? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin ___ [EMAIL PROTECTED] 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]"
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]"
Re: restoring mysql databases from mysqldump was Re: upgradingmysql
On Sat, 2003-08-30 at 05:33, Michelle wrote: Not really FreeBSD specific..but.. :) > I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, > but now when I try to restore the backups using mysql "database name" > < backup-file.sql, It states unknown database. I also have a > mysqlhotcopy backup of all my databases. Am I doing something wrong > when trying to recover multiple databases? How can I recover them from > the mysqlhotcopy rather then the dump if something went wrong with the > dump? mysqldump -A will save all databases, so when restoring you only need: mysql < backup-file.sql not: mysql "database name" < backup-file.sql This will try to restore only one database (which you need to create first). This ways is only needed if you do a mysqldump "databasename" > backup.sql. -- "Optimized, readable, on time; Pick any two." FreeBSD 5.1-CURRENT i386 11:45PM up 1 day, 1:43, 4 users, load averages: 1.33, 1.47, 1.41 signature.asc Description: This is a digitally signed message part
Re: restoring mysql databases from mysqldump was Re: upgrading mysql
I believe I succesfully restored the databases by running simply mysql > backup-file.sql. However, I believe the permissions are not working properly. Apache is unable to connect the sql server and I cannot shutdown the sql server with the user name and password I normally use. On Friday, August 29, 2003, at 02:33 PM, Michelle wrote: I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, but now when I try to restore the backups using mysql "database name" < backup-file.sql, It states unknown database. I also have a mysqlhotcopy backup of all my databases. Am I doing something wrong when trying to recover multiple databases? How can I recover them from the mysqlhotcopy rather then the dump if something went wrong with the dump? On Friday, August 29, 2003, at 01:01 PM, Lucas Holt wrote: That sounds correct. I would recommend doing a binary backup as well in case something happens. (i usually tar up the mysql directory with the service off) If you want extra security, you could use the phpMyAdmin software to backup the databases as well.. so you have an extra copy. I believe it actually runs mysqldump anyway though. If you can eventually, I'd recommend the 4.x releases. I have had great success with them. On Friday, August 29, 2003, at 02:56 PM, Michelle wrote: I would like to upgrade mysql from mysql-server-3.23.54 to mysql-server-3.23.57 and understand that I will need to do a dump before upgrading since the upgrade needs to overwrite the databases. Since I have never done this before, I just want to make sure I have the correct steps after reading over the mysql site and the man >> pages. First I will dump all of my databases: mysqldump -A > backup-file.sql Then I will shutdown the mysql server and upgrade the mysql port with the environment variable OVERWRITE_DB defined when running make install. To rebuild the databases do I simply use: mysqldump --all-databases > backup-file.sql and then restart the mysql server using mysqld_safe Am I missing any steps? Thank you, Michelle ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" Lucas Holt [EMAIL PROTECTED] FoolishGames.com (Jewel Fan Site) JustJournal.com (Free blogging) "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." - Albert Einstein (1879-1955) ___ [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]"
Re: restoring mysql databases from mysqldump was Re: upgrading mysql
On Fri, Aug 29, 2003 at 02:33:07PM -0700, Michelle wrote: > I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, > but now when I try to restore the backups using mysql "database name" > < backup-file.sql, It states unknown database. I've never had a mysql upgrade trash my databases, but it sounds like the simple solution is to 'mysqladmin create "database name"' first. Though the -A does seem to put create database commands in the dump file. You might look at the sql and find out what's broken... I tried dumping all mine, and got a "client out of memory" error. Weird. -- Alan Batie __alan.batie.orgMe alan at batie.org\/www.qrd.org The Triangle PGPFP DE 3C 29 17 C0 49 7A\ / www.pgpi.com The Weird Numbers 27 40 A5 3C 37 4A DA 52 B9 \/ spamassassin.taint.org NO SPAM! To announce that there must be no criticism of the President, or that we are to stand by the President, right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public. -Theodore Roosevelt, 26th US President (1858-1919) pgp0.pgp Description: PGP signature
restoring mysql databases from mysqldump was Re: upgrading mysql
I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, but now when I try to restore the backups using mysql "database name" < backup-file.sql, It states unknown database. I also have a mysqlhotcopy backup of all my databases. Am I doing something wrong when trying to recover multiple databases? How can I recover them from the mysqlhotcopy rather then the dump if something went wrong with the dump? On Friday, August 29, 2003, at 01:01 PM, Lucas Holt wrote: That sounds correct. I would recommend doing a binary backup as well in case something happens. (i usually tar up the mysql directory with the service off) If you want extra security, you could use the phpMyAdmin software to backup the databases as well.. so you have an extra copy. I believe it actually runs mysqldump anyway though. If you can eventually, I'd recommend the 4.x releases. I have had great success with them. On Friday, August 29, 2003, at 02:56 PM, Michelle wrote: I would like to upgrade mysql from mysql-server-3.23.54 to mysql-server-3.23.57 and understand that I will need to do a dump before upgrading since the upgrade needs to overwrite the databases. Since I have never done this before, I just want to make sure I have the correct steps after reading over the mysql site and the man >> pages. First I will dump all of my databases: mysqldump -A > backup-file.sql Then I will shutdown the mysql server and upgrade the mysql port with the environment variable OVERWRITE_DB defined when running make install. To rebuild the databases do I simply use: mysqldump --all-databases > backup-file.sql and then restart the mysql server using mysqld_safe Am I missing any steps? Thank you, Michelle ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" Lucas Holt [EMAIL PROTECTED] FoolishGames.com (Jewel Fan Site) JustJournal.com (Free blogging) "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." - Albert Einstein (1879-1955) ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: SecFix for databases/firebird, please review
On Wed, 27 Aug 2003 08:33:43 -0700 Joshua Oreman <[EMAIL PROTECTED]> wrote: > > > You also still don't add: > > > > > > buf[sizeof(buf) - 1] = '\0'; > > > > > > after all strncat(3)s. > > > > Hmmm... yes, I see the problem... > > >From strncat(3): > char* strncat (char * restrict s, const char * restrict append, size_t count); > [ ... ] > The strncat function appends not more than count characters from > append, and then adds a terminating `\0'. > (emphasis added) ^^^ > > So here there really isn't a problem. Are you sure? Lets see (pseudocode): target[100]="abcde"; source="123456"; strncat(target, source, 5); What's the result (just by looking at the man-page): - abcde12345 - abcde12345\0 - abcde1234\0 Now, write a program which verifies your assumption. Bye, Alexander. -- The best things in life are free, but the expensive ones are still worth a look. http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: SecFix for databases/firebird, please review
On Wed, Aug 27, 2003 at 11:17:33AM +0200 or thereabouts, Alexander Leidinger wrote: > On Wed, 27 Aug 2003 10:10:36 +0200 > Pawel Jakub Dawidek <[EMAIL PROTECTED]> wrote: > > > On Mon, Aug 18, 2003 at 11:59:28AM +0200, Alexander Leidinger wrote: > > +> Thanks for the review. I've updated > > +> http://www.leidinger.net/FreeBSD/firebird-1.0.2-secfix.tar.bz2 (modulo > > +> Chris' work in progress). I'm looking forward to the next round. :-) > > > > IMHO there are still problems with strncat(3). > > [ ... ] > > You also still don't add: > > > > buf[sizeof(buf) - 1] = '\0'; > > > > after all strncat(3)s. > > Hmmm... yes, I see the problem... >From strncat(3): char* strncat (char * restrict s, const char * restrict append, size_t count); [ ... ] The strncat function appends not more than count characters from append, and then adds a terminating `\0'. (emphasis added) ^^^ So here there really isn't a problem. -- Josh ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
problem making port databases/ruby-bdb1
I'm having a problem on two machines (an Athlon and an Alpha each running 4.8-PRE) with the ruby-bdb1 port (req'd by portupgrade). I cvsup my ports tree every night (and run "portsdb -uU"). While upgrading each box, I deinstalled the ruby-bdb1 port and have tried to re-make it (by running "make install clean" as root from the ruby-bdb1 directory). Here's the result of the build: ---> Installing 'ruby-bdb1-0.1.8' from a port (databases/ruby-bdb1) ---> Building '/usr/ports/databases/ruby-bdb1' ===> Cleaning for ruby-1.8.0.p2 ===> Cleaning for ruby-rdoc-0.0.0.b2 ===> Cleaning for ruby-bdb1-0.1.8 ===> Extracting for ruby-bdb1-0.1.8 >> Checksum OK for ruby/bdb1-0.1.8.tar.gz. ===> Patching for ruby-bdb1-0.1.8 ===> Configuring for ruby-bdb1-0.1.8 ===> ruby-bdb1-0.1.8 depends on file: /usr/local/bin/ruby - found ===> ruby-bdb1-0.1.8 depends on file: /usr/local/bin/rdoc - found ===> Running extconf.rb to configure extconf.rb: Entering directory `src' checking for dbopen()... yes creating Makefile extconf.rb: Leaving directory `src' ===> Building for ruby-bdb1-0.1.8 cc -fPIC -O -pipe -march=k6 -fPIC -I. -I/usr/local/lib/ruby/1.8/i386-freebsd4 -I/usr/local/lib/ruby/1.8/i386-freebsd4 -I. -DHAVE_DBOPEN -I/usr/local/include -c bdb1.c cc -fPIC -O -pipe -march=k6 -fPIC -I. -I/usr/local/lib/ruby/1.8/i386-freebsd4 -I/usr/local/lib/ruby/1.8/i386-freebsd4 -I. -DHAVE_DBOPEN -I/usr/local/include -c recnum.c cc -fPIC -O -pipe -march=k6 -fPIC -I. -I/usr/local/lib/ruby/1.8/i386-freebsd4 -I/usr/local/lib/ruby/1.8/i386-freebsd4 -I. -DHAVE_DBOPEN -I/usr/local/include -c delegate.c cc -shared -rdynamic -L/usr/local/lib -Wl,-soname,bdb1.so -L"/usr/local/lib" -L"/usr/local/lib" -o bdb1.so bdb1.o recnum.o delegate.o -lruby -lcrypt -lm -lc cd /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8; /usr/bin/env SHELL=/bin/sh PORTOBJFORMAT=elf PREFIX=/usr/local LOCALBASE=/usr/local X11BASE=/usr/X11R6 MOTIFLIB="-L/usr/X11R6/lib -lXm -lXp" LIBDIR="/usr/lib" CFLAGS="-O -pipe -march=k6" CXXFLAGS=" -O -pipe -march=k6" MANPREFIX="/usr/local" BSD_INSTALL_PROGRAM="install -c -s -o root -g wheel -m 555" BSD_INSTALL_SCRIPT="install -c -o root -g wheel -m 555" BSD_INSTALL_DATA="install -c -o root -g wheel -m 444" BSD_INSTALL_MAN="install -c -o root -g wheel -m 444" make -f Makefile rdoc /usr/local/bin/rdoc:2:in `require': No such file to load -- rdoc/rdoc (LoadError) from /usr/local/bin/rdoc:2 *** Error code 1 (ignored) ---> Installing the new version via the port ===> Installing for ruby-bdb1-0.1.8 ===> ruby-bdb1-0.1.8 depends on file: /usr/local/bin/ruby - found ===> Generating temporary packing list /bin/mkdir -p /usr/local/share/examples/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/examples/* /usr/local/share/examples/ruby/bdb1/ /bin/mkdir -p /usr/local/share/doc/ruby/bdb1 /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/Changes /usr/local/share/doc/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/README.en /usr/local/share/doc/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/bdb1.html /usr/local/share/doc/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/bdb1.rd /usr/local/share/doc/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/docs/*.html /usr/local/share/doc/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/docs/*.rd /usr/local/share/doc/ruby/bdb1/ /bin/cp -R /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/docs/doc /usr/local/share/doc/ruby/bdb1/ cp: /usr/ports/databases/ruby-bdb1/work/bdb1-0.1.8/docs/doc: No such file or directory *** Error code 1 Stop in /usr/ports/databases/ruby-bdb1. *** Error code 1 Stop in /usr/ports/databases/ruby-bdb1. ! databases/ruby-bdb1 (install error) Am I missing something obvious? The ruby-rdoc is installed. Thanks! -- Michael A. Smith <[EMAIL PROTECTED]> Programmer at Large To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message
Can't build databases/portgresql7
I know this is my fault, because I've checked the error logs on bento and it's building fine there, but I keep getting the following error trying to build the postgresql7 port: ## error log starts gmake[5]: Entering directory `/usr/ports/databases/postgresql7/work/postgresql-7.2.3/src/backend/access/heap' cc -O -pipe -march=pentiumpro -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -c -o heapam.o heapam.c cc -O -pipe -march=pentiumpro -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -c -o hio.o hio.c cc -O -pipe -march=pentiumpro -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -c -o tuptoaster.o tuptoaster.c tuptoaster.c: In function `toast_delete_datum': tuptoaster.c:914: `F_OIDEQ' undeclared (first use in this function) tuptoaster.c:914: (Each undeclared identifier is reported only once tuptoaster.c:914: for each function it appears in.) tuptoaster.c: In function `toast_fetch_datum': tuptoaster.c:997: `F_OIDEQ' undeclared (first use in this function) gmake[5]: *** [tuptoaster.o] Error 1 gmake[5]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.2.3/src/backend/access/heap' gmake[4]: *** [heap-recursive] Error 2 gmake[4]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.2.3/src/backend/access' gmake[3]: *** [access-recursive] Error 2 gmake[3]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.2.3/src/backend' gmake[2]: *** [all] Error 2 gmake[2]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.2.3/src' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.2.3' gmake: *** [all] Error 2 *** Error code 2 Stop in /usr/ports/databases/postgresql7. *** Error code 1 Stop in /usr/ports/databases/postgresql7 ## error log ends Indications on the postgresql lists seem to indicate that this may be a problem with awk, but I can't see why this would be failing. Any suggestions ? Thanks, Ceri -- you can't see when light's so strong you can't see when light is gone To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message
Moving gdbm databases from Linux to FreeBSD
I have been asked to move a Python application that uses gdbm (databases/py-gdbm) databases from Linux to FreeBSD. The actual database files do not appear to be transportable; it appears to do with block size from stat(2), and the fact that FreeBSD uses a 64 bit offset where Linux uses 32 bits. Short of unloading all the data under Linux and importing it again on FreeBSD, does anyone know of a way to use the original Linux databases on FreeBSD? _ Antony Russell Technical Director Clarotech Consulting (Pty) Ltd EMail: [EMAIL PROTECTED] Phone: 021.671.5350 To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message