Bug 173889 - [NEW PORT] www/kannel-sqlbox: SQL interface for Kannel
Summary: [NEW PORT] www/kannel-sqlbox: SQL interface for Kannel
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Rodrigo Osorio
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-24 05:30 UTC by Alberto Mijares
Modified: 2015-06-08 21:26 UTC (History)
2 users (show)

See Also:


Attachments
file.shar (4.28 KB, text/plain)
2012-11-24 05:30 UTC, Alberto Mijares
no flags Details
kannel-sqlbox-shar (4.71 KB, text/plain)
2015-06-06 19:07 UTC, Danilo G. Baio
no flags Details
kannel-1.4.4_1_svn_diff (487 bytes, patch)
2015-06-06 19:07 UTC, Danilo G. Baio
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Alberto Mijares 2012-11-24 05:30:00 UTC
        This is a port for the kannel' addon for sql interface
Comment 1 Edwin Groothuis freebsd_committer freebsd_triage 2012-11-24 05:30:08 UTC
Class Changed
From-To: update->change-request

Fix category (new ports should be change-requests) (via the GNATS Auto 
Assign Tool)
Comment 2 Florian Smeets freebsd_committer freebsd_triage 2012-11-24 09:58:30 UTC
Responsible Changed
From-To: freebsd-ports-bugs->flo

I'll take it.
Comment 3 Carlo Strub freebsd_committer freebsd_triage 2014-08-29 22:21:30 UTC
back to pool -- timeout
Comment 4 Kubilay Kocak freebsd_committer freebsd_triage 2014-09-06 02:34:49 UTC
This issue needs its patch updated, at least for the following items:

* Needs to add STAGE support
* PORTVERSION is 'devel', needs to be a number
* USE_GMAKE is deprecated (USES=gmake)
& pre-configure: bootstrap should be replaced with USES=autotools and USE_AUTOTOOLS functions

Additionally:

 * Successful poudriere or redports build logs
 * portlint -AC output
Comment 5 Rodrigo Osorio freebsd_committer freebsd_triage 2014-12-24 12:42:01 UTC
@amijaresp : still interested by this port ? Need help to rework the submission ?
Comment 6 Alberto Mijares 2015-05-23 22:59:11 UTC
Ok, I'll retake the submission
Comment 7 Rodrigo Osorio freebsd_committer freebsd_triage 2015-05-27 20:38:49 UTC
Few remarks :
- distfile is missing in the repo
- please let me know the revision (release?) you are using
- add license stuff (see www/kanel as an example)

And last but not the least, it would be great if you can add a poudriere
build log.
Comment 8 Danilo G. Baio freebsd_committer freebsd_triage 2015-06-06 19:07:15 UTC
Created attachment 157480 [details]
kannel-sqlbox-shar
Comment 9 Danilo G. Baio freebsd_committer freebsd_triage 2015-06-06 19:07:55 UTC
Created attachment 157481 [details]
kannel-1.4.4_1_svn_diff
Comment 10 Danilo G. Baio freebsd_committer freebsd_triage 2015-06-06 19:08:27 UTC
Hello Alberto and Rodrigo.

As I explained by e-mail, will be need to update www/kannel. Could I send the patch on this PR or is better open a new one ?

First, a patch to www/kannel (set MYSQL for default).

A shar file for www/kannel-sqlbox.
- portlint compliant.
- staged
- license ok
- set me as maintainer and alberto as co-maintainer.


Here are the tests with poudriere:

[kannel-sqlbox]

FreeBSD 10.1 (i386)
http://dbaio.bs2cloud.com.br/poudriere/data/101i386-ports_dbaio/2015-06-05_16h12m55s/logs/kannel-sqlbox-1.0.log

FreeBSD 10.1 (amd64)
http://dbaio.bs2cloud.com.br/poudriere/data/101amd64-ports_dbaio/2015-06-05_17h58m21s/logs/kannel-sqlbox-1.0.log

FreeBSD 11-CURRENT (amd64)
http://dbaio.bs2cloud.com.br/poudriere/data/11amd64-ports_dbaio/2015-06-05_17h06m32s/logs/kannel-sqlbox-1.0.log

FreeBSD 11-CURRENT (i386)
http://dbaio.bs2cloud.com.br/poudriere/data/11i386-ports_dbaio/2015-06-05_17h09m05s/logs/kannel-sqlbox-1.0.log


[kannel]

FreeBSD 10.1 (i386)
http://dbaio.bs2cloud.com.br/poudriere/data/101i386-ports_dbaio/2015-06-05_16h10m35s/logs/kannel-1.4.4_1,1.log

FreeBSD 10.1 (amd64)
http://dbaio.bs2cloud.com.br/poudriere/data/101amd64-ports_dbaio/2015-06-05_17h56m26s/logs/kannel-1.4.4_1,1.log

FreeBSD 11-CURRENT (amd64)
http://dbaio.bs2cloud.com.br/poudriere/data/11amd64-ports_dbaio/2015-06-05_16h17m07s/logs/kannel-1.4.4_1,1.log

FreeBSD 11-CURRENT (i386)
http://dbaio.bs2cloud.com.br/poudriere/data/11i386-ports_dbaio/2015-06-05_17h54m33s/logs/kannel-1.4.4_1,1.log


Best Regards.
Comment 11 Rodrigo Osorio freebsd_committer freebsd_triage 2015-06-06 23:15:29 UTC
great, I'll take a look.
Comment 12 Rodrigo Osorio freebsd_committer freebsd_triage 2015-06-07 15:01:21 UTC
@Danilo,

If you don't mind I prefer sqlite as a default option for kanel-sqlbox.
As a package, it pulls by default less dependencies and consume less disk space.
Comment 13 Danilo G. Baio freebsd_committer freebsd_triage 2015-06-08 00:01:16 UTC
Hello Rodrigo, thanks for your time.

I agree that with MySQL will be necessary more work on the build process, but kannel-sqlbox is mainly used to integrate any external system to your kannel interface by a database. Unless you have this other system on the same box, it's preferable use MySQL or PostgreSQL (connect by network).
I am more comfortable with MySQL if there is no problem.

Best Regards.
Comment 14 commit-hook freebsd_committer freebsd_triage 2015-06-08 21:15:55 UTC
A commit references this bug:

Author: rodrigo
Date: Mon Jun  8 21:15:50 UTC 2015
New revision: 388883
URL: https://svnweb.freebsd.org/changeset/ports/388883

Log:
  Update kannel to support a database by default, this is required by kannel-sqlbox

  PR:		173889
  Submitted by:	dbaio <dbaio@bsd.com.br> (maintainer)

Changes:
  head/www/kannel/Makefile
Comment 15 commit-hook freebsd_committer freebsd_triage 2015-06-08 21:25:57 UTC
A commit references this bug:

Author: rodrigo
Date: Mon Jun  8 21:25:26 UTC 2015
New revision: 388884
URL: https://svnweb.freebsd.org/changeset/ports/388884

Log:
  Add new port kannel-sqlbox
  co-maintained with Alberto Mijares <amijaresp@gmail.com>

  PR:		173889
  Submitted by:	dbaio <dbaio@bsd.com.br>

Changes:
  head/www/Makefile
  head/www/kannel-sqlbox/
  head/www/kannel-sqlbox/Makefile
  head/www/kannel-sqlbox/distinfo
  head/www/kannel-sqlbox/files/
  head/www/kannel-sqlbox/files/kannel_sqlbox.in
  head/www/kannel-sqlbox/files/patch-example_sqlbox.conf.example
  head/www/kannel-sqlbox/pkg-descr
  head/www/kannel-sqlbox/pkg-plist
Comment 16 Rodrigo Osorio freebsd_committer freebsd_triage 2015-06-08 21:26:38 UTC
Commited thanks