On 2013-06-28 09:24:38 +0200, Mark Rotteveel wrote:

> On Thu, 27 Jun 2013 17:56:30 -0300, Leonardo M. Ramé <l.rame@...>
> wrote:
> > On 2013-06-27 14:21:15 -0300, Leonardo M. Ramé wrote:
> >> Hi, I've updated Firebird 2.5 on a FreeBsd 9.1 server. Usually I
> restore
> >> my databases using:
> >>
> >> gbak -c -v -REP -user USER -password PASSWORD bkp.ib database
> >>
> >> But, after the upgrade I'm getting this:
> >>
> >> gbak:restoring.................
> >> ...............................
> >> gbak: committing metadata
> >> gbak: ERROR:unsuccessful metadata update
> >> gbak: ERROR: TABLE
> >> gbak: ERROR: CHARACTER SET WIN1252 is not installed
> >> gbak:Exiting before completion due to errors
> >>
> >> Why CHARACTER SER WIN1252 is not installed? how can I install it?.
> >>
> >
> > More info. Deinstalled everything and installed it again using:
> >
> > sudo pkg install firebird-server-2.5.2_1
> >
> > I noted the file /usr/local/etc/firebird/fbintl.conf contains info about
> > character sets.
> >
> > This file has the lines:
> >
> > <intl_module fbintl>
> > filename $(this)/intl
> > icu_versions default
> > </intl_module>
> >
> > Where the variable "$(this)" is pointing?. I have the fbintl in the
> > directory /usr/local/libexec/firebird/intl owned by "root". Is this
> > correct?, I've tested changing it to firebird:firebird, but the errror
> > still persists.
> >
> > BTW, I can connect to databases without problems. The only thing I can't
> > do is restore this database.
>
> What do you see if you start ISQL and execute:
> show system collation;

Here's the output:

SQL> show system collation;
ASCII, CHARACTER SET ASCII, PAD SPACE, SYSTEM
BIG_5, CHARACTER SET BIG_5, PAD SPACE, SYSTEM
BS_BA, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
CP943C, CHARACTER SET CP943C, PAD SPACE, SYSTEM
CP943C_UNICODE, CHARACTER SET CP943C, PAD SPACE, SYSTEM
CS_CZ, CHARACTER SET ISO8859_2, PAD SPACE, SYSTEM
CYRL, CHARACTER SET CYRL, PAD SPACE, SYSTEM
DA_DA, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
DB_CSY, CHARACTER SET DOS852, PAD SPACE, SYSTEM
DB_DAN865, CHARACTER SET DOS865, PAD SPACE, SYSTEM
DB_DEU437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_DEU850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_ESP437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_ESP850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_FIN437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_FRA437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_FRA850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_FRC850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_FRC863, CHARACTER SET DOS863, PAD SPACE, SYSTEM
DB_ITA437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_ITA850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_NLD437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_NLD850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_NOR865, CHARACTER SET DOS865, PAD SPACE, SYSTEM
DB_PLK, CHARACTER SET DOS852, PAD SPACE, SYSTEM
DB_PTB850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_PTG860, CHARACTER SET DOS860, PAD SPACE, SYSTEM
DB_RUS, CHARACTER SET CYRL, PAD SPACE, SYSTEM
DB_SLO, CHARACTER SET DOS852, PAD SPACE, SYSTEM
DB_SVE437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_SVE850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_TRK, CHARACTER SET DOS857, PAD SPACE, SYSTEM
DB_UK437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_UK850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DB_US437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DB_US850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DE_DE, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
DOS437, CHARACTER SET DOS437, PAD SPACE, SYSTEM
DOS737, CHARACTER SET DOS737, PAD SPACE, SYSTEM
DOS775, CHARACTER SET DOS775, PAD SPACE, SYSTEM
DOS850, CHARACTER SET DOS850, PAD SPACE, SYSTEM
DOS852, CHARACTER SET DOS852, PAD SPACE, SYSTEM
DOS857, CHARACTER SET DOS857, PAD SPACE, SYSTEM
DOS858, CHARACTER SET DOS858, PAD SPACE, SYSTEM
DOS860, CHARACTER SET DOS860, PAD SPACE, SYSTEM
DOS861, CHARACTER SET DOS861, PAD SPACE, SYSTEM
DOS862, CHARACTER SET DOS862, PAD SPACE, SYSTEM
DOS863, CHARACTER SET DOS863, PAD SPACE, SYSTEM
DOS864, CHARACTER SET DOS864, PAD SPACE, SYSTEM
DOS865, CHARACTER SET DOS865, PAD SPACE, SYSTEM
DOS866, CHARACTER SET DOS866, PAD SPACE, SYSTEM
DOS869, CHARACTER SET DOS869, PAD SPACE, SYSTEM
DU_NL, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
EN_UK, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
EN_US, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
ES_ES, CHARACTER SET ISO8859_1, PAD SPACE,
'DISABLE-COMPRESSIONS=1;SPECIALS-FIRST=1', SYSTEM
ES_ES_CI_AI, CHARACTER SET ISO8859_1, PAD SPACE, CASE INSENSITIVE,
ACCENT INSENSITIVE, 'DISABLE-COMPRESSIONS=1;SPECIALS-FIRST=1', SYSTEM
EUCJ_0208, CHARACTER SET EUCJ_0208, PAD SPACE, SYSTEM
FI_FI, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
FR_CA, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
FR_FR, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
FR_FR_CI_AI, CHARACTER SET ISO8859_1, FROM EXTERNAL ('FR_FR'), PAD
SPACE, CASE INSENSITIVE, ACCENT INSENSITIVE, 'SPECIALS-FIRST=1', SYSTEM
GB18030, CHARACTER SET GB18030, PAD SPACE, SYSTEM
GB18030_UNICODE, CHARACTER SET GB18030, PAD SPACE, SYSTEM
GBK, CHARACTER SET GBK, PAD SPACE, SYSTEM
GBK_UNICODE, CHARACTER SET GBK, PAD SPACE, SYSTEM
GB_2312, CHARACTER SET GB_2312, PAD SPACE, SYSTEM
ISO8859_1, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
ISO8859_13, CHARACTER SET ISO8859_13, PAD SPACE, SYSTEM
ISO8859_2, CHARACTER SET ISO8859_2, PAD SPACE, SYSTEM
ISO8859_3, CHARACTER SET ISO8859_3, PAD SPACE, SYSTEM
ISO8859_4, CHARACTER SET ISO8859_4, PAD SPACE, SYSTEM
ISO8859_5, CHARACTER SET ISO8859_5, PAD SPACE, SYSTEM
ISO8859_6, CHARACTER SET ISO8859_6, PAD SPACE, SYSTEM
ISO8859_7, CHARACTER SET ISO8859_7, PAD SPACE, SYSTEM
ISO8859_8, CHARACTER SET ISO8859_8, PAD SPACE, SYSTEM
ISO8859_9, CHARACTER SET ISO8859_9, PAD SPACE, SYSTEM
ISO_HUN, CHARACTER SET ISO8859_2, PAD SPACE, SYSTEM
ISO_PLK, CHARACTER SET ISO8859_2, PAD SPACE, SYSTEM
IS_IS, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
IT_IT, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
KOI8R, CHARACTER SET KOI8R, PAD SPACE, SYSTEM
KOI8R_RU, CHARACTER SET KOI8R, PAD SPACE, SYSTEM
KOI8U, CHARACTER SET KOI8U, PAD SPACE, SYSTEM
KOI8U_UA, CHARACTER SET KOI8U, PAD SPACE, SYSTEM
KSC_5601, CHARACTER SET KSC_5601, PAD SPACE, SYSTEM
KSC_DICTIONARY, CHARACTER SET KSC_5601, PAD SPACE, SYSTEM
LT_LT, CHARACTER SET ISO8859_13, PAD SPACE, SYSTEM
NEXT, CHARACTER SET NEXT, PAD SPACE, SYSTEM
NONE, CHARACTER SET NONE, PAD SPACE, SYSTEM
NO_NO, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
NXT_DEU, CHARACTER SET NEXT, PAD SPACE, SYSTEM
NXT_ESP, CHARACTER SET NEXT, PAD SPACE, SYSTEM
NXT_FRA, CHARACTER SET NEXT, PAD SPACE, SYSTEM
NXT_ITA, CHARACTER SET NEXT, PAD SPACE, SYSTEM
NXT_US, CHARACTER SET NEXT, PAD SPACE, SYSTEM
OCTETS, CHARACTER SET OCTETS, PAD SPACE, SYSTEM
PDOX_ASCII, CHARACTER SET DOS437, PAD SPACE, SYSTEM
PDOX_CSY, CHARACTER SET DOS852, PAD SPACE, SYSTEM
PDOX_CYRL, CHARACTER SET CYRL, PAD SPACE, SYSTEM
PDOX_HUN, CHARACTER SET DOS852, PAD SPACE, SYSTEM
PDOX_INTL, CHARACTER SET DOS437, PAD SPACE, SYSTEM
PDOX_ISL, CHARACTER SET DOS861, PAD SPACE, SYSTEM
PDOX_NORDAN4, CHARACTER SET DOS865, PAD SPACE, SYSTEM
PDOX_PLK, CHARACTER SET DOS852, PAD SPACE, SYSTEM
PDOX_SLO, CHARACTER SET DOS852, PAD SPACE, SYSTEM
PDOX_SWEDFIN, CHARACTER SET DOS437, PAD SPACE, SYSTEM
PT_BR, CHARACTER SET ISO8859_1, PAD SPACE, CASE INSENSITIVE, ACCENT
INSENSITIVE, SYSTEM
PT_PT, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
PXW_CSY, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
PXW_CYRL, CHARACTER SET WIN1251, PAD SPACE, SYSTEM
PXW_GREEK, CHARACTER SET WIN1253, PAD SPACE, SYSTEM
PXW_HUN, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
PXW_HUNDC, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
PXW_INTL, CHARACTER SET WIN1252, PAD SPACE, SYSTEM
PXW_INTL850, CHARACTER SET WIN1252, PAD SPACE, SYSTEM
PXW_NORDAN4, CHARACTER SET WIN1252, PAD SPACE, SYSTEM
PXW_PLK, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
PXW_SLOV, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
PXW_SPAN, CHARACTER SET WIN1252, PAD SPACE, SYSTEM
PXW_SWEDFIN, CHARACTER SET WIN1252, PAD SPACE, SYSTEM
PXW_TURK, CHARACTER SET WIN1254, PAD SPACE, SYSTEM
SJIS_0208, CHARACTER SET SJIS_0208, PAD SPACE, SYSTEM
SV_SV, CHARACTER SET ISO8859_1, PAD SPACE, SYSTEM
TIS620, CHARACTER SET TIS620, PAD SPACE, SYSTEM
TIS620_UNICODE, CHARACTER SET TIS620, PAD SPACE, SYSTEM
UCS_BASIC, CHARACTER SET UTF8, PAD SPACE, SYSTEM
UNICODE, CHARACTER SET UTF8, PAD SPACE, SYSTEM
UNICODE_CI, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE,
CASE INSENSITIVE, SYSTEM
UNICODE_CI_AI, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE,
CASE INSENSITIVE, ACCENT INSENSITIVE, SYSTEM
UNICODE_FSS, CHARACTER SET UNICODE_FSS, PAD SPACE, SYSTEM
UTF8, CHARACTER SET UTF8, PAD SPACE, SYSTEM
WIN1250, CHARACTER SET WIN1250, PAD SPACE, SYSTEM
WIN1251, CHARACTER SET WIN1251, PAD SPACE, SYSTEM
WIN1251_UA, CHARACTER SET WIN1251, PAD SPACE, SYSTEM
WIN1252, CHARACTER SET WIN1252, PAD SPACE, SYSTEM
WIN1253, CHARACTER SET WIN1253, PAD SPACE, SYSTEM
WIN1254, CHARACTER SET WIN1254, PAD SPACE, SYSTEM
WIN1255, CHARACTER SET WIN1255, PAD SPACE, SYSTEM
WIN1256, CHARACTER SET WIN1256, PAD SPACE, SYSTEM
WIN1257, CHARACTER SET WIN1257, PAD SPACE, SYSTEM
WIN1257_EE, CHARACTER SET WIN1257, PAD SPACE, SYSTEM
WIN1257_LT, CHARACTER SET WIN1257, PAD SPACE, SYSTEM
WIN1257_LV, CHARACTER SET WIN1257, PAD SPACE, SYSTEM
WIN1258, CHARACTER SET WIN1258, PAD SPACE, SYSTEM
WIN_CZ, CHARACTER SET WIN1250, PAD SPACE, CASE INSENSITIVE, SYSTEM
WIN_CZ_CI_AI, CHARACTER SET WIN1250, PAD SPACE, CASE INSENSITIVE, ACCENT
INSENSITIVE, SYSTEM
WIN_PTBR, CHARACTER SET WIN1252, PAD SPACE, CASE INSENSITIVE, ACCENT
INSENSITIVE, SYSTEM


--
Leonardo M. Ramé
http://leonardorame.blogspot.com