Snag in upgrading p5-XML-SAX and p5-XML-SAX-Base

[Thomas Mueller]

> No -- you only ever need to run pkg2ng once.

> /usr/bin/pkg will invoke /usr/local/bin/pkg automatically if
> /usr/local/bin/pkg is installed -- /usr/bin/pkg is a shim that exists to
> facilitate the installation of the actual /usr/local/bin/pkg binary.
> That's all normal.

> Now, the real problem: not seeing the contents of the local package
> database.  Can you check a few things:

>    1) That PKG_DBDIR isn't defined in your environment or in
>       /usr/local/etc/pkg.conf  (or if it is, it is set to an
>       appropriate directory.)

>    2) That /var/db/pkg/local.sqlite exists and has these permissions
>       and ownership:

> % ls -l /var/db/pkg/local.sqlite
> -rw-r--r--  1 root  wheel  4041728 Oct 14 17:52 /var/db/pkg/local.sqlite

>       (The size will be different depending on what packages are
>       installed)

>    3) Try opening the local.sqlite database and investigating the
>       contents of one or more of the tables. Like so:

> # pkg shell
> SQLite version 3.7.14.1 2012-10-04 19:37:12
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> select count(*) from packages ;
> 47
> sqlite> .quit

>        If that returns zero then something has wiped your package DB.
> You may be able to recover from a backup copy of local.sqlite that the
> daily periodic jobs creates in /var/backups/pkgng.db --  just copy that
> back to /var/db/pkg/local.sqlite and try again.

>     4) If there is content in local.sqlite, then try using 'pkg info' to
> query the contents.  This should print out just about everything pkgng
> knows about what is installed on your system:

>     % pkg info -fa

>         Cheers,

>         Matthew

> --
> Dr Matthew J Seaman MA, D.Phil.
> PGP: http://www.infracaninophile.co.uk/pgpkey

Actually, I find pkg in sbin directory as opposed to bin:
/usr/sbin/pkg and /usr/local/sbin/pkg .

I followed your steps 1 to 4, found 638 packages, found the correct
permissions, and pkg info seemed to work correctly.

Now I wonder if the problem is fixed.

Tom