undefined symbol error in qtbase

undefined symbol error in qtbase

[Hamzeh Nasajpour]

Hi,

I want to package `trojita` for GuixSD. I created a package definition and it was build and installed successfully. When I run it I get the following error:

```
/gnu/store/890yw9i7lcjnnxhlza8r121352xp1hi-qtbase-5.11.3/lib/qt5/plugins/sqldrivers/libqsqlite.so: undefined symbol: sqlite3_column_table_name16

```

`trojita` is a mail client application that has a dependency to `qtbase`. I see that in `qtbase` package definition there is `sqlite-with-column-metadata` as a dependency, Apparently all is ok but I don't know the reason of this error. Do you have any idea?

Links:
* `qtbase` package definition : https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n578
* `trojita` mail application : https://cgit.kde.org/trojita.git
*  `sqlite` additional methods/apis : https://www.sqlite.org/c3ref/column_database_name.html
*  `sqlite` package definition :  https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/sqlite.scm#n107


Regards,
Hamzeh

Re: undefined symbol error in qtbase

[swedebugia]

hi!

On 2019-08-06 13:58, Hamzeh Nasajpour wrote:
> Hi,
>
> I want to package `trojita` for GuixSD. I created a package definition and it was build and installed successfully. When I run it I get the following error:
>
> ```
> /gnu/store/890yw9i7lcjnnxhlza8r121352xp1hi-qtbase-5.11.3/lib/qt5/plugins/sqldrivers/libqsqlite.so: undefined symbol: sqlite3_column_table_name16
>
> ```
>
> `trojita` is a mail client application that has a dependency to `qtbase`. I see that in `qtbase` package definition there is `sqlite-with-column-metadata` as a dependency, Apparently all is ok but I don't know the reason of this error. Do you have any idea?
>
> Links:
> * `qtbase` package definition : https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n578
> * `trojita` mail application : https://cgit.kde.org/trojita.git
> *  `sqlite` additional methods/apis : https://www.sqlite.org/c3ref/column_database_name.html
> *  `sqlite` package definition :  https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/sqlite.scm#n107

Could you share your package definition also?


-- 
Cheers Swedebugia

Re: undefined symbol error in qtbase

[Hamzeh Nasajpour]

Hi, 

Thank you for follow up. This is the package definition for `trojita`. (inspired from https://github.com/NixOS/nixpkgs/blob/master/pkgs/applications/networking/mailreaders/trojita/default.nix)


```
(define-public trojita
  (package
    (name "trojita")
    (version "0.7.0.1")
    (source
     (origin
       (method git-fetch)
       (uri (git-reference
			 (url "https://github.com/KDE/trojita")
             (commit "c5b39f51693ab5616e61e2e9454a526287b7df8d")))
       (sha256
        (base32 "1g3mbpb8m6hivyj6pmgqxqvms3bizdwiiy4fagn4kqrspl9ssssr"))
       ))
    (build-system cmake-build-system)
    (arguments
      `(#:tests? #f))
    (inputs `(
              ("qtbase", qtbase)
              ("qtwebkit", qtwebkit)
			  ("qtsvg" ,qtsvg)))
    (native-inputs `(
	      ("pkg-config", pkg-config)
	      ("qttools",qttools)))
    (home-page "http://trojita.flaska.net")
    (synopsis "A Qt IMAP e-mail client")
    (description "A Qt IMAP e-mail client")
    (license license:gpl2)))
```

On Wed, Aug 7, 2019, at 1:32 AM, swedebugia wrote:
> hi!
> 
> On 2019-08-06 13:58, Hamzeh Nasajpour wrote:
> > Hi,
> >
> > I want to package `trojita` for GuixSD. I created a package definition and it was build and installed successfully. When I run it I get the following error:
> >
> > ```
> > /gnu/store/890yw9i7lcjnnxhlza8r121352xp1hi-qtbase-5.11.3/lib/qt5/plugins/sqldrivers/libqsqlite.so: undefined symbol: sqlite3_column_table_name16
> >
> > ```
> >
> > `trojita` is a mail client application that has a dependency to `qtbase`. I see that in `qtbase` package definition there is `sqlite-with-column-metadata` as a dependency, Apparently all is ok but I don't know the reason of this error. Do you have any idea?
> >
> > Links:
> > * `qtbase` package definition : https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n578
> > * `trojita` mail application : https://cgit.kde.org/trojita.git
> > *  `sqlite` additional methods/apis : https://www.sqlite.org/c3ref/column_database_name.html
> > *  `sqlite` package definition :  https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/sqlite.scm#n107
> 
> Could you share your package definition also?
> 
> 
> -- 
> Cheers Swedebugia
>

Re: undefined symbol error in qtbase

[Ricardo Wurmus]

Hi Hamzeh,

> This is the package definition for `trojita` […]

I copied this to the bottom of qt.scm (didn’t want to have to adjust any
module imports) and built it just fine.

So it looks like nothing’s wrong.

I used the latest git checkout of Guix from the “master” branch.
Perhaps you’re using an older version?

--
Ricardo

Re: undefined symbol error in qtbase

[Ricardo Wurmus]

Ricardo Wurmus <rekado@elephly.net> writes:

>> This is the package definition for `trojita` […]
>
> I copied this to the bottom of qt.scm (didn’t want to have to adjust any
> module imports) and built it just fine.
>
> So it looks like nothing’s wrong.

Ah, well, the problem is with running the executable.

The problem appears to be that qtbase contains references to both sqlite
and sqlite-with-column-metadata.  It should contain references to only
one of the two, preferably the one with column metadata.

-- 
Ricardo

Re: undefined symbol error in qtbase

[Hamzeh Nasajpour]

On Wed, Aug 7, 2019, at 4:04 PM, Ricardo Wurmus wrote:
> 
> Ricardo Wurmus <rekado@elephly.net> writes:
> 
> >> This is the package definition for `trojita` […]
> >
> > I copied this to the bottom of qt.scm (didn’t want to have to adjust any
> > module imports) and built it just fine.
> >
> > So it looks like nothing’s wrong.
> 
> Ah, well, the problem is with running the executable.
> 
> The problem appears to be that qtbase contains references to both sqlite
> and sqlite-with-column-metadata.  It should contain references to only
> one of the two, preferably the one with column metadata.
> 
> -- 
> Ricardo
> 
>

Hi Ricardo,

Thanks for quick reply.

Yes, exactly, the problem is in running with this error:
> trojita: symbol lookup error: /gnu/store/890yw9i7lcjnnxhlza8r121352xp1hi-qtbase-5.11.3/lib/qt5/plugins/sqldrivers/libqsqlite.so: undefined symbol: sqlite3_column_table_name16

What's your idea/solution for it?

Regards,
Hamzeh

Re: undefined symbol error in qtbase

[Hamzeh Nasajpour]

Hi Ricardo,

> The problem appears to be that qtbase contains references to both sqlite
> and sqlite-with-column-metadata.  It should contain references to only
> one of the two, preferably the one with column metadata.

Seems that `qtbase` has only one dependency to `sqlite-with-column-metadata` here:
https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n578

Did you see the `qtbase` package definition? I don't see `sqlite` in it's package definition.

Regards,
Hamzeh

On Wed, Aug 7, 2019, at 4:13 PM, Hamzeh Nasajpour wrote:
> 
> 
> On Wed, Aug 7, 2019, at 4:04 PM, Ricardo Wurmus wrote:
> > 
> > Ricardo Wurmus <rekado@elephly.net> writes:
> > 
> > >> This is the package definition for `trojita` […]
> > >
> > > I copied this to the bottom of qt.scm (didn’t want to have to adjust any
> > > module imports) and built it just fine.
> > >
> > > So it looks like nothing’s wrong.
> > 
> > Ah, well, the problem is with running the executable.
> > 
> > The problem appears to be that qtbase contains references to both sqlite
> > and sqlite-with-column-metadata.  It should contain references to only
> > one of the two, preferably the one with column metadata.
> > 
> > -- 
> > Ricardo
> > 
> >
> 
> Hi Ricardo,
> 
> Thanks for quick reply.
> 
> Yes, exactly, the problem is in running with this error:
> > trojita: symbol lookup error: /gnu/store/890yw9i7lcjnnxhlza8r121352xp1hi-qtbase-5.11.3/lib/qt5/plugins/sqldrivers/libqsqlite.so: undefined symbol: sqlite3_column_table_name16
> 
> What's your idea/solution for it?
> 
> Regards,
> Hamzeh
> 
>

Re: undefined symbol error in qtbase

[Ricardo Wurmus]

Hamzeh Nasajpour <h.nasajpour@pantherx.org> writes:

>> The problem appears to be that qtbase contains references to both sqlite
>> and sqlite-with-column-metadata.  It should contain references to only
>> one of the two, preferably the one with column metadata.
>
> Seems that `qtbase` has only one dependency to `sqlite-with-column-metadata` here:
> https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n578
>
> Did you see the `qtbase` package definition? I don't see `sqlite` in it's package definition.

I wrote “references”; I meant the qtbase package closure.  When you look
at “guix graph” for qtbase you’ll find other users of “sqlite”.

-- 
Ricardo

Re: undefined symbol error in qtbase

[Hamzeh Nasajpour]

Hi Ricardo,

Thanks for your help.

Now I repackage the `qtbase` and remove the `sqlite` from this line:
https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n536

The problem resolved and the `trojita` installed and run successfully. 

Regards,
Hamzeh


On Thu, Aug 8, 2019, at 12:42 PM, Ricardo Wurmus wrote:
> 
> Hamzeh Nasajpour <h.nasajpour@pantherx.org> writes:
> 
> >> The problem appears to be that qtbase contains references to both sqlite
> >> and sqlite-with-column-metadata.  It should contain references to only
> >> one of the two, preferably the one with column metadata.
> >
> > Seems that `qtbase` has only one dependency to `sqlite-with-column-metadata` here:
> > https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n578
> >
> > Did you see the `qtbase` package definition? I don't see `sqlite` in it's package definition.
> 
> I wrote “references”; I meant the qtbase package closure.  When you look
> at “guix graph” for qtbase you’ll find other users of “sqlite”.
> 
> -- 
> Ricardo
> 
>

Re: undefined symbol error in qtbase

[Ricardo Wurmus]

Hamzeh Nasajpour <h.nasajpour@pantherx.org> writes:

> Now I repackage the `qtbase` and remove the `sqlite` from this line:
> https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/qt.scm#n536

This would cause Qt to be built with a bundled variant of sqlite.

This doesn’t look like a solution we can adopt.

-- 
Ricardo