Re: Gnome 2.16 in OpenBSD Is anyone working on it?
Sam Fourman Jr. wrote: I have spent a few months,trying to find out if someone is working on a update to a more recent version of Gnome Desktop,and that answer is still unclear, but i am hopeful :) I have tried to build Gnome but I can't seem to get past glib, I have a Past post about the build error. Gnome on OpenBSD is reasonably outdated, and to the extent of my current ability I would like to do my part in bringing Gnome to OpenBSD. I'm working on it. I currently have round about 75% ported, as I have to do this for a customer and my timeframe is very very short, I currently don't have much time to contribute back, but I expect some results available for the public at the end of the week. But be warned, the ports are currently far away from perfect, the focus is that it works, not that its perfect :). But this will hopefully come later. So please give me a little bit more time. Alex smime.p7s Description: S/MIME Cryptographic Signature
Re: OpenBSD for kids: Ri-li-1.2.0
On Tue, 17 Oct 2006 16:53:21 -0400 Josh Grosse [EMAIL PROTECTED] wrote: On Tue, Oct 17, 2006 at 07:00:03PM +0200, Antoine Jacoutot wrote: Allright... I needed a do something useless-break and came up with this. PKG/DESCR Ri-li is a arcade game where you drive a toy wood engine in many levels and you must collect all the coaches for win. - Colorful animated wood engine - 40 levels - 3 beautiful musics and many sound effects - 8 languages (Arabic, Chinese, English, French, German, Japanese, Russian, Spanish) Built and runs fine on i386. built and runs fine on macppc too.
NEW: net/barnyard
COMMENT=output spool reader for Snort Barnyard can read the binary file formats of the unified alert and log spool files and present that data to output plugins, which can then format the data for output to whatever reporting and storage system is desired (database, XML,pcap, syslog, etc). Available flavors: mysql - enable mysql database logging support postgresql - enable postgresql database logging support sguil - enable support for spooling to sguil server http://secure.lv/~nikns/stuff/ports/barnyard-0.2.0.tar feedback and corrections appricated.
Re: NEW: visitors
yeah.. here's the tarball :-D -- Mathieu Sauve-Frankel visitors.tgz Description: application/tar-gz
NEW: devel/itk
COMMENT=framework for building mega-widgets using the Itcl object system [incr Tk] is a framework for building mega-widgets using the [incr Tcl] object system. Mega-widgets are high-level widgets like a file browser or a tab notebook that act like ordinary Tk widgets but are constructed using Tk widgets as component parts, without having to write C code. In effect, a mega-widget looks and acts exactly like a Tk widget, but is considerably easier to implement. http://secure.lv/~nikns/stuff/ports/itk-3.3.tar feedback and corrections appricated.
NEW: devel/mysqltcl
COMMENT=mysql tcl interface MySQLTcl is a Tcl library which makes possible to do SQL queries (select, insert, delete...) to a MySQL database server from Tcl scripts. http://secure.lv/~nikns/stuff/ports/mysqltcl-3.02.tar feedback and corrections appricated.
NEW: net/sancp
COMMENT=security analyst network connection profiler This is a network security tool designed to collect statistical information regarding network traffic, as well as, collect the traffic itself in pcap format, all for the purpose of: auditing, historical analysis, and network activity discovery. Rules can be used to distinguish normal from abnormal traffic and support tagging connections with: rule id, node id, and status id. From an intrusion detection standpoint, every connection is an event that must be validated through some means. Sancp uses rules to identify, record, and tag traffic of interest. http://secure.lv/~nikns/stuff/ports/sancp-1.6.1.tar feedback and corrections appricated.
NEW: devel/itcl
COMMENT=object-oriented extensions to Tcl [incr Tcl] is an object-oriented extension of the Tcl language. It was created to support more structured programming in Tcl. Tcl scripts that grow beyond a few thousand lines become extremely difficult to maintain. This is because the building blocks of vanilla Tcl are procedures and global variables, and all of these building blocks must reside in a single global namespace. There is no support for protection or encapsulation. http://secure.lv/~nikns/stuff/ports/itcl-3.3.tar feedback and corrections appricated.
NEW: devel/tcltls
COMMENT=OpenSSL Tcl Extension TLS is an OpenSSL / RSA-bsafe Tcl extension that provides secure connections on top of the Tcl socket mechanism. Within a few lines of code, users can query https servers. http://secure.lv/~nikns/stuff/ports/tcltls-1.5.0.tar feedback and corrections appricated.
NEW: devel/iwidgets
COMMENT=Iwidgets Mega Widget Set [incr Widgets] it is an object-oriented mega-widget set which extends Tcl/Tk and is based on [incr Tcl] and [incr Tk]. This set of mega-widgets delivers many new, general purpose widgets like option menus, comboboxes, selection boxes, and various dialogs whose couterparts are found in Motif and Windows. Since [incr Widgets] is based on the [incr Tk] extension, the Tk framework of configuration options, widget commands, and default bindings is maintained. In other words, each [incr Widgets] mega-widget seamlessly blends with the standard Tk widgets. They look, act and feel like Tk widgets. In addition, all [incr Widgets] mega-widgets are object oriented and may themselves be extended, using either inheritance or composition. http://secure.lv/~nikns/stuff/ports/iwidgets-4.0.1.tar feedback and corrections appricated.
NEW: security/sguil
COMMENT=Sguil NSM security monitoring client COMMENT=Sguil NSM security monitoring sensor COMMENT=Sguil NSM security monitoring server Sguil - A tcl/tk interface for network security monitoring Sguil (pronounced sgweel) is a graphical interface to snort (www.snort.org), an open source intrusion detection system. The actual interface and GUI server are written in tcl/tk (www.tcl.tk). Sguil also relies on other open source software in order to function properly. http://secure.lv/~nikns/stuff/ports/sguil-0.6.1.tar feedback and corrections appricated. Quick test: ## ### install ### ## cd /usr/ports/devel ftp -V http://secure.lv/~nikns/stuff/ports/itcl-3.3.tar ftp -V http://secure.lv/~nikns/stuff/ports/itk-3.3.tar ftp -V http://secure.lv/~nikns/stuff/ports/iwidgets-4.0.1.tar ftp -V http://secure.lv/~nikns/stuff/ports/mysqltcl-3.02.tar ftp -V http://secure.lv/~nikns/stuff/ports/tcltls-1.5.0.tar ftp -V http://secure.lv/~nikns/stuff/ports/tclx-8.4.tar tar xvf itcl-3.3.tar tar xvf itk-3.3.tar tar xvf iwidgets-4.0.1.tar tar xvf mysqltcl-3.02.tar tar xvf tcltls-1.5.0.tar tar xvf tclx-8.4.tar cd /usr/ports/net ftp -V http://secure.lv/~nikns/stuff/ports/barnyard-0.2.0.tar ftp -V http://secure.lv/~nikns/stuff/ports/sancp-1.6.1.tar tar xvf barnyard-0.2.0.tar tar xvf sancp-1.6.1.tar cd /usr/ports/security ftp -V http://secure.lv/~nikns/stuff/ports/sguil-0.6.1.tar tar xvf sguil-0.6.1.tar cd sguil make install cd /usr/ports/net/snort make install cd /usr/ports/databases/mysql env SUBPACKAGE=-server make install ## ### configure ### ## mkdir -p /sguild_data/rules/gateway mkdir -p /snort_data/gateway/sancp cd /tmp ftp -V http://www.snort.org/pub-bin/downloads.cgi/Download/vrt_pr/snortrules-pr-2.4.tar.gz tar zxvf snortrules-pr-2.4.tar.gz rules mv rules/* /sguild_data/rules/gateway/ # add user with password sguild -adduser username #in /etc/snort/snort.conf check for following lines: var RULE_PATH /sguild_data/rules/gateway output log_unified: filename snort.log, limit 128 preprocessor perfmonitor: time 300 file /snort_data/gateway/snort.stats pktcnt 1 #in /etc/barnyard.conf check for following lines: config interface: interface output sguil #in /usr/local/bin/log_packets.sh check for following config: INTERFACE=interface OPTIONS=-m 122 ## ### startup ### ## # start everything in seperate screen for debugging and check # if everything starts fine screen sh mysqld_safe [detach] log_packets.sh start screen sh snort -l /snort_data/gateway -c /etc/snort/snort.conf -U -A none -m 122 -i interface [detach] screen sh sancp -d /snort_data/gateway/sancp/ -i interface -c /etc/sancp_sguil.conf [detach] screen sh sguild # for first time you will have to hit 'y': # pid(10278) Loading access list: /etc/sguild/sguild.access # pid(10278) Adding sensor to access list: 127.0.0.1 # pid(10278) Adding client to access list: 127.0.0.1 # pid(10278) Email Configuration: # pid(10278)Config file: /etc/sguild/sguild.email # pid(10278)Enabled: No # pid(10278) Connecting to localhost on 3306 as root # pid(10278) MySQL Version: version 5.0.22-log # pid(10278) Error: mysqluse/db server: Unknown database 'sguildb' # The database sguildb does not exist. Create it ([y]/n)?: y [detach] screen sh sensor_agent.tcl [detach] screen sh barnyard -c /etc/barnyard.conf -d /snort_data/gateway \ -g /etc/snort/gen-msg.map -p /etc/snort/classification.config \ -s /etc/snort/sid-msg.map -f snort.log -w /etc/snort/waldo.file [detach]
building tentakel on openbsd_4_0 fails (patch.4.2.52.1 is not available)
Hello, I'm trying to build tentakel (tentakel-2.1.2p0) on openbsd_4_0. Unfortunately the build fails because it can't download the following file: patch.4.2.52.1.tar.gz (or patch.4.2.52.1.tgz, I don't know) I tried to search this file via google but I was not able to locate it. Does anyone know where I can manually download this file, so that I'm able to build tentakel? Many thanks Didier
FIX for graphics/fxtv
Hi. I'm resposting this fix since I never got any feedback from the maintainer. - use RAW format for the intermediate audio file (fixes a no sound issue) - add graphics/netpbm to RUN_DEPENDS (pretty much useless otherwise) Looks ok? -- AntoineIndex: fxtv//Makefile === RCS file: /cvs/ports/graphics/fxtv/Makefile,v retrieving revision 1.33 diff -u -r1.33 Makefile --- fxtv//Makefile 2 Aug 2006 10:10:35 - 1.33 +++ fxtv//Makefile 18 Oct 2006 10:47:28 - @@ -4,7 +4,7 @@ COMMENT= Display and capture for Brooktree-based cards DISTNAME= fxtv-1.03 -PKGNAME= ${DISTNAME}p0 +PKGNAME= ${DISTNAME}p1 CATEGORIES=graphics HOMEPAGE= http://people.freebsd.org/~rhh/fxtv/ @@ -21,7 +21,8 @@ :mpg321-*:audio/mpg321 \ :mp3encode-*:audio/mp3encode \ :mpeg_encode-=1.5:graphics/mpeg_encode \ - :mplex-=1.1:graphics/mplex + :mplex-=1.1:graphics/mplex \ + :netpbm-*:graphics/netpbm MAINTAINER=Wilbern Cobb [EMAIL PROTECTED] Index: fxtv//patches/patch-fxtv_cnvt_sh === RCS file: /cvs/ports/graphics/fxtv/patches/patch-fxtv_cnvt_sh,v retrieving revision 1.3 diff -u -r1.3 patch-fxtv_cnvt_sh --- fxtv//patches/patch-fxtv_cnvt_sh3 Jan 2004 14:23:24 - 1.3 +++ fxtv//patches/patch-fxtv_cnvt_sh18 Oct 2006 10:47:28 - @@ -1,6 +1,6 @@ $OpenBSD: patch-fxtv_cnvt_sh,v 1.3 2004/01/03 14:23:24 espie Exp $ fxtv_cnvt.sh.orig Mon Feb 12 17:18:40 2001 -+++ fxtv_cnvt.sh Wed Aug 15 13:47:57 2001 +--- fxtv_cnvt.sh.orig Mon Feb 12 22:18:40 2001 fxtv_cnvt.sh Wed Oct 18 12:38:30 2006 @@ -40,12 +40,12 @@ # Default to $PATH @@ -79,6 +79,17 @@ MPEG_ENC_PARAM_STR_INP_STDIN=\ 'INPUT_DIR stdin' +@@ -181,8 +181,8 @@ GenAudioPipe() { + +# Do we need an intermediate file? +if [ $mpeg_enc = YES ]; then +- out_soxfn=$out_fnbase.aiff +- out_soxfmt=AIFF ++ out_soxfn=$out_fnbase.raw ++ out_soxfmt=RAW +else + out_soxfn=$GAout_fn + out_soxfmt=$out_fmt @@ -344,12 +344,8 @@ vars='$AV_RAW_FILES $AV_TARGET $TARGET_F set -- $vars missing_var=NO
Re: building tentakel on openbsd_4_0 fails (patch.4.2.52.1 is not available)
On Wed, Oct 18, 2006 at 12:39:32PM +0200, Didier Wiroth wrote: Hello, I'm trying to build tentakel (tentakel-2.1.2p0) on openbsd_4_0. Unfortunately the build fails because it can't download the following file: patch.4.2.52.1.tar.gz (or patch.4.2.52.1.tgz, I don't know) These patches don't have a tgz extension. make fetch in databases/db/v4 should get them from ftp://ftp.openbsd.org/pub/OpenBSD/distfiles/ I tried to search this file via google but I was not able to locate it. Does anyone know where I can manually download this file, so that I'm able to build tentakel? Many thanks Didier Tobias
Re: building tentakel on openbsd_4_0 fails (patch.4.2.52.1 is not available)
Didier Wiroth [2006-10-18, 12:39:32]: Hello, I'm trying to build tentakel (tentakel-2.1.2p0) on openbsd_4_0. Unfortunately the build fails because it can't download the following file: patch.4.2.52.1.tar.gz (or patch.4.2.52.1.tgz, I don't know) I tried to search this file via google but I was not able to locate it. Does anyone know where I can manually download this file, so that I'm able to build tentakel? they should be on ftp.openbsd.org. master site moved to oracle.com, fixed in -current. Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm
databases/postgresql, changes to the -server subpackage
I am changing slightly the way we install a PostgreSQL server. To recall, up to now installing the postgresql-server package created a default database for you. But this database was not secured. This has led to problems in some installations where the users were not aware of this. So no database is created during package install, instead instructions are given on how to create a properly secured database. ok? Index: databases/postgresql/Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.91 diff -u -r1.91 Makefile --- databases/postgresql/Makefile 15 Oct 2006 16:00:11 - 1.91 +++ databases/postgresql/Makefile 18 Oct 2006 11:12:19 - @@ -7,7 +7,7 @@ VERSION= 8.1.5 DISTNAME= postgresql-${VERSION} FULLPKGNAME= postgresql-client-${VERSION} -PKGNAME-server=postgresql-server-${VERSION} +PKGNAME-server=postgresql-server-${VERSION}p0 PKGNAME-docs= postgresql-docs-${VERSION} CATEGORIES=databases Index: databases/postgresql/files/README.OpenBSD === RCS file: /cvs/ports/databases/postgresql/files/README.OpenBSD,v retrieving revision 1.14 diff -u -r1.14 README.OpenBSD --- databases/postgresql/files/README.OpenBSD 15 Oct 2006 16:00:11 - 1.14 +++ databases/postgresql/files/README.OpenBSD 18 Oct 2006 11:12:19 - @@ -1,56 +1,40 @@ -Requirements - - -Please note that the OpenBSD port of the PostgreSQL server requires a -kernel compiled with SYSVSEM and SYSVSHM options for proper operation. -The GENERIC kernel has these settings. - Using PostgreSQL in an OpenBSD environment --- -If you are installing PostgreSQL for the first time, a default database -will have been created for you. If this failed for any reason or if you -want to use non-default paramaters, you can do something similar to the -following steps manually: +If you are installing PostgreSQL for the first time, you have to create +a default database first. In the following example we install a database +in /var/postgresql/data with a dba account 'postgres' and md5 authentication. +We will be prompted for a password to protect the dba account: # su - _postgresql $ mkdir /var/postgresql/data - $ initdb -D /var/postgresql/data - -If you are upgrading PostgreSQL then you may have a `pgsql' or `postgresql' -user. It is suggested that you follow the steps in + $ initdb -D /var/postgresql/data -U postgres -A md5 -W - !!PREFIX!!/share/doc/postgresql/INSTALL - -for more information on how to upgrade your existing databases. See -also `Special notes for the OpenBSD port' below. Replace references to -the `postgresql' user below with `pgsql' or whatever other user you -have selected to be the database administration account. +Please consult the PostgreSQL website for more information, especially when +you are upgrading an existing database installation. Auto Start and Stop -If you wish to start PostgreSQL automatically during system startup, -add the following lines to /etc/rc.local: +To start PostgreSQL at boot and shut it down when the system shuts down, +add the following lines to /etc/rc.local and /etc/rc.shutdown, respectively: + +/etc/rc.local: if [ -x !!PREFIX!!/bin/pg_ctl ]; then su -l _postgresql -c nohup !!PREFIX!!/bin/pg_ctl start \ - -D /var/postgresql/data -l /var/postgresql/logfile \ - -o '-D /var/postgresql/data' + -D /var/postgresql/data -l /var/postgresql/logfile \ + -o '-D /var/postgresql/data' echo -n ' postgresql' fi -To automatically shutdown the database as part of the system shutdown, -add the following lines to /etc/rc.shutdown: +/etc/rc.shutdown: if [ -f /var/postgresql/data/postmaster.pid ]; then su -l _postgresql -c !!PREFIX!!/bin/pg_ctl stop -m fast \ - -D /var/postgresql/data +-D /var/postgresql/data rm -f /var/postgresql/data/postmaster.pid fi Network Connections and Tuning --- To allow connections over TCP (and other options) edit the file: Index: databases/postgresql/pkg/MESSAGE-server === RCS file: /cvs/ports/databases/postgresql/pkg/MESSAGE-server,v retrieving revision 1.3 diff -u -r1.3 MESSAGE-server --- databases/postgresql/pkg/MESSAGE-server 5 Feb 2006 09:23:22 - 1.3 +++ databases/postgresql/pkg/MESSAGE-server 18 Oct 2006 11:12:19 - @@ -1,2 +1,7 @@ -For more information on using PostgreSQL in an OpenBSD environment, -please see ${PREFIX}/share/doc/postgresql/README.OpenBSD. +* Important note for users familar with former versions of this package: + The postgresql-server package does no longer install a default database. + +To use the
Re: FIX for graphics/fxtv
Antoine Jacoutot wrote: Hi. I'm resposting this fix since I never got any feedback from the maintainer. - use RAW format for the intermediate audio file (fixes a no sound issue) - add graphics/netpbm to RUN_DEPENDS (pretty much useless otherwise) Looks ok? COOL ... That sounds really good. I've recently installed a Leadtek Winfast TV 2000 but I had no luck getting sound ... image was good, but no sound. I tried every imaginable mixerctl combinations but no sound. I'll try this tonight! Didier
Re: FIX for graphics/fxtv
On Wed, 18 Oct 2006, Didier Wiroth wrote: COOL ... That sounds really good. I've recently installed a Leadtek Winfast TV 2000 but I had no luck getting sound ... image was good, but no sound. I tried every imaginable mixerctl combinations but no sound. I'll try this tonight! Cool, let me know. Cheers! -- Antoine
NEW: mod_bandwidth-2.0.6
pkg/DESCR Mod_bandwidth is a module for the Apache webserver that enables the setting of server-wide or per connection bandwidth limits, based on the directory, size of files and remote IP/domain. This is a repost with some typos corrections. Tested without problem under macppc. -- Antoine mod_bandwidth.tar.gz Description: Binary data
Re: NEW: security/sguil
I've been running nikns' sguil related ports (iwidgets, tclx, tcltls, mysqltcl, sancp, itcl, sguil/server, sguil/sensor, sguil/client, itk) for a few weeks and they've been working well. I've run most of them on i386, macppc, and amd64. On 10/18/06, nikns [EMAIL PROTECTED] wrote: COMMENT=Sguil NSM security monitoring client COMMENT=Sguil NSM security monitoring sensor COMMENT=Sguil NSM security monitoring server Sguil - A tcl/tk interface for network security monitoring Sguil (pronounced sgweel) is a graphical interface to snort (www.snort.org), an open source intrusion detection system. The actual interface and GUI server are written in tcl/tk (www.tcl.tk). Sguil also relies on other open source software in order to function properly. http://secure.lv/~nikns/stuff/ports/sguil-0.6.1.tar feedback and corrections appricated. Quick test: ## ### install ### ## cd /usr/ports/devel ftp -V http://secure.lv/~nikns/stuff/ports/itcl-3.3.tar ftp -V http://secure.lv/~nikns/stuff/ports/itk-3.3.tar ftp -V http://secure.lv/~nikns/stuff/ports/iwidgets-4.0.1.tar ftp -V http://secure.lv/~nikns/stuff/ports/mysqltcl-3.02.tar ftp -V http://secure.lv/~nikns/stuff/ports/tcltls-1.5.0.tar ftp -V http://secure.lv/~nikns/stuff/ports/tclx-8.4.tar tar xvf itcl-3.3.tar tar xvf itk-3.3.tar tar xvf iwidgets-4.0.1.tar tar xvf mysqltcl-3.02.tar tar xvf tcltls-1.5.0.tar tar xvf tclx-8.4.tar cd /usr/ports/net ftp -V http://secure.lv/~nikns/stuff/ports/barnyard-0.2.0.tar ftp -V http://secure.lv/~nikns/stuff/ports/sancp-1.6.1.tar tar xvf barnyard-0.2.0.tar tar xvf sancp-1.6.1.tar cd /usr/ports/security ftp -V http://secure.lv/~nikns/stuff/ports/sguil-0.6.1.tar tar xvf sguil-0.6.1.tar cd sguil make install cd /usr/ports/net/snort make install cd /usr/ports/databases/mysql env SUBPACKAGE=-server make install ## ### configure ### ## mkdir -p /sguild_data/rules/gateway mkdir -p /snort_data/gateway/sancp cd /tmp ftp -V http://www.snort.org/pub-bin/downloads.cgi/Download/vrt_pr/snortrules-pr-2.4.tar.gz tar zxvf snortrules-pr-2.4.tar.gz rules mv rules/* /sguild_data/rules/gateway/ # add user with password sguild -adduser username #in /etc/snort/snort.conf check for following lines: var RULE_PATH /sguild_data/rules/gateway output log_unified: filename snort.log, limit 128 preprocessor perfmonitor: time 300 file /snort_data/gateway/snort.stats pktcnt 1 #in /etc/barnyard.conf check for following lines: config interface: interface output sguil #in /usr/local/bin/log_packets.sh check for following config: INTERFACE=interface OPTIONS=-m 122 ## ### startup ### ## # start everything in seperate screen for debugging and check # if everything starts fine screen sh mysqld_safe [detach] log_packets.sh start screen sh snort -l /snort_data/gateway -c /etc/snort/snort.conf -U -A none -m 122 -i interface [detach] screen sh sancp -d /snort_data/gateway/sancp/ -i interface -c /etc/sancp_sguil.conf [detach] screen sh sguild # for first time you will have to hit 'y': # pid(10278) Loading access list: /etc/sguild/sguild.access # pid(10278) Adding sensor to access list: 127.0.0.1 # pid(10278) Adding client to access list: 127.0.0.1 # pid(10278) Email Configuration: # pid(10278)Config file: /etc/sguild/sguild.email # pid(10278)Enabled: No # pid(10278) Connecting to localhost on 3306 as root # pid(10278) MySQL Version: version 5.0.22-log # pid(10278) Error: mysqluse/db server: Unknown database 'sguildb' # The database sguildb does not exist. Create it ([y]/n)?: y [detach] screen sh sensor_agent.tcl [detach] screen sh barnyard -c /etc/barnyard.conf -d /snort_data/gateway \ -g /etc/snort/gen-msg.map -p /etc/snort/classification.config \ -s /etc/snort/sid-msg.map -f snort.log -w /etc/snort/waldo.file [detach]
Re: databases/postgresql, changes to the -server subpackage
I am changing slightly the way we install a PostgreSQL server. To recall, up to now installing the postgresql-server package created a default database for you. But this database was not secured. This has led to problems in some installations where the users were not aware of this. Sounds good to me. So no database is created during package install, instead instructions are given on how to create a properly secured database. ok? Index: databases/postgresql/Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.91 diff -u -r1.91 Makefile --- databases/postgresql/Makefile 15 Oct 2006 16:00:11 - 1.91 +++ databases/postgresql/Makefile 18 Oct 2006 11:12:19 - @@ -7,7 +7,7 @@ VERSION= 8.1.5 DISTNAME=postgresql-${VERSION} FULLPKGNAME= postgresql-client-${VERSION} -PKGNAME-server= postgresql-server-${VERSION} +PKGNAME-server= postgresql-server-${VERSION}p0 PKGNAME-docs=postgresql-docs-${VERSION} CATEGORIES= databases Index: databases/postgresql/files/README.OpenBSD === RCS file: /cvs/ports/databases/postgresql/files/README.OpenBSD,v retrieving revision 1.14 diff -u -r1.14 README.OpenBSD --- databases/postgresql/files/README.OpenBSD 15 Oct 2006 16:00:11 - 1.14 +++ databases/postgresql/files/README.OpenBSD 18 Oct 2006 11:12:19 - @@ -1,56 +1,40 @@ -Requirements - - -Please note that the OpenBSD port of the PostgreSQL server requires a -kernel compiled with SYSVSEM and SYSVSHM options for proper operation. -The GENERIC kernel has these settings. - Using PostgreSQL in an OpenBSD environment --- -If you are installing PostgreSQL for the first time, a default database -will have been created for you. If this failed for any reason or if you -want to use non-default paramaters, you can do something similar to the -following steps manually: +If you are installing PostgreSQL for the first time, you have to create +a default database first. In the following example we install a database +in /var/postgresql/data with a dba account 'postgres' and md5 authentication. +We will be prompted for a password to protect the dba account: # su - _postgresql $ mkdir /var/postgresql/data - $ initdb -D /var/postgresql/data - -If you are upgrading PostgreSQL then you may have a `pgsql' or `postgresql' -user. It is suggested that you follow the steps in + $ initdb -D /var/postgresql/data -U postgres -A md5 -W - !!PREFIX!!/share/doc/postgresql/INSTALL - -for more information on how to upgrade your existing databases. See -also `Special notes for the OpenBSD port' below. Replace references to -the `postgresql' user below with `pgsql' or whatever other user you -have selected to be the database administration account. +Please consult the PostgreSQL website for more information, especially when +you are upgrading an existing database installation. Auto Start and Stop -If you wish to start PostgreSQL automatically during system startup, -add the following lines to /etc/rc.local: +To start PostgreSQL at boot and shut it down when the system shuts down, +add the following lines to /etc/rc.local and /etc/rc.shutdown, respectively: + +/etc/rc.local: if [ -x !!PREFIX!!/bin/pg_ctl ]; then su -l _postgresql -c nohup !!PREFIX!!/bin/pg_ctl start \ - -D /var/postgresql/data -l /var/postgresql/logfile \ - -o '-D /var/postgresql/data' + -D /var/postgresql/data -l /var/postgresql/logfile \ + -o '-D /var/postgresql/data' echo -n ' postgresql' fi -To automatically shutdown the database as part of the system shutdown, -add the following lines to /etc/rc.shutdown: +/etc/rc.shutdown: if [ -f /var/postgresql/data/postmaster.pid ]; then su -l _postgresql -c !!PREFIX!!/bin/pg_ctl stop -m fast \ - -D /var/postgresql/data + -D /var/postgresql/data rm -f /var/postgresql/data/postmaster.pid fi Network Connections and Tuning --- To allow connections over TCP (and other options) edit the file: Index: databases/postgresql/pkg/MESSAGE-server === RCS file: /cvs/ports/databases/postgresql/pkg/MESSAGE-server,v retrieving revision 1.3 diff -u -r1.3 MESSAGE-server --- databases/postgresql/pkg/MESSAGE-server 5 Feb 2006 09:23:22 - 1.3 +++ databases/postgresql/pkg/MESSAGE-server 18 Oct 2006 11:12:19 - @@ -1,2 +1,7 @@ -For more information on using PostgreSQL in an OpenBSD environment, -please see ${PREFIX}/share/doc/postgresql/README.OpenBSD. +* Important note for users familar with former versions of this
Re: databases/postgresql, changes to the -server subpackage
Marc Balmer [Wed, Oct 18, 2006 at 01:26:32PM +0200] wrote: I am changing slightly the way we install a PostgreSQL server. To recall, up to now installing the postgresql-server package created a default database for you. But this database was not secured. This has led to problems in some installations where the users were not aware of this. So no database is created during package install, instead instructions are given on how to create a properly secured database. If this goes it we should probably do the same for mysql. I like it. Bernd
Re: NEW: mod_bandwidth-2.0.6
On Wed, 18 Oct 2006, Antoine Jacoutot wrote: pkg/DESCR Mod_bandwidth is a module for the Apache webserver that enables the setting of server-wide or per connection bandwidth limits, based on the directory, size of files and remote IP/domain. Set SHARED_ONLY and add an @unexec line so that the actual module gets removed when deinstalling... thanks alek@ -- Antoine mod_bandwidth.tar.gz Description: Binary data
Re: NEW: databases/pgadmin
On Tue, Oct 17, 2006 at 02:11:37PM +0200, Marc Balmer wrote: * Alexandre Anriot wrote: Here is a port of pgadmin III, an administration and development platform for PostgreSQL (administration commands, SQL, etc.) http://www.atlantilde.com/~aanriot/ports/pgadmin.tar.gz This port was started at c2k6 but has needed up-to-date wxWidgets stuff to work (UTF-8 support), and has been tested on i386 and macppc. Why don't you use pgadmin3 as the PKGNAME? And, you have long lines in the Makefile (LIB_DEPENDS) other than that: tesing it now. btw, bernd has a similar port, maybe you should merge them? For the record, we have discussed by mail and pgadmin3 is in now.
nmap porting question
so i'm reviewing the recent alpha releases of nmap and i've run into a small snag; configure is now checking for libpcap = 0.9.4. if the version is lower, then it begins to build its own rolled version of libpcap. nmap seems to want this now. i'd much rather prefer that nmap uses base's libpcap(3), and its been nice removing the local patches for nmap in the port. i could obviously maintain a patch to configure and whatever else, but another question arises: how come base's libpcap(3) hasn't been bumped? i've gone through -current's libpcap(3) and most everything was pulled in from tcpdump.org's pcap library/api, for 4.0 at least. maybe this is not the right place to ask, but what about a bump in src/lib/libpcap/VERSION? or does anybody not care if we use nmap's rolled libpcap+patches (from tcpdump.org). or should i just patch away again. advice? cheers, okan
Re: UPDATE: www/tidy
On Tue, Oct 17, 2006 at 02:50:07PM +0300, nikns wrote: This diff updates www/tidy port + adds building of shared library which is usefull when, for example, compiling php with tidy support. Tested on i386 and alpha. I can confirm this works for me. I had a local patch that added this library, but it wasn't this complete, so I've switched to your patch. I use it for a local p5-HTML-Tidy port that I'd be happy to submit if your patch is accepted (or if someone just wants it). -Dan -- Burnished gallows set with red Caress the fevered, empty mind Of man who hangs bloodied and blind To reach for wisdom, not for bread. -- Deoridhe Grimsdaughter
NEW: xsane-0.991
pkg/DESCR XSane is a graphical scanning frontend. It uses the SANE-library to talk to scanners. This means that XSane does not support any scanners itself. Here you can find out which scanners are supported by the SANE-library. XSane is designed for acquiring images with scanners (there are other devices like cameras and videodevices supported by SANE, but XSane is not designed for that purpose). You can scan to file, do a photocopy, create a fax, create and send a mail and start XSane from the GIMP as gimp plug in. Available flavors: gimp - Build the gimp xsane plugin I have been using this without any issue for about a month now (macppc/current). This is a very nice frontend for scanning. -- Antoine xsane.tar.gz Description: Binary data
Re: FIX for graphics/fxtv
On Wed, 18 Oct 2006, Didier Wiroth wrote: Cool, let me know. Sh*t !!!;-( Still no sound for me. No sound where? While watching the video/audio output? If so, my fix was just meant to correct sound on the recorded material... but of course, audio output is supposed to work first ;) -- Antoine
Re: UPDATE: www/tidy
This diff updates www/tidy port + adds building of shared library which is usefull when, for example, compiling php with tidy support. .. Index: tidy/pkg/PFRAG.shared === RCS file: tidy/pkg/PFRAG.shared diff -N tidy/pkg/PFRAG.shared --- /dev/null 1 Jan 1970 00:00:00 - +++ tidy/pkg/PFRAG.shared 28 Aug 2006 14:02:18 - @@ -0,0 +1,2 @@ [EMAIL PROTECTED] $OpenBSD$ [EMAIL PROTECTED] lib/libtidy-0.99.so.${LIBtidy-0.99_VERSION} this is wrong, in OpenBSD, the libs are named libFOO.so.VERSION, not libFOO-version
Re: FIX for graphics/fxtv
Cool, let me know. Sh*t !!!;-( Still no sound for me. Didier
Re: UPDATE: www/tidy
On Wed, Oct 18, 2006 at 10:23:08AM -0600, Peter Valchev wrote: This diff updates www/tidy port + adds building of shared library which is usefull when, for example, compiling php with tidy support. .. Index: tidy/pkg/PFRAG.shared === RCS file: tidy/pkg/PFRAG.shared diff -N tidy/pkg/PFRAG.shared --- /dev/null 1 Jan 1970 00:00:00 - +++ tidy/pkg/PFRAG.shared 28 Aug 2006 14:02:18 - @@ -0,0 +1,2 @@ [EMAIL PROTECTED] $OpenBSD$ [EMAIL PROTECTED] lib/libtidy-0.99.so.${LIBtidy-0.99_VERSION} this is wrong, in OpenBSD, the libs are named libFOO.so.VERSION, not libFOO-version The below patch should correct that. Thanks. -Dan Index: tidy//Makefile === RCS file: /cvs/ports/www/tidy/Makefile,v retrieving revision 1.19 diff -u -r1.19 Makefile --- tidy//Makefile 2005/10/05 09:39:20 1.19 +++ tidy//Makefile 2006/10/18 17:00:38 @@ -2,9 +2,10 @@ COMMENT= validate, correct, and pretty-print HTML files -TIDYDATE= 050921 +TIDYDATE= 051026 DISTNAME= tidy_src_${TIDYDATE} PKGNAME= tidy-${TIDYDATE} +SHARED_LIBS= tidy 1.0 CATEGORIES= www @@ -23,8 +24,8 @@ MASTER_SITES1= ${HOMEPAGE}test/ EXTRACT_SUFX= .tgz DISTFILES= ${DISTNAME}${EXTRACT_SUFX} \ - tidy_docs_050705${EXTRACT_SUFX}:0 \ - tidy_test_050919${EXTRACT_SUFX}:1 + tidy_docs_051020${EXTRACT_SUFX}:0 \ + tidy_test_051026${EXTRACT_SUFX}:1 USE_GMAKE= Yes @@ -34,6 +35,9 @@ WRKBUILD= ${WRKDIST}/build/gmake DOCDIR=${PREFIX}/share/doc/tidy + +MAKE_FLAGS=TIDY_MAJOR=${LIBtidy_VERSION:R} TIDY_MINOR=${LIBtidy_VERSION:E} +FAKE_FLAGS=TIDY_MAJOR=${LIBtidy_VERSION:R} TIDY_MINOR=${LIBtidy_VERSION:E} post-install: ${INSTALL_DATA_DIR} ${DOCDIR} Index: tidy//distinfo === RCS file: /cvs/ports/www/tidy/distinfo,v retrieving revision 1.7 diff -u -r1.7 distinfo --- tidy//distinfo 2005/10/05 09:39:20 1.7 +++ tidy//distinfo 2006/10/18 17:00:38 @@ -1,12 +1,12 @@ -MD5 (tidy_docs_050705.tgz) = 2e6533fc48b077ff6243deaf21a781de -MD5 (tidy_src_050921.tgz) = 82c76c061abfdf5f67d02951b4dd2a02 -MD5 (tidy_test_050919.tgz) = c9ca834e381537039e516da549662651 -RMD160 (tidy_docs_050705.tgz) = 49b8c2eaf87a0291b1bef6479cf1eeda6b720f52 -RMD160 (tidy_src_050921.tgz) = 958f532245412e3f8ac5bdd56edc5693cadf4b5b -RMD160 (tidy_test_050919.tgz) = 337ca275ca6af513b1bf2a5bd4b10a2a244e90fe -SHA1 (tidy_docs_050705.tgz) = b243d7910ce2fe57a8df27ff8f775e6d397c732d -SHA1 (tidy_src_050921.tgz) = 4a53aa129e2575004dcbaf0cf4c5c3f1637723b0 -SHA1 (tidy_test_050919.tgz) = d214f85d581ceeeb4ec58d24d8d7494e10e62125 -SIZE (tidy_docs_050705.tgz) = 150359 -SIZE (tidy_src_050921.tgz) = 256079 -SIZE (tidy_test_050919.tgz) = 106674 +MD5 (tidy_docs_051020.tgz) = 86de2f198e57399c063d2567b2a25628 +MD5 (tidy_src_051026.tgz) = 1e39fafd6808978871346658c8da1454 +MD5 (tidy_test_051026.tgz) = 4b35b2e0495ad2fc1bc391f779c9541d +RMD160 (tidy_docs_051020.tgz) = 63f033560af9a53393d9a3f656f26bb12bf505b6 +RMD160 (tidy_src_051026.tgz) = 0cae41f8c0cec51d4600d1bf2aac338cf60aa6b9 +RMD160 (tidy_test_051026.tgz) = 1caaf13ce9d484d8321b8b370782966066ea3a6f +SHA1 (tidy_docs_051020.tgz) = 04988d51267566db6899e8061d9f2e5b58fbeec4 +SHA1 (tidy_src_051026.tgz) = 53be36945344af0c4080c34ebc95728bf8617f1c +SHA1 (tidy_test_051026.tgz) = a790c98bdabffb8c181796e7ef4007cfbeb1f370 +SIZE (tidy_docs_051020.tgz) = 150402 +SIZE (tidy_src_051026.tgz) = 256131 +SIZE (tidy_test_051026.tgz) = 107014 Index: tidy//patches/patch-build_gmake_Makefile === RCS file: /cvs/ports/www/tidy/patches/patch-build_gmake_Makefile,v retrieving revision 1.2 diff -u -r1.2 patch-build_gmake_Makefile --- tidy//patches/patch-build_gmake_Makefile2005/07/19 08:10:10 1.2 +++ tidy//patches/patch-build_gmake_Makefile2006/10/18 17:00:38 @@ -1,6 +1,5 @@ -$OpenBSD: patch-build_gmake_Makefile,v 1.2 2005/07/19 08:10:10 aanriot Exp $ build/gmake/Makefile.orig Tue May 3 08:58:08 2005 -+++ build/gmake/Makefile Tue Jul 12 12:03:54 2005 +--- build/gmake/Makefile.orig Fri Jul 15 02:57:48 2005 build/gmake/Makefile Wed Oct 18 12:47:59 2006 @@ -58,8 +58,8 @@ SHELL=/bin/sh PROJECT=tidy @@ -19,7 +18,7 @@ -CC= gcc -CFLAGS= -g -Wall -Wno-switch -Wno-parentheses -I $(INCDIR) +#CC= gcc -+CFLAGS+= -I $(INCDIR) ++CFLAGS+= -fPIC -I $(INCDIR) # flags only supported with gcc 3.x # CFLAGS += -Wunused-parameter @@ -29,17 +28,29 @@ # OTHERCFLAGS+= -DSUPPORT_ACCESSIBILITY_CHECKS=1 -DSUPPORT_UTF16_ENCODINGS=1 -DSUPPORT_ASIAN_ENCODINGS=1 ifdef SUPPORT_UTF16_ENCODINGS CFLAGS += -DSUPPORT_UTF16_ENCODINGS=$(SUPPORT_UTF16_ENCODINGS) -@@ -115,7 +115,7 @@ LIBSUFFIX = .a +@@ -112,10 +112,12 @@ TIDY_MINOR = 0 + # This
Re: FIX for graphics/fxtv
... but of course, audio output is supposed to work first ;) Yes, audio output does not work. I have a leatek winfast tv 2000 xp rm, tv tuner, with a cable pal connection. The tv tuner has an audio connector, it is connected to the motherboard via the cd connector. Result ... no sound. In case someone has an idea, here my dmesg + 'mixerctl -a': OpenBSD 4.0 (BROOKTREE_TV) #0: Tue Aug 29 20:16:51 CEST 2006 [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/BROOKTREE_TV cpu0: Intel(R) Pentium(R) 4 CPU 2.80GHz (GenuineIntel 686-class) 2.80 GHz cpu0: FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CF LUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,CNXT-ID real mem = 2146201600 (2095900K) avail mem = 1949696000 (1904000K) using 4256 buffers containing 107413504 bytes (104896K) of memory mainbus0 (root) bios0 at mainbus0: AT/286+(00) BIOS, date 06/20/05, BIOS32 rev. 0 @ 0xf0010, SMB IOS rev. 2.3 @ 0xf04b0 (60 entries) bios0: ASUSTeK Computer Inc. P4C800-E apm0 at bios0: Power Management spec V1.2 apm0: AC on, battery charge unknown apm0: flags 30102 dobusy 0 doidle 1 pcibios0 at bios0: rev 2.1 @ 0xf/0x1 pcibios0: PCI IRQ Routing Table rev 1.0 @ 0xf4df0/224 (12 entries) pcibios0: PCI Interrupt Router at 000:31:0 (Intel 82801EB/ER LPC rev 0x00) pcibios0: PCI bus #3 is the last bus bios0: ROM list: 0xc/0xd000 0xcd000/0x3400 cpu0 at mainbus0 pci0 at mainbus0 bus 0: configuration mode 1 (no bios) pchb0 at pci0 dev 0 function 0 Intel 82875P Host rev 0x02 ppb0 at pci0 dev 1 function 0 Intel 82875P AGP rev 0x02 pci1 at ppb0 bus 1 vga1 at pci1 dev 0 function 0 ATI Radeon 9200 SE Sec rev 0x01 wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation) wsdisplay0: screen 1-5 added (80x25, vt100 emulation) ppb1 at pci0 dev 3 function 0 Intel 82875P PCI-CSA rev 0x02 pci2 at ppb1 bus 2 em0 at pci2 dev 1 function 0 Intel PRO/1000CT (82547EI) rev 0x00: irq 5, address 00:11:d8:df:2a:0f uhci0 at pci0 dev 29 function 0 Intel 82801EB/ER USB rev 0x02: irq 10 usb0 at uhci0: USB revision 1.0 uhub0 at usb0 uhub0: Intel UHCI root hub, rev 1.00/1.00, addr 1 uhub0: 2 ports with 2 removable, self powered uhci1 at pci0 dev 29 function 1 Intel 82801EB/ER USB rev 0x02: irq 5 usb1 at uhci1: USB revision 1.0 uhub1 at usb1 uhub1: Intel UHCI root hub, rev 1.00/1.00, addr 1 uhub1: 2 ports with 2 removable, self powered uhci2 at pci0 dev 29 function 2 Intel 82801EB/ER USB rev 0x02: irq 5 usb2 at uhci2: USB revision 1.0 uhub2 at usb2 uhub2: Intel UHCI root hub, rev 1.00/1.00, addr 1 uhub2: 2 ports with 2 removable, self powered uhci3 at pci0 dev 29 function 3 Intel 82801EB/ER USB rev 0x02: irq 10 usb3 at uhci3: USB revision 1.0 uhub3 at usb3 uhub3: Intel UHCI root hub, rev 1.00/1.00, addr 1 uhub3: 2 ports with 2 removable, self powered ehci0 at pci0 dev 29 function 7 Intel 82801EB/ER USB2 rev 0x02: irq 11 ehci0: timed out waiting for BIOS usb4 at ehci0: USB revision 2.0 uhub4 at usb4 uhub4: Intel EHCI root hub, rev 2.00/1.00, addr 1 uhub4: 8 ports with 8 removable, self powered ppb2 at pci0 dev 30 function 0 Intel 82801BA AGP rev 0xc2 pci3 at ppb2 bus 3 VIA VT6306 FireWire rev 0x80 at pci3 dev 3 function 0 not configured pciide0 at pci3 dev 4 function 0 Promise PDC20378 rev 0x02: DMA wd0 at pciide0 channel 0 drive 0: SAMSUNG SP1614C wd0: 16-sector PIO, LBA48, 152627MB, 312581808 sectors wd0(pciide0:0:0): using BIOS timings, Ultra-DMA mode 7 pciide0: using irq 11 for native-PCI interrupt bktr0 at pci3 dev 10 function 0 Brooktree BT878 rev 0x11: irq 11 bktr0: Leadtek Winfast TV 2000, Philips PAL tuner. Brooktree BT878 Audio rev 0x11 at pci3 dev 10 function 1 not configured ichpcib0 at pci0 dev 31 function 0 Intel 82801EB/ER LPC rev 0x02 pciide1 at pci0 dev 31 function 2 Intel 82801EB SATA rev 0x02: DMA, channel 0 configured to compatibility, channel 1 configured to compatibility wd1 at pciide1 channel 1 drive 0: SAMSUNG SP1614C wd1: 16-sector PIO, LBA48, 152627MB, 312581808 sectors wd2 at pciide1 channel 1 drive 1: SAMSUNG SP1614C wd2: 16-sector PIO, LBA48, 152627MB, 312581808 sectors wd1(pciide1:1:0): using PIO mode 4, Ultra-DMA mode 5 wd2(pciide1:1:1): using PIO mode 4, Ultra-DMA mode 5 ichiic0 at pci0 dev 31 function 3 Intel 82801EB/ER SMBus rev 0x02: irq 11 iic0 at ichiic0 lm1 at iic0 addr 0x2f: W83791SD auich0 at pci0 dev 31 function 5 Intel 82801EB/ER AC97 rev 0x02: irq 11, ICH5 AC97 ac97: codec id 0x41445375 (Analog Devices AD1985) ac97: codec features headphone, 20 bit DAC, No 3D Stereo audio0 at auich0 isa0 at ichpcib0 isadma0 at isa0 pckbc0 at isa0 port 0x60/5 pckbd0 at pckbc0 (kbd slot) pckbc0: using irq 1 for kbd slot wskbd0 at pckbd0: console keyboard, using wsdisplay0 pcppi0 at isa0 port 0x61 midi0 at pcppi0: PC speaker spkr0 at pcppi0 lpt0 at isa0 port 0x378/4 irq 7 lm0 at isa0 port 0x290/8: W83627THF npx0 at isa0 port 0xf0/16: using exception 16 pccom0 at isa0 port 0x3f8/8 irq 4: ns16550a, 16 byte fifo pccom1 at isa0 port 0x2f8/8 irq 3: ns16550a, 16 byte fifo fdc0 at isa0 port 0x3f0/6 irq 6
Re: FIX for graphics/fxtv
On Wed, 18 Oct 2006, Didier Wiroth wrote: ... but of course, audio output is supposed to work first ;) Yes, audio output does not work. I mean audio output from your video card. Watch out for the record.source and unmute everything just to be sure. Also you could try another connector. Anyway, this does not look related to this particular port, it seems like a configuration problem or something. -- Antoine
Re: UPDATE: www/tidy
this is wrong, in OpenBSD, the libs are named libFOO.so.VERSION, not libFOO-version The below patch should correct that. Did you test it? It seems not: ../../bin/tidy -xml-help ../../htmldoc/tidy-help.xml ../../bin/tidy: can't load library 'libtidy.so.1.0' gmake: *** [../../htmldoc/tidy-help.xml] Error 4 *** Error code 2 I was just looking at that, and the problem is that the tidy binary is linked w/ libtidy - before it was linking statically, when the shared lib has the proper name it links against it. During fake, the Makefile calls the binary from the wrong location (work area, not fake). The makefile needs to be fixed to work with fake which is a bit of a pain.
mysql-server package changes
Hey, same change for mysql-server as mbalmer@ did for postgresql-server. Don't install a database with an empty root password. Additionally: 'pkg_delete -c' shouldn't remove the databases. ok? Bernd Index: Makefile === RCS file: /home/OpenBSD/cvs/ports/databases/mysql/Makefile,v retrieving revision 1.121 diff -u -p -r1.121 Makefile --- Makefile14 Oct 2006 05:04:54 - 1.121 +++ Makefile18 Oct 2006 16:33:42 - @@ -12,7 +12,7 @@ COMMENT-tests=multithreaded SQL databa VERSION= 5.0.26 DISTNAME= mysql-${VERSION} FULLPKGNAME= mysql-client-${VERSION} -PKGNAME-server=mysql-server-${VERSION} +PKGNAME-server=mysql-server-${VERSION}p0 FULLPKGNAME-tests= mysql-tests-${VERSION} CATEGORIES=databases V= MySQL-5.0 Index: pkg/INSTALL-server === RCS file: pkg/INSTALL-server diff -N pkg/INSTALL-server --- pkg/INSTALL-server 12 Oct 2004 21:14:42 - 1.10 +++ /dev/null 1 Jan 1970 00:00:00 - @@ -1,42 +0,0 @@ -#!/bin/sh -# $OpenBSD: INSTALL-server,v 1.10 2004/10/12 21:14:42 espie Exp $ -# -# Pre/post-installation setup of MySQL - -PATH=/bin:/usr/bin:/sbin:/usr/sbin -PREFIX=${PKG_PREFIX:-/usr/local} -DB_DIR=${DB_DIR} - -do_notice_existingdir() -{ - echo - echo +--- - echo | You appear to already have a MySQL database directory in $DB_DIR - echo | - echo | The database directory has been preserved. If you want to start - echo | from the default database setup, you should perform these steps - echo | as root: - echo | - echo | rm -rf $DB_DIR - echo | $PREFIX/bin/mysql_install_db - echo | - echo +--- - echo -} - -do_database_install() -{ - $PREFIX/bin/mysql_install_db -} - -case $2 in -POST-INSTALL) - if [ -d $DB_DIR ]; then - do_notice_existingdir - else - do_database_install - fi - ;; -esac - -exit 0 Index: pkg/MESSAGE-server === RCS file: pkg/MESSAGE-server diff -N pkg/MESSAGE-server --- /dev/null 1 Jan 1970 00:00:00 - +++ pkg/MESSAGE-server 18 Oct 2006 16:28:24 - @@ -0,0 +1,2 @@ +The mysql-server package doesn't initialize a default database. +Please run ${PREFIX}/bin/mysql_install_db to create an initial database. Index: pkg/PLIST-server === RCS file: /home/OpenBSD/cvs/ports/databases/mysql/pkg/PLIST-server,v retrieving revision 1.23 diff -u -p -r1.23 PLIST-server --- pkg/PLIST-server14 Oct 2006 05:04:54 - 1.23 +++ pkg/PLIST-server18 Oct 2006 16:33:28 - @@ -150,5 +150,4 @@ share/mysql/swedish/ share/mysql/swedish/errmsg.sys share/mysql/ukrainian/ share/mysql/ukrainian/errmsg.sys [EMAIL PROTECTED] rm -rf ${DB_DIR} @extraunexec rm -rf ${SOCKET_DIR}
Re: UPDATE: www/tidy
this is a fixed patch links binary against shared lib fixes the way it's called (goes to fake location) binary/libs installed to fake/ before headers now (since headers are generated, other order breaks) sets LD_LIBRARY_PATH Index: Makefile === RCS file: /cvs/ports/www/tidy/Makefile,v retrieving revision 1.19 diff -u -r1.19 Makefile --- Makefile5 Oct 2005 09:39:20 - 1.19 +++ Makefile18 Oct 2006 17:23:53 - @@ -2,9 +2,10 @@ COMMENT= validate, correct, and pretty-print HTML files -TIDYDATE= 050921 +TIDYDATE= 051026 DISTNAME= tidy_src_${TIDYDATE} PKGNAME= tidy-${TIDYDATE} +SHARED_LIBS= tidy 1.0 CATEGORIES= www @@ -23,8 +24,8 @@ MASTER_SITES1= ${HOMEPAGE}test/ EXTRACT_SUFX= .tgz DISTFILES= ${DISTNAME}${EXTRACT_SUFX} \ - tidy_docs_050705${EXTRACT_SUFX}:0 \ - tidy_test_050919${EXTRACT_SUFX}:1 + tidy_docs_051020${EXTRACT_SUFX}:0 \ + tidy_test_051026${EXTRACT_SUFX}:1 USE_GMAKE= Yes @@ -34,6 +35,9 @@ WRKBUILD= ${WRKDIST}/build/gmake DOCDIR=${PREFIX}/share/doc/tidy + +MAKE_FLAGS=TIDY_MAJOR=${LIBtidy_VERSION:R} TIDY_MINOR=${LIBtidy_VERSION:E} +FAKE_FLAGS=TIDY_MAJOR=${LIBtidy_VERSION:R} TIDY_MINOR=${LIBtidy_VERSION:E} post-install: ${INSTALL_DATA_DIR} ${DOCDIR} Index: distinfo === RCS file: /cvs/ports/www/tidy/distinfo,v retrieving revision 1.7 diff -u -r1.7 distinfo --- distinfo5 Oct 2005 09:39:20 - 1.7 +++ distinfo18 Oct 2006 17:23:53 - @@ -1,12 +1,12 @@ -MD5 (tidy_docs_050705.tgz) = 2e6533fc48b077ff6243deaf21a781de -MD5 (tidy_src_050921.tgz) = 82c76c061abfdf5f67d02951b4dd2a02 -MD5 (tidy_test_050919.tgz) = c9ca834e381537039e516da549662651 -RMD160 (tidy_docs_050705.tgz) = 49b8c2eaf87a0291b1bef6479cf1eeda6b720f52 -RMD160 (tidy_src_050921.tgz) = 958f532245412e3f8ac5bdd56edc5693cadf4b5b -RMD160 (tidy_test_050919.tgz) = 337ca275ca6af513b1bf2a5bd4b10a2a244e90fe -SHA1 (tidy_docs_050705.tgz) = b243d7910ce2fe57a8df27ff8f775e6d397c732d -SHA1 (tidy_src_050921.tgz) = 4a53aa129e2575004dcbaf0cf4c5c3f1637723b0 -SHA1 (tidy_test_050919.tgz) = d214f85d581ceeeb4ec58d24d8d7494e10e62125 -SIZE (tidy_docs_050705.tgz) = 150359 -SIZE (tidy_src_050921.tgz) = 256079 -SIZE (tidy_test_050919.tgz) = 106674 +MD5 (tidy_docs_051020.tgz) = 86de2f198e57399c063d2567b2a25628 +MD5 (tidy_src_051026.tgz) = 1e39fafd6808978871346658c8da1454 +MD5 (tidy_test_051026.tgz) = 4b35b2e0495ad2fc1bc391f779c9541d +RMD160 (tidy_docs_051020.tgz) = 63f033560af9a53393d9a3f656f26bb12bf505b6 +RMD160 (tidy_src_051026.tgz) = 0cae41f8c0cec51d4600d1bf2aac338cf60aa6b9 +RMD160 (tidy_test_051026.tgz) = 1caaf13ce9d484d8321b8b370782966066ea3a6f +SHA1 (tidy_docs_051020.tgz) = 04988d51267566db6899e8061d9f2e5b58fbeec4 +SHA1 (tidy_src_051026.tgz) = 53be36945344af0c4080c34ebc95728bf8617f1c +SHA1 (tidy_test_051026.tgz) = a790c98bdabffb8c181796e7ef4007cfbeb1f370 +SIZE (tidy_docs_051020.tgz) = 150402 +SIZE (tidy_src_051026.tgz) = 256131 +SIZE (tidy_test_051026.tgz) = 107014 Index: patches/patch-build_gmake_Makefile === RCS file: /cvs/ports/www/tidy/patches/patch-build_gmake_Makefile,v retrieving revision 1.2 diff -u -r1.2 patch-build_gmake_Makefile --- patches/patch-build_gmake_Makefile 19 Jul 2005 08:10:10 - 1.2 +++ patches/patch-build_gmake_Makefile 18 Oct 2006 17:34:25 - @@ -1,6 +1,5 @@ -$OpenBSD: patch-build_gmake_Makefile,v 1.2 2005/07/19 08:10:10 aanriot Exp $ build/gmake/Makefile.orig Tue May 3 08:58:08 2005 -+++ build/gmake/Makefile Tue Jul 12 12:03:54 2005 +--- build/gmake/Makefile.orig Fri Jul 15 08:58:10 2005 build/gmake/Makefile Wed Oct 18 19:34:22 2006 @@ -58,8 +58,8 @@ SHELL=/bin/sh PROJECT=tidy @@ -19,7 +18,7 @@ -CC= gcc -CFLAGS= -g -Wall -Wno-switch -Wno-parentheses -I $(INCDIR) +#CC= gcc -+CFLAGS+= -I $(INCDIR) ++CFLAGS+= -fPIC -I $(INCDIR) # flags only supported with gcc 3.x # CFLAGS += -Wunused-parameter @@ -29,16 +28,28 @@ # OTHERCFLAGS+= -DSUPPORT_ACCESSIBILITY_CHECKS=1 -DSUPPORT_UTF16_ENCODINGS=1 -DSUPPORT_ASIAN_ENCODINGS=1 ifdef SUPPORT_UTF16_ENCODINGS CFLAGS += -DSUPPORT_UTF16_ENCODINGS=$(SUPPORT_UTF16_ENCODINGS) -@@ -115,7 +115,7 @@ LIBSUFFIX = .a +@@ -112,10 +112,12 @@ TIDY_MINOR = 0 + # This will come from autoconf again + LIBPREFIX = lib + LIBSUFFIX = .a ++SHAREDLIBSUFFIX = .so OBJSUF = .o LIBRARY = $(LIBDIR)/$(LIBPREFIX)$(PROJECT)$(LIBSUFFIX) -AR=ar -r ++SHAREDLIBRARY = $(LIBDIR)/$(LIBPREFIX)$(PROJECT)$(SHAREDLIBSUFFIX).$(TIDY_MAJOR).$(TIDY_MINOR) +#AR=ar -r XSLTPROC = xsltproc -@@ -164,7 +164,7 @@ doc:$(DOCS) +@@ -158,17 +160,21 @@ LIBHFILES= \ + $(SRCDIR)/tidy-int.h + + +-all:$(LIBRARY) $(EXES) ++all:$(LIBRARY) $(SHAREDLIBRARY) $(EXES) + + doc:$(DOCS)
databases/postgresql, drop ecpg?
I am thinking about dropping the support for ecpg - the embedded SQL C processor that converts C programs with embedded SQL statements to files with functions calls. I think is a lame concept and I am not sure if anybody uses it really. If you use this feature, now is the time to speak up.
Re: UPDATE: www/tidy
On Wed, Oct 18, 2006 at 11:38:00AM -0600, Peter Valchev wrote: this is a fixed patch links binary against shared lib fixes the way it's called (goes to fake location) binary/libs installed to fake/ before headers now (since headers are generated, other order breaks) sets LD_LIBRARY_PATH I ran in to the same issue and fixed it the same way. Apparently I missed it in the patch... perhaps I missed a 'make update-patches' step? Anyway, thanks! -Dan -- Burnished gallows set with red Caress the fevered, empty mind Of man who hangs bloodied and blind To reach for wisdom, not for bread. -- Deoridhe Grimsdaughter
Re: NEW: visitors
On Wed, 18 Oct 2006 17:33:07 +0900 Mathieu Sauve-Frankel [EMAIL PROTECTED] wrote: yeah.. here's the tarball :-D -- Mathieu Sauve-Frankel Cool toy but I had segmentation faults on 3.9 i386. After correcting the booboo all is fine. /tmp $ diff -ur www/visitors/ /usr/ports/www/visitors/ diff -ur www/visitors/patches/patch-visitors_c /usr/ports/www/visitors/patches/patch-visitors_c --- www/visitors/patches/patch-visitors_c Fri Jan 6 22:15:58 2006 +++ /usr/ports/www/visitors/patches/patch-visitors_cWed Oct 18 19:28:08 2006 @@ -1,16 +1,15 @@ -$OpenBSD$ visitors.c.origWed Oct 26 07:07:25 2005 -+++ visitors.c Fri Jan 6 16:15:45 2006 -@@ -1083,7 +1083,7 @@ int vi_process_visitors_per_day(struct v +--- visitors.c.origWed Oct 18 19:26:57 2006 visitors.c Wed Oct 18 19:27:36 2006 +@@ -1257,7 +1257,7 @@ agent_len = strlen(agent); date_len = strlen(date); h = djb_hash((unsigned char*) agent, agent_len); -sprintf(buf, %lu, h); -+sprintf(buf, sizeof(buf), %lu, h); ++snprintf(buf, sizeof(buf), %lu, h); hash_len = strlen(buf); if (host_len+agent_len+date_len+4 VI_LINE_MAX) return 0; -@@ -2094,7 +2094,7 @@ void vi_print_hours_report(FILE *fp, str +@@ -2349,7 +2349,7 @@ Output-print_subtitle(fp, Percentage of hits in every hour of the day); for (i = 0; i 24; i++) { char buf[8]; Only in www/visitors/patches: patch-visitors_c.orig
Re: OpenBSD for kids: Ri-li-1.2.0
On Tue, 17 Oct 2006 19:00:03 +0200 (CEST) Antoine Jacoutot [EMAIL PROTECTED] wrote: Allright... I needed a do something useless-break and came up with this. PKG/DESCR Ri-li is a arcade game where you drive a toy wood engine in many levels and you must collect all the coaches for win. - Colorful animated wood engine - 40 levels - 3 beautiful musics and many sound effects - 8 languages (Arabic, Chinese, English, French, German, Japanese, Russian, Spanish) Nice game. :) Builds and runs on i386, but I had few minor problems with the highscore list: 1) Scandinavian letters like 'ä' or 'ö' are shown as 'd' and 'v'. - This is probably a feature, because code does key=keysym.unicode0x7F; 2) Sometimes highscore list window stops accepting other keyboard input than enter. One should be able to trigger this by selecting 'Esperando' as a language, then playing a little, changing the language to 'Svenska' and then getting on the highscore list and pressing 'shift'. It seems that something corrupts TableTexte[] table when one changes the language. The highscore list relies to CharExiste function(sprite.cc) when it validates keys: bool CharExiste(char C) { /* printf my addition -tkoskine */ printf(TableTexte[(int)(%d)] = %d\n, (int)C, TableTexte[(int)(C)]); if(C==' ') return true; if(TableTexte[(int)(C)]!=-1) return true; return false; } Before the language change printf prints following: TableTexte[(int)(0)] = -1 After the language change the output is: TableTexte[(int)(0)] = 478 -- Tero Koskinen - http://iki.fi/tero.koskinen/
Re: databases/postgresql, drop ecpg?
Marc, for what it is worth you have my vote to drop it,C (libpq) is all I ever use on PostgreSQL anyway. Sam Fourman Jr. On 10/18/06, Marc Balmer [EMAIL PROTECTED] wrote: I am thinking about dropping the support for ecpg - the embedded SQL C processor that converts C programs with embedded SQL statements to files with functions calls. I think is a lame concept and I am not sure if anybody uses it really. If you use this feature, now is the time to speak up.
New: www/p5-HTML-Tidy [was: Re: UPDATE: www/tidy]
On Wed, Oct 18, 2006 at 11:38:00AM -0600, Peter Valchev wrote: this is a fixed patch links binary against shared lib fixes the way it's called (goes to fake location) binary/libs installed to fake/ before headers now (since headers are generated, other order breaks) sets LD_LIBRARY_PATH Thanks to building libtidy, we can now use HTML::Tidy, http://cleannorth.org/~odin/p5-HTML-Tidy.tar.gz Comments appreciated. -Dan -- Burnished gallows set with red Caress the fevered, empty mind Of man who hangs bloodied and blind To reach for wisdom, not for bread. -- Deoridhe Grimsdaughter
Re: OpenBSD for kids: Ri-li-1.2.0
On Wed, 18 Oct 2006, Hans Zimmerman wrote: built and runs fine on macppc too. I had fun on amd64 :) Can somebody confirm it builds and works fine under i386? Thanks! -- Antoine
update: editors/vim 7.0.109 - 7.0.145
more shiny little patches -- GDB has a 'break' feature; why doesn't it have 'fix' too? vim.diff Description: Binary data
Re: NEW: visitors
Cool toy but I had segmentation faults on 3.9 i386. After correcting the booboo all is fine. here's a revised port. without the graphviz dependency and the old patch. -- Mathieu Sauve-Frankel visitors.tgz Description: application/tar-gz
Re: databases/postgresql, changes to the -server subpackage
I'm a bit confused with your patch and comments. The bit that reads: -- +a default database first. In the following example we install a database +in /var/postgresql/data with a dba account 'postgres' and md5 authentication. +We will be prompted for a password to protect the dba account: -- Do you really mean a user account of 'postgres'? I thought this user was changed to '_postgresql' in out OpenBSD port. By dba account do you mean a system user account or a PostgreSQL database account? And exactly which step is going to prompt for a password? --- Marc Balmer [EMAIL PROTECTED] wrote: I am changing slightly the way we install a PostgreSQL server. To recall, up to now installing the postgresql-server package created a default database for you. But this database was not secured. This has led to problems in some installations where the users were not aware of this. So no database is created during package install, instead instructions are given on how to create a properly secured database. ok? Index: databases/postgresql/Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.91 diff -u -r1.91 Makefile --- databases/postgresql/Makefile 15 Oct 2006 16:00:11 - 1.91 +++ databases/postgresql/Makefile 18 Oct 2006 11:12:19 - @@ -7,7 +7,7 @@ VERSION= 8.1.5 DISTNAME=postgresql-${VERSION} FULLPKGNAME= postgresql-client-${VERSION} -PKGNAME-server= postgresql-server-${VERSION} +PKGNAME-server= postgresql-server-${VERSION}p0 PKGNAME-docs=postgresql-docs-${VERSION} CATEGORIES= databases Index: databases/postgresql/files/README.OpenBSD === RCS file: /cvs/ports/databases/postgresql/files/README.OpenBSD,v retrieving revision 1.14 diff -u -r1.14 README.OpenBSD --- databases/postgresql/files/README.OpenBSD 15 Oct 2006 16:00:11 - 1.14 +++ databases/postgresql/files/README.OpenBSD 18 Oct 2006 11:12:19 - @@ -1,56 +1,40 @@ -Requirements - - -Please note that the OpenBSD port of the PostgreSQL server requires a -kernel compiled with SYSVSEM and SYSVSHM options for proper operation. -The GENERIC kernel has these settings. - Using PostgreSQL in an OpenBSD environment --- -If you are installing PostgreSQL for the first time, a default database -will have been created for you. If this failed for any reason or if you -want to use non-default paramaters, you can do something similar to the -following steps manually: +If you are installing PostgreSQL for the first time, you have to create +a default database first. In the following example we install a database +in /var/postgresql/data with a dba account 'postgres' and md5 authentication. +We will be prompted for a password to protect the dba account: # su - _postgresql $ mkdir /var/postgresql/data - $ initdb -D /var/postgresql/data - -If you are upgrading PostgreSQL then you may have a `pgsql' or `postgresql' -user. It is suggested that you follow the steps in + $ initdb -D /var/postgresql/data -U postgres -A md5 -W - !!PREFIX!!/share/doc/postgresql/INSTALL - -for more information on how to upgrade your existing databases. See -also `Special notes for the OpenBSD port' below. Replace references to -the `postgresql' user below with `pgsql' or whatever other user you -have selected to be the database administration account. +Please consult the PostgreSQL website for more information, especially when +you are upgrading an existing database installation. Auto Start and Stop -If you wish to start PostgreSQL automatically during system startup, -add the following lines to /etc/rc.local: +To start PostgreSQL at boot and shut it down when the system shuts down, +add the following lines to /etc/rc.local and /etc/rc.shutdown, respectively: + +/etc/rc.local: if [ -x !!PREFIX!!/bin/pg_ctl ]; then su -l _postgresql -c nohup !!PREFIX!!/bin/pg_ctl start \ - -D /var/postgresql/data -l /var/postgresql/logfile \ - -o '-D /var/postgresql/data' + -D /var/postgresql/data -l /var/postgresql/logfile \ + -o '-D /var/postgresql/data' echo -n ' postgresql' fi -To automatically shutdown the database as part of the system shutdown, -add the following lines to /etc/rc.shutdown: +/etc/rc.shutdown: if [ -f /var/postgresql/data/postmaster.pid ]; then su -l _postgresql -c !!PREFIX!!/bin/pg_ctl stop -m fast \ - -D /var/postgresql/data + -D /var/postgresql/data rm -f /var/postgresql/data/postmaster.pid fi Network Connections and Tuning --- To allow connections over TCP (and other options) edit the file: Index:
Re: OpenBSD for kids: Ri-li-1.2.0
On Wed, Oct 18, 2006 at 11:13:08PM +0200, Antoine Jacoutot wrote: On Wed, 18 Oct 2006, Hans Zimmerman wrote: built and runs fine on macppc too. I had fun on amd64 :) Can somebody confirm it builds and works fine under i386? Works fine. -- o--{ Will Maier }--o | web:...http://www.lfod.us/ | [EMAIL PROTECTED] | *--[ BSD Unix: Live Free or Die ]--*
Re: databases/postgresql, drop ecpg?
--- Joachim Schipper [EMAIL PROTECTED] wrote: On Wed, Oct 18, 2006 at 08:10:04PM +0200, Marc Balmer wrote: I am thinking about dropping the support for ecpg - the embedded SQL C processor that converts C programs with embedded SQL statements to files with functions calls. I think is a lame concept and I am not sure if anybody uses it really. If you use this feature, now is the time to speak up. Not that I use this feature, but... why do you want to remove it? Is it difficult to support? Same here, why the desire to drop support for it? Joachim __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
linux compatibility
I have just switched most linux ports from redhat_base to fedora_base (the missing ones will be committed ASAP). In case of any problems, please contact me directly. As of now, the only known issue is in opera, where some webpages are now rendered non-anti aliased. I'll work on this soon. FYI, our redhat_base port was quite old and acroread was the first port that needed newer libraries. Unfortunately we are currently forced to use the old linuxthreads libraries. Therefor I chose fedora core 4 as a middle ground that still provides linuxthreads libraries, while providing us more modern linux libraries. Nikolay -- It's all part of my Can't-Do approach to life. Wally
Re: linux compatibility
Nikolay Sturm wrote: I have just switched most linux ports from redhat_base to fedora_base (the missing ones will be committed ASAP). In case of any problems, please contact me directly. As of now, the only known issue is in opera, where some webpages are now rendered non-anti aliased. I'll work on this soon. FYI, our redhat_base port was quite old and acroread was the first port that needed newer libraries. Unfortunately we are currently forced to use the old linuxthreads libraries. Therefor I chose fedora core 4 as a middle ground that still provides linuxthreads libraries, while providing us more modern linux libraries. Nikolay Very nice! Saw the fedora stuff on ports-changes@ earlier and am already messing with it. If this works out i can swicth some more machines from Linux to OpenBSD. 'll report back when i'm done nuking it with buggy linux apps. So far it looks very promising! THX! -Robert
Re: linux compatibility
On Thu, Oct 19, 2006 at 02:44:30AM +0200, Nikolay Sturm wrote: As of now, the only known issue is in opera, where some webpages are now rendered non-anti aliased. I'll work on this soon. I had issues with fonts in several Linux applications in OpenBSD 3.9 already (Opera and OpenOffice for Linux). I've found a workaround by creating this link in /usr/share fonts@ - /usr/local/lib/X11/fonts Since msttcorefonts-1.2 package is installed there in OpenBSD, and Linux distros put it in /usr/share/fonts this tricks Opera in believing that it's a natural environment it was built for. It perhaps isn't what you are looking for, but it works for me. :-) Best regards, Zvezdan