Ports Postgresql96 issue

[ryan.low]

Good day,
We trying to make install postgresql in latest released and we hit the issue below,

===> Building/installing dialog4ports as it is required for the config dialog
===>  Cleaning for dialog4ports-0.1.6
===> Skipping 'config' as NO_DIALOG is defined
/!\ ERROR: /!\

Ports Collection support for your FreeBSD version has ended, and no ports are
guaranteed to build on this system. Please upgrade to a supported release.

No support will be provided if you silence this message by defining
ALLOW_UNSUPPORTED_SYSTEM.

*** Error code 1

Stop.
make[3]: stopped in /usr/ports/ports-mgmt/dialog4ports
*** Error code 1

Stop.
make[2]: stopped in /usr/ports/ports-mgmt/dialog4ports
===> Options unchanged
/!\ ERROR: /!\

Ports Collection support for your FreeBSD version has ended, and no ports are
guaranteed to build on this system. Please upgrade to a supported release.

No support will be provided if you silence this message by defining
ALLOW_UNSUPPORTED_SYSTEM.

*** Error code 1

====================

After research, need to set ALLOW_UNSUPPORTED_SYSTEM="YES" in make.conf. trying luck now.

Option 2:
I did tried enabled the FreeBSD repos and do pkg install postgresql96-server, it crash with devel/icu, and not allow to start the service.

Regards.

[mimugmail]

Or you wait about 3 weeks fro 18.1 which will come with FreeBSD 11.1

[franco]

FreeBSD's EoL policy is pretty good for end users, not so much for vendors.

This will fix it by installing an appropriate /etc/make.conf which disables the unsupported error and provides other build options which you need anyway.

# opnsense-code tools


Cheers,
Franco

[ryan.low]

hi,
it works after i modified set ALLOW_UNSUPPORTED_SYSTEM="YES" in make.conf.

I rebuild the opnsense in php70 and and successfully install the ports
postgresql95-server php70-tokenizer php70-mbstring php70-pdo_pgsql php70-pgsql php70-gd php70-zip

May I know how to set the in the tools config, so I can pre-build these packages in the image?

Thanks.

[franco]

Why do you downgrade PHP to 7.0 ? I mean you are free to do so, but keep in mind that we only support 7.1 at this point and we don't know if / when that will break.


Cheers,
Franco

[ryan.low]

Why do you downgrade PHP to 7.0 ? I mean you are free to do so, but keep in mind that we only support 7.1 at this point and we don't know if / when that will break.


Cheers,
Franco

Because previously i'm using FreeBSD repo to install the package above. some package conflicting between php70 and php71. since now i able to compile the package manually using ports, i will rebuild with php71 again.

But is that the right file i need to edit if i want to build the package directly into the image.
/usr/tools/config/17.7/ports.conf

Regards,
Ryan

[franco]

Hi Ryan,

Yes, add the packages to ports.conf, build the images, but set ADDITIONS="your extra packages one by one" or register them as core or a plugin dependency, whichever works best.


Cheers,
Franco

[ryan.low]

hi franco,
# make step ADDITIONS="postgresql95-server"
make: don't know how to make step. Stop
make: stopped in /usr/tools

I tried
#make ports-postgresql95-server

and i notice the package will be removed.

Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 8 packages:

Installed packages to be REMOVED:
        gmake-4.2.1_1
        readline-7.0.3_1
        postgresql95-client-9.5.10
        postgresql95-server-9.5.10
        indexinfo-0.3.1
        libxml2-2.9.7
        openssl-1.0.2n,1
        perl5-5.24.3

Number of packages to be removed: 8

The operation will free 90 MiB.
[1/8] Deinstalling postgresql95-server-9.5.10...
[1/8] Deleting files for postgresql95-server-9.5.10: 100%
==> You should manually remove the "pgsql" user.
==> You should manually remove the "pgsql" group
[2/8] Deinstalling postgresql95-client-9.5.10...
[2/8] Deleting files for postgresql95-client-9.5.10: 100%
[3/8] Deinstalling gmake-4.2.1_1...
[3/8] Deleting files for gmake-4.2.1_1: 100%
[4/8] Deinstalling readline-7.0.3_1...
[4/8] Deleting files for readline-7.0.3_1: 100%
[5/8] Deinstalling indexinfo-0.3.1...
[5/8] Deleting files for indexinfo-0.3.1: 100%
[6/8] Deinstalling libxml2-2.9.7...
[6/8] Deleting files for libxml2-2.9.7: 100%
[7/8] Deinstalling openssl-1.0.2n,1...
[7/8] Deleting files for openssl-1.0.2n,1: 100%
[8/8] Deinstalling perl5-5.24.3...
[8/8] Deleting files for perl5-5.24.3: 100%

which part do i did wrong?

Regards
Ryan

[franco]

Hi Ryan.

Er... both, but no worries:

1. "step" is actually one of the image steps (vga, serial, nano, dvd, etc.)
2. ports-packagename forces a rebuild of "packagename" so yes it is deleted but therefore rebuilt afterwards.


Cheers,
Franco