Re: prosody with mysql clarification

2016-02-12 Thread Stephen Graf
Henrik, I would appreciate if you could look into this.  I put prosody and
the mysql driver on my production system with the same error.  The
production system is also the release version of openBSD 5.8 and the
additions came from packages. Do you have a test system on which you can
test this?  There is really nothing to configure to add mysql other than
adding the lua mysql package.


Error message from production system:

Feb 12 22:42:06 storagemanager  error   Failed to load storage driver plugin
sql on secure.gccinc.ca: /usr/local/share/lua/5.1/DBI.lua:52: Cannot load
driver MySQL. Available drivers are: SQLite3
stack traceback:

But the mysql package is there:

# ls -al /usr/local/lib/lua/5.1
total 392
drwxr-xr-x  5 root  wheel512 Feb 12 20:25 .
drwxr-xr-x  3 root  wheel512 Jan 14 22:32 ..
-r-xr-xr-x  1 root  bin28966 Aug  7  2015 dbdmysql.so
-r-xr-xr-x  1 root  bin18801 Aug  7  2015 dbdsqlite3.so
-r--r--r--  1 root  bin18473 Aug  7  2015 lfs.so
drwxr-xr-x  2 root  wheel512 Feb 12 20:22 luaevent
-r--r--r--  1 root  bin39219 Aug  7  2015 lxp.so
drwxr-xr-x  2 root  wheel512 Feb 12 20:22 mime
drwxr-xr-x  2 root  wheel512 Feb 12 20:22 socket
-r--r--r--  1 root  bin63197 Aug  7  2015 ssl.so
-r--r--r--  1 root  bin13229 Aug  7  2015 zlib.so


-Original Message-
From: owner-po...@openbsd.org [mailto:owner-po...@openbsd.org] On Behalf Of
Stephen Graf
Sent: Friday, February 12, 2016 2:07 PM
To: ports@openbsd.org
Subject: FW: prosody with mysql clarification

Additional information:

The system is running openBSD 5.8 from the release.  It is a test system.
It did have wireshark and redis installed which brought in lua ver 5.2.  I
took all the lua packages pertaining to lua out and resinstalled just
prosody and the mysql and postgress drivers.

-Original Message-
From: Adam Wolk [mailto:adam.w...@tintagel.pl]
Sent: Friday, February 12, 2016 1:54 PM
To: Stephen Graf 
Subject: Re: prosody with mysql clarification

On Fri, 12 Feb 2016 13:02:56 -0800
"Stephen Graf"  wrote:

> Thank you for replying to my post.  I am sending this to you only as I 
> am not sure of the procedures on the ports mailing list.  I have used 
> openBSD for many years for bacula, samba and recently ownCloud and 
> have never resorted to the opwnBSD mailing lists for help.
> However I am wanting to install a jabber server and I first tried 
> jabberd until I realized the package is horribly out of date and not 
> maintained.  Prosody seems much better and cleaner.  The installation 
> of mysql seems simply enough, but it just does not seem to work and 
> there is very little on the web for help.
> 

Hi Stephen,
No need to worry about ports@. Your email was OK, people just asked for more
detail as it was hard to judge what the issue was exactly.

In short I think you should forward the details you provided here to the
ports@ mailing list. Additionally outlining if you are using -current or a
specific release (that's the only information missing here I think). I added
some more answers inline. Feel free to just forward this email or your
original reply with more details.

> If you have a few spare moments, I have listed what I have done.  If 
> you have a test system can you try mysql?  I added the postgress 
> driver on my test system and it seems to pick that up.
> 

Unfortunately my XMPP system is also my personal mail server additionally
running -current. I would need to upgrade to a newer snapshot before trying
any mysql ports and I would rather avoid service disruption at this point. I
could try in a VM if you indicate which OpenBSD version you are trying to
accomplish this with.

> I am trying to set up mysql and getting an error saying the DBI.lua 
> module cannot load the driver MYSQL.  I looked at the DBI.lua code and 
> it would seem that it should work.
> 
> Error message from log:
> 
> Feb 12 11:29:27 modulemanager   error   Error initializing module
> 'storage_sql' on 'xxx': /usr/local/share/lua/5.1/DBI.lua:52: Cannot 
> load driver MySQL. Available drivers are: SQLite3,PostgreSQL stack
> traceback:
> 

This really looks like it could be a valid bug, considering that your setup
properly detects postgresql. Note I asked if you did anything post
installing as your initial mail didn't indicate it.

> 
> From DBI.lua code:
> 
> -- Driver to module mapping
> local name_to_module = {
> MySQL = 'dbdmysql',
> PostgreSQL = 'dbdpostgresql',
> SQLite3 = 'dbdsqlite3',
> DB2 = 'dbddb2',
> Oracle = 'dbdoracle',
> }
> 
> # ls -al /usr/local/lib/lua/5.1/
> total 440
> drwxr-xr-x  5 root  wheel512 Feb 12 11:29 .
> drwxr-xr-x  3 root  wheel512 Feb 12 11:10 ..
> -r-xr-xr-x  1 root  bin28966 Aug  7  2015 dbdmysql.so
> -r-xr-xr-x  1 root  bin22907 Aug  7  2015 dbdpostgresql.so
> -r-xr-xr-x  1 root  bin18801 Aug  7  2015 dbdsqlite3.so
> -r--r--r--  1 root  bin18473 Aug  7  2015 lfs.so
> drwxr-xr-x  2 root  wheel512 Feb 12 11:11 luaevent
> -r--r--

Re: UPDATE: ledger 3.1.1

2016-02-12 Thread Bryan Linton
On 2016-01-14 22:40:48, Florian Stinglmayr  wrote:
> Hello list,
> 
> here is an update for ledger. It updates ledger from 2. something to
> ledger 3.1.1. It has moved to github, and I need to patch the cmake
> a little to make it proper.
> 
> Could someone who's already using ledger confirm that it is working
> as it should, as I am just staring out to get my finances into ledger.
> 
> @Sergey Could you give your input?
> 
> Thanks,
> Florian
> 
> P.S.: I see the cmus patches still didn't make it in :-(
>

I can't get this to build correctly on my machine.  I've tried
updating to newer snapshots several times since you originally
sent it out and updated my ports tree each time, thinking that it
may be a local problem, but it still won't build.

This is what is output when I try resuming the build after it
fails.  It seems like the key line is probably:
/usr/bin/ld: cannot find -llibledger.so.3

Any ideas on how to fix this?  I've been using ledger for years
and it seems like the author wants to deprecate the 2.x series, so
I'd be happy to help test this so it can be upgraded to the 3.x
series.  (After the ports unlock of course)



Script started on Sat Feb 13 11:04:34 2016
% make
===>  Building for ledger-3.1.1
[1/4] : && /usr/local/bin/eg++   -O2 -pipe-DNDEBUG   
test/unit/CMakeFiles/MathTests.dir/t_amount.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_commodity.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_balance.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_expr.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_value.cc.o  -o MathTests 
-L/usr/obj/ports/ledger-3.1.1/build-i386 -llibledger.so.3 -lmpfr -lgmp 
-lboost_date_time-mt -lboost_filesystem-mt -lboost_system-mt 
-lboost_iostreams-mt -lboost_regex-mt -lboost_unit_test_framework-mt 
-Wl,-rpath,/usr/obj/ports/ledger-3.1.1/build-i386 
-Wl,-rpath-link,/usr/X11R6/lib && :
FAILED: : && /usr/local/bin/eg++   -O2 -pipe-DNDEBUG   
test/unit/CMakeFiles/MathTests.dir/t_amount.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_commodity.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_balance.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_expr.cc.o 
test/unit/CMakeFiles/MathTests.dir/t_value.cc.o  -o MathTests 
-L/usr/obj/ports/ledger-3.1.1/build-i386 -llibledger.so.3 -lmpfr -lgmp 
-lboost_date_time-mt -lboost_filesystem-mt -lboost_system-mt 
-lboost_iostreams-mt -lboost_regex-mt -lboost_unit_test_framework-mt 
-Wl,-rpath,/usr/obj/ports/ledger-3.1.1/build-i386 
-Wl,-rpath-link,/usr/X11R6/lib && :
/usr/bin/ld: cannot find -llibledger.so.3
collect2: error: ld returned 1 exit status
ninja: build stopped: subcommand failed.
*** Error 1 in . (/usr/ports/devel/cmake/cmake.port.mk:31 'do-build': @cd 
/usr/obj/ports/ledger-3.1.1/build-i386 && exec /usr/bin/env -i LIB...)
*** Error 1 in . (/usr/ports/infrastructure/mk/bsd.port.mk:2769 
'/usr/obj/ports/ledger-3.1.1/build-i386/.build_done')
*** Error 1 in /usr/ports/productivity/ledger 
(/usr/ports/infrastructure/mk/bsd.port.mk:2495 'all')
% 

Script done on Sat Feb 13 11:05:58 2016

-- 
Bryan



Re: xlsx2csv broken

2016-02-12 Thread Dmitrij D. Czarkoff
Antoine Jacoutot said:
> unset GOPATH; export 
> GOPATH="/exopi-obj/pobj/xlsx2csv-20150225/go:/usr/local/go-pkg"; go install 
> -x github.com/tealeg/xlsx2csv
> WORK=/tmp/go-build67122
> mkdir -p $WORK/github.com/tealeg/xlsx/_obj/
> mkdir -p $WORK/github.com/tealeg/
> cd /usr/local/go-pkg/src/github.com/tealeg/xlsx
> /usr/local/go/pkg/tool/openbsd_amd64/compile -o 
> $WORK/github.com/tealeg/xlsx.a -trimpath $WORK -p github.com/tealeg/xlsx 
> -complete -buildid 90518c0c038b7176e8b01fb5b752aef4df0eb80d -D 
> _/usr/local/go-pkg/src/github.com/tealeg/xlsx -I $WORK -pack ./cell.go 
> ./col.go ./date.go ./doc.go ./file.go ./hsl.go ./lib.go ./reftable.go 
> ./row.go ./sheet.go ./style.go ./templates.go ./theme.go ./write.go 
> ./xmlContentTypes.go ./xmlSharedStrings.go ./xmlStyle.go ./xmlTheme.go 
> ./xmlWorkbook.go ./xmlWorksheet.go

For some reason go tries to rebuild github.com/tealeg/xlsx package
(textproc/go-xlsx).  This should never happen, and it indeed never
happens on my machine.  Interestingly, similar thing happened before
(http://article.gmane.org/gmane.os.openbsd.ports/77273), and I couldn't
reproduce it back then either.  Maybe something uncommon in your
environment?

-- 
Dmitrij D. Czarkoff



FW: prosody with mysql clarification

2016-02-12 Thread Stephen Graf
Additional information:

The system is running openBSD 5.8 from the release.  It is a test system.
It did have wireshark and redis installed which brought in lua ver 5.2.  I
took all the lua packages pertaining to lua out and resinstalled just
prosody and the mysql and postgress drivers.

-Original Message-
From: Adam Wolk [mailto:adam.w...@tintagel.pl] 
Sent: Friday, February 12, 2016 1:54 PM
To: Stephen Graf 
Subject: Re: prosody with mysql clarification

On Fri, 12 Feb 2016 13:02:56 -0800
"Stephen Graf"  wrote:

> Thank you for replying to my post.  I am sending this to you only as I 
> am not sure of the procedures on the ports mailing list.  I have used 
> openBSD for many years for bacula, samba and recently ownCloud and 
> have never resorted to the opwnBSD mailing lists for help.
> However I am wanting to install a jabber server and I first tried 
> jabberd until I realized the package is horribly out of date and not 
> maintained.  Prosody seems much better and cleaner.  The installation 
> of mysql seems simply enough, but it just does not seem to work and 
> there is very little on the web for help.
> 

Hi Stephen,
No need to worry about ports@. Your email was OK, people just asked for more
detail as it was hard to judge what the issue was exactly.

In short I think you should forward the details you provided here to the
ports@ mailing list. Additionally outlining if you are using -current or a
specific release (that's the only information missing here I think). I added
some more answers inline. Feel free to just forward this email or your
original reply with more details.

> If you have a few spare moments, I have listed what I have done.  If 
> you have a test system can you try mysql?  I added the postgress 
> driver on my test system and it seems to pick that up.
> 

Unfortunately my XMPP system is also my personal mail server additionally
running -current. I would need to upgrade to a newer snapshot before trying
any mysql ports and I would rather avoid service disruption at this point. I
could try in a VM if you indicate which OpenBSD version you are trying to
accomplish this with.

> I am trying to set up mysql and getting an error saying the DBI.lua 
> module cannot load the driver MYSQL.  I looked at the DBI.lua code and 
> it would seem that it should work.
> 
> Error message from log:
> 
> Feb 12 11:29:27 modulemanager   error   Error initializing module
> 'storage_sql' on 'xxx': /usr/local/share/lua/5.1/DBI.lua:52: Cannot 
> load driver MySQL. Available drivers are: SQLite3,PostgreSQL stack 
> traceback:
> 

This really looks like it could be a valid bug, considering that your setup
properly detects postgresql. Note I asked if you did anything post
installing as your initial mail didn't indicate it.

> 
> From DBI.lua code:
> 
> -- Driver to module mapping
> local name_to_module = {
> MySQL = 'dbdmysql',
> PostgreSQL = 'dbdpostgresql',
> SQLite3 = 'dbdsqlite3',
> DB2 = 'dbddb2',
> Oracle = 'dbdoracle',
> }
> 
> # ls -al /usr/local/lib/lua/5.1/
> total 440
> drwxr-xr-x  5 root  wheel512 Feb 12 11:29 .
> drwxr-xr-x  3 root  wheel512 Feb 12 11:10 ..
> -r-xr-xr-x  1 root  bin28966 Aug  7  2015 dbdmysql.so
> -r-xr-xr-x  1 root  bin22907 Aug  7  2015 dbdpostgresql.so
> -r-xr-xr-x  1 root  bin18801 Aug  7  2015 dbdsqlite3.so
> -r--r--r--  1 root  bin18473 Aug  7  2015 lfs.so
> drwxr-xr-x  2 root  wheel512 Feb 12 11:11 luaevent
> -r--r--r--  1 root  bin39219 Aug  7  2015 lxp.so
> drwxr-xr-x  2 root  wheel512 Feb 12 11:11 mime
> drwxr-xr-x  2 root  wheel512 Feb 12 11:11 socket
> -r--r--r--  1 root  bin63197 Aug  7  2015 ssl.so
> -r--r--r--  1 root  bin13229 Aug  7  2015 zlib.so
> 
> 
> Config:
> 
> storage = "sql" -- Default is "internal"
> 
> -- For the "sql" backend, you can uncomment *one* of the below to
> configure: --sql = { driver = "SQLite3", database = "prosody.sqlite" } 
> -- Default. 'database' is the filename.
> sql = { driver = "MySQL", database = "prosody", username = "prosody", 
> password = "secret", host = "localhost" } --sql = { driver = 
> "PostgreSQL", database = "prosody", username = "prosody", password = 
> "secret", host = "localhost" }
> 
> The database has been set up
> 
> # mysql -u prosody -p
> Enter password:
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 11
> Server version: 10.0.20-MariaDB-log OpenBSD port:
> mariadb-server-10.0.20p0v0
> 
> Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input 
> statement.
> 
> MariaDB [(none)]> use prosody
> Database changed
> MariaDB [prosody]> show tables;
> Empty set (0.00 sec)
> 
> MariaDB [prosody]> exit;
> Bye
> 
> I tried a config with the postgress database and the error message 
> changes to show " Failed to connect to database: no connection to the 
> server" which makes sense as I do not have a postgress serve

Re: is hedgewars broken?

2016-02-12 Thread Matthias Kilian
Hi,

On Fri, Feb 12, 2016 at 03:48:43PM +0100, Antoine Jacoutot wrote:
> On Fri, Feb 12, 2016 at 03:22:44PM +0100, Pascal Stumpf wrote:
> > Works for me, and there's a snapshot package from Feb 11.  Is hs-dataenc
> > installed?  It needed to be revived from the Attic iirc, so I might have
> 
> Yeah it's installed.

[...]

> > > -- Looking for encode in Codec.Binary.Base64
> > > -- Looking for encode in Codec.Binary.Base64 - not found

Maybe the haskell package db is fucked (wouldn't be the first time
this happens)?

Does

ghc-pkg check

compain? Does

ghc-pkg list | grep dataenc

show anything?

Ciao,
Kili



Re: security: postgresql 9.4.6

2016-02-12 Thread Pierre-Emmanuel André
Le 12 février 2016 18:31:06 GMT+01:00, Stuart Henderson  
a écrit :
>"This release closes security hole CVE-2016-0773, an issue with regular
>expression (regex) parsing. Prior code allowed users to pass in
>expressions which included out-of-range Unicode characters, triggering
>a
>backend crash. This issue is critical for PostgreSQL systems with
>untrusted users or which generate regexes based on user input."
>
>(there's also a security fix for PL/Java but we don't package that,
>and some other bugfixes some of which are fairly important, see
>http://www.postgresql.org/docs/current/static/release-9-4-6.html).
>
>OK?
>
>Index: Makefile
>===
>RCS file: /cvs/ports/databases/postgresql/Makefile,v
>retrieving revision 1.208
>diff -u -p -r1.208 Makefile
>--- Makefile   3 Nov 2015 09:35:31 -   1.208
>+++ Makefile   12 Feb 2016 17:29:29 -
>@@ -11,7 +11,7 @@ BROKEN-sparc=Requires v9|v9a|v9b; reque
># DO NOT FORGET to also change the @ask-update entry in
>pkg/PLIST-server
> # in case a dump before / restore after pkg_add -u is required!
> 
>-VERSION=  9.4.5
>+VERSION=  9.4.6
> DISTNAME= postgresql-${VERSION}
> PKGNAME-main= postgresql-client-${VERSION}
> PKGNAME-server=   postgresql-server-${VERSION}
>Index: distinfo
>===
>RCS file: /cvs/ports/databases/postgresql/distinfo,v
>retrieving revision 1.58
>diff -u -p -r1.58 distinfo
>--- distinfo   3 Nov 2015 09:35:31 -   1.58
>+++ distinfo   12 Feb 2016 17:29:29 -
>@@ -1,2 +1,2 @@
>-SHA256 (postgresql-9.4.5.tar.gz) =
>qh15GK54Kg/F4Yhv1GP8iQPl/8PrbTtRUABlrsmIohA=
>-SIZE (postgresql-9.4.5.tar.gz) = 23211720
>+SHA256 (postgresql-9.4.6.tar.gz) =
>yTINOQEO7uR7rbqD8EzjJGLzHl5jI+y6NJCay0sKwFk=
>+SIZE (postgresql-9.4.6.tar.gz) = 23249307
>Index: patches/patch-src_backend_libpq_ip_c
>===
>RCS file:
>/cvs/ports/databases/postgresql/patches/patch-src_backend_libpq_ip_c,v
>retrieving revision 1.1
>diff -u -p -r1.1 patch-src_backend_libpq_ip_c
>--- patches/patch-src_backend_libpq_ip_c   18 Feb 2015 17:49:56 -  
>1.1
>+++ patches/patch-src_backend_libpq_ip_c   12 Feb 2016 17:29:29 -
>@@ -3,9 +3,9 @@ $OpenBSD: patch-src_backend_libpq_ip_c,v
> Use the address family from the address, not from the netmask,
> since the latter is unreliable. Fixes "samenet"/"samehost".
> 
> src/backend/libpq/ip.c.orig   Mon Feb 16 23:36:42 2015
>-+++ src/backend/libpq/ip.cMon Feb 16 23:47:56 2015
>-@@ -496,17 +496,16 @@ run_ifaddr_callback(PgIfAddrCallback callback,
>void *c
>+--- src/backend/libpq/ip.c.orig   Mon Feb  8 21:15:19 2016
> src/backend/libpq/ip.cFri Feb 12 17:18:09 2016
>+@@ -423,17 +423,16 @@ run_ifaddr_callback(PgIfAddrCallback callback,
>void *c
>   /* Check that the mask is valid */
>   if (mask)
>   {
>Index: patches/patch-src_include_storage_s_lock_h
>===
>RCS file:
>/cvs/ports/databases/postgresql/patches/patch-src_include_storage_s_lock_h,v
>retrieving revision 1.2
>diff -u -p -r1.2 patch-src_include_storage_s_lock_h
>--- patches/patch-src_include_storage_s_lock_h 16 Jan 2015 20:43:48
>-  1.2
>+++ patches/patch-src_include_storage_s_lock_h 12 Feb 2016 17:29:29
>-
>@@ -1,7 +1,7 @@
>$OpenBSD: patch-src_include_storage_s_lock_h,v 1.2 2015/01/16 20:43:48
>landry Exp $
> src/include/storage/s_lock.h.orig Mon Dec 15 18:07:34 2014
>-+++ src/include/storage/s_lock.h  Fri Jan 16 06:16:48 2015
>-@@ -745,6 +745,29 @@ typedef unsigned char slock_t;
>+--- src/include/storage/s_lock.h.orig Mon Feb  8 21:15:19 2016
> src/include/storage/s_lock.h  Fri Feb 12 17:18:09 2016
>+@@ -749,6 +749,29 @@ typedef unsigned char slock_t;
>  #endif
>  
>  
>Index: patches/patch-src_interfaces_ecpg_compatlib_Makefile
>===
>RCS file:
>/cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v
>retrieving revision 1.9
>diff -u -p -r1.9 patch-src_interfaces_ecpg_compatlib_Makefile
>--- patches/patch-src_interfaces_ecpg_compatlib_Makefile   8 Jan 2015
>15:01:11 - 1.9
>+++ patches/patch-src_interfaces_ecpg_compatlib_Makefile   12 Feb 2016
>17:29:29 -
>@@ -1,6 +1,6 @@
>$OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.9 2015/01/08
>15:01:11 pea Exp $
> src/interfaces/ecpg/compatlib/Makefile.orig   Mon May  6 13:57:06
>2013
>-+++ src/interfaces/ecpg/compatlib/MakefileThu May 16 15:15:48 2013
>+--- src/interfaces/ecpg/compatlib/Makefile.orig   Mon Feb  8 21:15:19
>2016
> src/interfaces/ecpg/compatlib/MakefileFri Feb 12 17:18:09 2016
> @@ -14,8 +14,8 @@ top_builddir = ../../../..
>  include $(top_builddir)/src/Makefile.global
>  
>@@ -11,4 +11,4 @@ $OpenBSD: patch-src_interfaces_ecpg_comp
> +SO_MINOR_VERSION=

Re: prosody with mysql clarification

2016-02-12 Thread Adam Wolk
On Thu, 11 Feb 2016 22:18:08 -0800
"Stephen Graf"  wrote:

> When I tried to set up prosody with sql storage using mysql I
> followed the instructions in the package and added luadbi-mysql.
> However prosody did not seem to pick up on it even though the prosody
> documentation says that nothing more is required.  When I looked into
> what luadbi-mysql provided I discovered a c library, dbdmysql.so. How
> is this converted to a lua file that prosody can use?
> 

What did you try after enabling the sql storage in prosody? Here are
the config changes I made (slightly redacted) to get prosody to use my
postgres database.

storage = "sql" -- Default is "internal"

-- For the "sql" backend, you can uncomment *one* of the below to configure:
--sql = { driver = "SQLite3", database = "prosody.sqlite" } -- Default. 
'database' is the filename.
--sql = { driver = "MySQL", database = "prosody", username = "prosody", 
password = "secret", host = "localhost" }
sql = { driver = "PostgreSQL", database = "prosody", username = "prosody", 
password = "secret", host = "localhost" }

Regards,
Adam



security: postgresql 9.4.6

2016-02-12 Thread Stuart Henderson
"This release closes security hole CVE-2016-0773, an issue with regular
expression (regex) parsing. Prior code allowed users to pass in
expressions which included out-of-range Unicode characters, triggering a
backend crash. This issue is critical for PostgreSQL systems with
untrusted users or which generate regexes based on user input."

(there's also a security fix for PL/Java but we don't package that,
and some other bugfixes some of which are fairly important, see
http://www.postgresql.org/docs/current/static/release-9-4-6.html).

OK?

Index: Makefile
===
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.208
diff -u -p -r1.208 Makefile
--- Makefile3 Nov 2015 09:35:31 -   1.208
+++ Makefile12 Feb 2016 17:29:29 -
@@ -11,7 +11,7 @@ BROKEN-sparc= Requires v9|v9a|v9b; reque
 # DO NOT FORGET to also change the @ask-update entry in pkg/PLIST-server
 # in case a dump before / restore after pkg_add -u is required!
 
-VERSION=   9.4.5
+VERSION=   9.4.6
 DISTNAME=  postgresql-${VERSION}
 PKGNAME-main=  postgresql-client-${VERSION}
 PKGNAME-server=postgresql-server-${VERSION}
Index: distinfo
===
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.58
diff -u -p -r1.58 distinfo
--- distinfo3 Nov 2015 09:35:31 -   1.58
+++ distinfo12 Feb 2016 17:29:29 -
@@ -1,2 +1,2 @@
-SHA256 (postgresql-9.4.5.tar.gz) = qh15GK54Kg/F4Yhv1GP8iQPl/8PrbTtRUABlrsmIohA=
-SIZE (postgresql-9.4.5.tar.gz) = 23211720
+SHA256 (postgresql-9.4.6.tar.gz) = yTINOQEO7uR7rbqD8EzjJGLzHl5jI+y6NJCay0sKwFk=
+SIZE (postgresql-9.4.6.tar.gz) = 23249307
Index: patches/patch-src_backend_libpq_ip_c
===
RCS file: /cvs/ports/databases/postgresql/patches/patch-src_backend_libpq_ip_c,v
retrieving revision 1.1
diff -u -p -r1.1 patch-src_backend_libpq_ip_c
--- patches/patch-src_backend_libpq_ip_c18 Feb 2015 17:49:56 -  
1.1
+++ patches/patch-src_backend_libpq_ip_c12 Feb 2016 17:29:29 -
@@ -3,9 +3,9 @@ $OpenBSD: patch-src_backend_libpq_ip_c,v
 Use the address family from the address, not from the netmask,
 since the latter is unreliable. Fixes "samenet"/"samehost".
 
 src/backend/libpq/ip.c.origMon Feb 16 23:36:42 2015
-+++ src/backend/libpq/ip.c Mon Feb 16 23:47:56 2015
-@@ -496,17 +496,16 @@ run_ifaddr_callback(PgIfAddrCallback callback, void *c
+--- src/backend/libpq/ip.c.origMon Feb  8 21:15:19 2016
 src/backend/libpq/ip.c Fri Feb 12 17:18:09 2016
+@@ -423,17 +423,16 @@ run_ifaddr_callback(PgIfAddrCallback callback, void *c
/* Check that the mask is valid */
if (mask)
{
Index: patches/patch-src_include_storage_s_lock_h
===
RCS file: 
/cvs/ports/databases/postgresql/patches/patch-src_include_storage_s_lock_h,v
retrieving revision 1.2
diff -u -p -r1.2 patch-src_include_storage_s_lock_h
--- patches/patch-src_include_storage_s_lock_h  16 Jan 2015 20:43:48 -  
1.2
+++ patches/patch-src_include_storage_s_lock_h  12 Feb 2016 17:29:29 -
@@ -1,7 +1,7 @@
 $OpenBSD: patch-src_include_storage_s_lock_h,v 1.2 2015/01/16 20:43:48 landry 
Exp $
 src/include/storage/s_lock.h.orig  Mon Dec 15 18:07:34 2014
-+++ src/include/storage/s_lock.h   Fri Jan 16 06:16:48 2015
-@@ -745,6 +745,29 @@ typedef unsigned char slock_t;
+--- src/include/storage/s_lock.h.orig  Mon Feb  8 21:15:19 2016
 src/include/storage/s_lock.h   Fri Feb 12 17:18:09 2016
+@@ -749,6 +749,29 @@ typedef unsigned char slock_t;
  #endif
  
  
Index: patches/patch-src_interfaces_ecpg_compatlib_Makefile
===
RCS file: 
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v
retrieving revision 1.9
diff -u -p -r1.9 patch-src_interfaces_ecpg_compatlib_Makefile
--- patches/patch-src_interfaces_ecpg_compatlib_Makefile8 Jan 2015 
15:01:11 -   1.9
+++ patches/patch-src_interfaces_ecpg_compatlib_Makefile12 Feb 2016 
17:29:29 -
@@ -1,6 +1,6 @@
 $OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.9 2015/01/08 
15:01:11 pea Exp $
 src/interfaces/ecpg/compatlib/Makefile.origMon May  6 13:57:06 2013
-+++ src/interfaces/ecpg/compatlib/Makefile Thu May 16 15:15:48 2013
+--- src/interfaces/ecpg/compatlib/Makefile.origMon Feb  8 21:15:19 2016
 src/interfaces/ecpg/compatlib/Makefile Fri Feb 12 17:18:09 2016
 @@ -14,8 +14,8 @@ top_builddir = ../../../..
  include $(top_builddir)/src/Makefile.global
  
@@ -11,4 +11,4 @@ $OpenBSD: patch-src_interfaces_ecpg_comp
 +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR}
  
  override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include 
\
-   -I$(libpq_srcdir) -I

Re: prosody with mysql clarification

2016-02-12 Thread Henrik Friedrichsen
Hey,

On Thu, Feb 11, 2016 at 10:18:08PM -0800, Stephen Graf wrote:
> When I tried to set up prosody with sql storage using mysql I followed the
> instructions in the package and added luadbi-mysql.  However prosody did not
> seem to pick up on it even though the prosody documentation says that
> nothing more is required.  When I looked into what luadbi-mysql provided I
> discovered a c library, dbdmysql.so. How is this converted to a lua file
> that prosody can use?
> 

I'm not sure this is something that this is an explicit OpenBSD/ports
problem. Please double-check your configuration and also your logs. Your
information is very sparse.

Lua DBI is a library that is loaded via binary/native interfaces and not
written in Lua but C. This is entirely possible without "converting" it
to a Lua file.



Re: sysutils/ntfs-3g update

2016-02-12 Thread Paul Irofti
You should have started a new thread instead of replying to a year old
email :-)

On Thu, Feb 11, 2016 at 05:45:53PM +0500, dmitry.sensei wrote:
> Latest ntfs-3g (may be or fuse) break my filsystem.
> Case 1: #ntfs-3g /dev/sd1i /mnt
> Many work. ps. ls /mnt - no such directory :(

I don't understand what you mean by this. Is it that most of the times
it works but sometimes you get /mnt no such file or directory?

> Case 2: OpenBSD 5.9 1870 freeze during ntfs-3g
> How I can trace/find problem?

Anything in the logs? If you're trying this from X, switch back to
console and try it from there to see if you get dropped into ddb.



Re: is hedgewars broken?

2016-02-12 Thread Antoine Jacoutot
On Fri, Feb 12, 2016 at 03:22:44PM +0100, Pascal Stumpf wrote:
> Works for me, and there's a snapshot package from Feb 11.  Is hs-dataenc
> installed?  It needed to be revived from the Attic iirc, so I might have

Yeah it's installed.


> fucked the process up ...
> 
> On Fri, 12 Feb 2016 08:43:49 +0100, Antoine Jacoutot wrote:
> > >>> Running patch in games/hedgewars,-main at 1455212037
> > ===> games/hedgewars,-main
> > ===>  Checking files for hedgewars-src-0.9.22
> > `/exopi-cvs/ports/distfiles/hedgewars-src-0.9.22.tar.bz2' is up to date.
> > ===>  Extracting for hedgewars-src-0.9.22
> > ===>  Patching for hedgewars-src-0.9.22
> > >>> Running configure in games/hedgewars,-main at 1455212086
> > ===> games/hedgewars,-main
> > ===>  Configuring for hedgewars-src-0.9.22
> > -- The C compiler identification is GNU 4.2.1
> > -- The CXX compiler identification is GNU 4.2.1
> > -- Check for working C compiler: /usr/bin/cc
> > -- Check for working C compiler: /usr/bin/cc -- works
> > -- Detecting C compiler ABI info
> > -- Detecting C compiler ABI info - done
> > -- Detecting C compile features
> > -- Detecting C compile features - done
> > -- Check for working CXX compiler: /usr/bin/c++
> > -- Check for working CXX compiler: /usr/bin/c++ -- works
> > -- Detecting CXX compiler ABI info
> > -- Detecting CXX compiler ABI info - done
> > -- Detecting CXX compile features
> > -- Detecting CXX compile features - done
> > -- Building 0.9.22-r11265 (4c4f22cc3fa4)
> > -- Performing Test HAVE_STACKPROTECTOR
> > -- Performing Test HAVE_STACKPROTECTOR - Success
> > -- Performing Test HAVE_VISIBILITY
> > -- Performing Test HAVE_VISIBILITY - Success
> > -- Performing Test HAVE_NOEXECSTACK
> > -- Performing Test HAVE_NOEXECSTACK - Success
> > -- Performing Test HAVE_ORIGIN
> > -- Performing Test HAVE_ORIGIN - Success
> > -- Performing Test HAVE_RELROFULL
> > -- Performing Test HAVE_RELROFULL - Success
> > -- Performing Test HAVE_ASNEEDED
> > -- Performing Test HAVE_ASNEEDED - Success
> > -- Using RELEASE configuration
> > -- Found GHC: /usr/local/bin/ghc  
> > -- Looking for mask in Control.Exception
> > -- Looking for mask in Control.Exception - found
> > -- Looking for size in Data.Map
> > -- Looking for size in Data.Map - found
> > -- Looking for length in Data.Vector
> > -- Looking for length in Data.Vector - found
> > -- Looking for pack in Data.ByteString
> > -- Looking for pack in Data.ByteString - found
> > -- Looking for putDigit in Text.Show.ByteString
> > -- Looking for putDigit in Text.Show.ByteString - found
> > -- Looking for getHostName in Network.BSD
> > -- Looking for getHostName in Network.BSD - found
> > -- Looking for getCurrentTime in Data.Time
> > -- Looking for getCurrentTime in Data.Time - found
> > -- Looking for fix in Control.Monad.State
> > -- Looking for fix in Control.Monad.State - found
> > -- Looking for encode in Codec.Binary.Base64
> > -- Looking for encode in Codec.Binary.Base64 - not found
> > CMake Error at cmake_modules/CheckHaskellModuleExists.cmake:49 (message):
> >   Haskell library 'dataenc' required
> > Call Stack (most recent call first):
> >   gameServer/CMakeLists.txt:16 (check_haskell_module_exists)
> > 
> > 
> > -- Configuring incomplete, errors occurred!
> > See also 
> > "/exopi-obj/pobj/hedgewars-src-0.9.22/build-amd64/CMakeFiles/CMakeOutput.log".
> > See also 
> > "/exopi-obj/pobj/hedgewars-src-0.9.22/build-amd64/CMakeFiles/CMakeError.log".
> > *** Error 1 in games/hedgewars 
> > (/exopi-cvs/ports/infrastructure/mk/bsd.port.mk:2750 
> > '/exopi-obj/pobj/hedgewars-src-0.9.22/build-amd64/.configure_done')
> > *** Error 1 in games/hedgewars 
> > (/exopi-cvs/ports/infrastructure/mk/bsd.port.mk:2495 'configure')
> > ===> Exiting games/hedgewars,-main with an error
> > *** Error 1 in /exopi-cvs/ports (infrastructure/mk/bsd.port.subdir.mk:147 
> > 'configure')
> > Error: job failed 256
> > 
> > 
> > 
> > 
> > -- 
> > Antoine
> > 
> > 
> 

-- 
Antoine



Re: is hedgewars broken?

2016-02-12 Thread Pascal Stumpf
Works for me, and there's a snapshot package from Feb 11.  Is hs-dataenc
installed?  It needed to be revived from the Attic iirc, so I might have
fucked the process up ...

On Fri, 12 Feb 2016 08:43:49 +0100, Antoine Jacoutot wrote:
> >>> Running patch in games/hedgewars,-main at 1455212037
> ===> games/hedgewars,-main
> ===>  Checking files for hedgewars-src-0.9.22
> `/exopi-cvs/ports/distfiles/hedgewars-src-0.9.22.tar.bz2' is up to date.
> ===>  Extracting for hedgewars-src-0.9.22
> ===>  Patching for hedgewars-src-0.9.22
> >>> Running configure in games/hedgewars,-main at 1455212086
> ===> games/hedgewars,-main
> ===>  Configuring for hedgewars-src-0.9.22
> -- The C compiler identification is GNU 4.2.1
> -- The CXX compiler identification is GNU 4.2.1
> -- Check for working C compiler: /usr/bin/cc
> -- Check for working C compiler: /usr/bin/cc -- works
> -- Detecting C compiler ABI info
> -- Detecting C compiler ABI info - done
> -- Detecting C compile features
> -- Detecting C compile features - done
> -- Check for working CXX compiler: /usr/bin/c++
> -- Check for working CXX compiler: /usr/bin/c++ -- works
> -- Detecting CXX compiler ABI info
> -- Detecting CXX compiler ABI info - done
> -- Detecting CXX compile features
> -- Detecting CXX compile features - done
> -- Building 0.9.22-r11265 (4c4f22cc3fa4)
> -- Performing Test HAVE_STACKPROTECTOR
> -- Performing Test HAVE_STACKPROTECTOR - Success
> -- Performing Test HAVE_VISIBILITY
> -- Performing Test HAVE_VISIBILITY - Success
> -- Performing Test HAVE_NOEXECSTACK
> -- Performing Test HAVE_NOEXECSTACK - Success
> -- Performing Test HAVE_ORIGIN
> -- Performing Test HAVE_ORIGIN - Success
> -- Performing Test HAVE_RELROFULL
> -- Performing Test HAVE_RELROFULL - Success
> -- Performing Test HAVE_ASNEEDED
> -- Performing Test HAVE_ASNEEDED - Success
> -- Using RELEASE configuration
> -- Found GHC: /usr/local/bin/ghc  
> -- Looking for mask in Control.Exception
> -- Looking for mask in Control.Exception - found
> -- Looking for size in Data.Map
> -- Looking for size in Data.Map - found
> -- Looking for length in Data.Vector
> -- Looking for length in Data.Vector - found
> -- Looking for pack in Data.ByteString
> -- Looking for pack in Data.ByteString - found
> -- Looking for putDigit in Text.Show.ByteString
> -- Looking for putDigit in Text.Show.ByteString - found
> -- Looking for getHostName in Network.BSD
> -- Looking for getHostName in Network.BSD - found
> -- Looking for getCurrentTime in Data.Time
> -- Looking for getCurrentTime in Data.Time - found
> -- Looking for fix in Control.Monad.State
> -- Looking for fix in Control.Monad.State - found
> -- Looking for encode in Codec.Binary.Base64
> -- Looking for encode in Codec.Binary.Base64 - not found
> CMake Error at cmake_modules/CheckHaskellModuleExists.cmake:49 (message):
>   Haskell library 'dataenc' required
> Call Stack (most recent call first):
>   gameServer/CMakeLists.txt:16 (check_haskell_module_exists)
> 
> 
> -- Configuring incomplete, errors occurred!
> See also 
> "/exopi-obj/pobj/hedgewars-src-0.9.22/build-amd64/CMakeFiles/CMakeOutput.log".
> See also 
> "/exopi-obj/pobj/hedgewars-src-0.9.22/build-amd64/CMakeFiles/CMakeError.log".
> *** Error 1 in games/hedgewars 
> (/exopi-cvs/ports/infrastructure/mk/bsd.port.mk:2750 
> '/exopi-obj/pobj/hedgewars-src-0.9.22/build-amd64/.configure_done')
> *** Error 1 in games/hedgewars 
> (/exopi-cvs/ports/infrastructure/mk/bsd.port.mk:2495 'configure')
> ===> Exiting games/hedgewars,-main with an error
> *** Error 1 in /exopi-cvs/ports (infrastructure/mk/bsd.port.subdir.mk:147 
> 'configure')
> Error: job failed 256
> 
> 
> 
> 
> -- 
> Antoine
> 
> 



Re: why no php modules for ap2 flavor?

2016-02-12 Thread Stuart Henderson
On 2016/02/12 09:04, Jiri B wrote:
> Hi,
> 
> why don't we build php modules for ap2 flavor?
> 
> revision 1.35
> date: 2012/11/30 12:56:02;  author: sthen;  state: Exp;  lines: +5 -1;
> For the ap2 flavour, strip the unwanted subpackages from MULTI_PACKAGES rather
> than BUILD_PACKAGES (which is for pseudo-flavours). Reported by naddy.
> 
> j.

You don't need different modules for -ap2.



why no php modules for ap2 flavor?

2016-02-12 Thread Jiri B
Hi,

why don't we build php modules for ap2 flavor?

revision 1.35
date: 2012/11/30 12:56:02;  author: sthen;  state: Exp;  lines: +5 -1;
For the ap2 flavour, strip the unwanted subpackages from MULTI_PACKAGES rather
than BUILD_PACKAGES (which is for pseudo-flavours). Reported by naddy.

j.



Re: MariaDB default IP address binding

2016-02-12 Thread Giovanni Bechis
On 02/11/16 23:48, Stuart Henderson wrote:
[...] 
> I chose bind-address for two reasons.
> 
> 1) it looks like Debian used to have skip-networking and changed it:
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> 
> (I think this is possibly even more important with our default chroot).
> 
> 2) people may just try and remove the 'skip-networking' to allow
> it to be accessible from other hosts, and then get very confused
> because it only listens to :: and not 0.0.0.0.
> 
> Updated diff to make 2) clearer.
> 
ok giovanni@



Re: MariaDB default IP address binding

2016-02-12 Thread Pierre-Emmanuel André
On Thu, Feb 11, 2016 at 10:48:33PM +, Stuart Henderson wrote:
> On 2016/02/11 16:46, David Hill wrote:
> > On Thu, Feb 11, 2016 at 01:21:40PM -0800, Bryce Chidester wrote:
> > > What about shipping with skip-networking instead? I use this on all (just 
> > > 2
> > > - I'm a Postgres guy now) of my installs without issue. As memory serves,
> > > libmysqlclient defaults to trying the socket first when connecting to
> > > "localhost." Furthermore, this ensures that it's never accidentally made
> > > publicly available, at least not out of the box.
> > > 
> > > Regards,
> > > Bryce Chidester
> > > br...@cobryce.com
> > 
> > prefer skip-networking as default.  Will also be happy with
> > bind-address=127.0.0.1. 
> > 
> 
> I chose bind-address for two reasons.
> 
> 1) it looks like Debian used to have skip-networking and changed it:
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> 
> (I think this is possibly even more important with our default chroot).
> 
> 2) people may just try and remove the 'skip-networking' to allow
> it to be accessible from other hosts, and then get very confused
> because it only listens to :: and not 0.0.0.0.
> 
> Updated diff to make 2) clearer.
>

ok with me.



Re: www/awl size mismatch

2016-02-12 Thread Stuart Henderson
On 2016/02/11 23:45, Michael McConville wrote:
> Below is a failed fetch log for www/awl. Is this a known issue? Or is it
> just me? It's been failing because of this for the 3-4 weeks that I've
> been running bulk builds.

gitlab will be generating tarballs on the fly and either they have
updated some software causing the files to be different, or someone has
committed something else on the r0.55 tag on awl. Former is probably
more likely in this case.

I'll have a look in a bit and mirror the old distfile.

> Requesting 
> http://ftp.fr.openbsd.org/pub/OpenBSD/distfiles//archive.tar.gz?ref=r0.55
> ftp: Error retrieving file: 404 Not Found

This is possibly fixable in bsd.port.mk though a bit complicated.
It should be using the "local" filename, e.g. awl-0.55.tar.gz, when
fetching from the backup servers.