Headunit (Linux/Windows CarPC frontend) + initial screenshots - Page 8

cyber · 07-09-2004, 09:16 AM

I'm going to need a point in the right direction...I can't seem to get sqlite working. I have version 3.0.2 and unpacked and installed per the README.

Code:

tar zxvf sqlite-3.0.2.tar.gz
mkdir bld
cd bld
../sqlite/configure
make
su
make install

Then I created (touch media.db) an empty file to be used as the database and set up the configuration file accordingly. I can run sqlite3 alright so I know it installed and I ran ldconfig again for good measure but when I run headunit it gives me the following:

QSqlDatabase warning: QSQLITE driver not loaded
QSqlDatabase: available drivers: QMYSQL3

how do I add sqlite to the apparent list of availiable drivers?

mobileh1 · 07-09-2004, 04:22 PM

The sqlite plugin is not included in versions of QT prior to 3.3, so you will have to get the plugin and build that also or use mysql since you have that one.

mysql is really fast.. I mean really fast...

cyber · 07-09-2004, 04:54 PM

Sorry, I wasn't clear with my other packages...I'm using QT 3.3.2 maybe I'm doing something screwy when I installed QT? Heres the results of my qt ./configure with all the commandline options I'm using

Code:

default@nc:~/projects/qt-x11-free-3.3.2$ ./configure -sm -thread -stl -system-libjpeg -verbose -largefile \
>                 -qt-imgfmt-{jpeg,mng,png} -tablet -system-libmng \
>                 -system-libpng -lpthread -xft \
>                 -fast -plugin-sql-sqlite
IBASE auto-detection...
  Could not find libgds.* anywhere in /lib /usr/lib
IBASE disabled.
MySQL auto-detection...
  Found libmysqlclient.* in /usr/lib
  Could not find mysql.h anywhere in /usr/include
MySQL disabled.
ODBC auto-detection...
  Could not find libodbc.* anywhere in /lib /usr/lib
ODBC disabled.
PostgreSQL auto-detection...
  Could not find libpq.* anywhere in /lib /usr/lib
PostgreSQL disabled.
NIS auto-detection... ()
  Found nsl lib in /usr/lib
  Found rpcsvc/ypclnt.h in /usr/include
  Found rpcsvc/yp_prot.h in /usr/include
NIS enabled.
CUPS auto-detection... ()
  Found cups lib in /usr/lib
  Found cups/cups.h in /usr/include
CUPS enabled.
OpenGL auto-detection... ()
  Found GLU lib in /usr/X11R6/lib
  Found GL lib in /usr/X11R6/lib
  Found Xmu lib in /usr/X11R6/lib
  Found GL/gl.h in /usr/X11R6/include
  Found GL/glu.h in /usr/X11R6/include
OpenGL enabled.
Xcursor auto-detection... ()
  Found Xcursor lib in /usr/X11R6/lib
  Found X11/Xcursor/Xcursor.h in /usr/X11R6/include
  Found Xcursor version 1.1, version 1.0 required.
Xcursor disabled.
XRandR auto-detection... ()
  Found XRandR lib in /usr/X11R6/lib
  Found X11/extensions/Xrandr.h in /usr/X11R6/include
XRandR enabled.
XRender auto-detection... ()
  Found XRender lib in /usr/X11R6/lib
  Found X11/extensions/Xrender.h in /usr/X11R6/include
XRender enabled.
Xft auto-detection... ()
  Found libXft.a in /usr/X11R6/lib
  Found X11/Xft/Xft.h in /usr/X11R6/include
  Found X11/Xft/Xft.h in /usr/include
  Found Xft version 2.1.6
  Found Freetype version 2.1.8
  Found freetype2/freetype/freetype.h in /usr/include
  Found fontconfig/fontconfig.h in /usr/include
Xft enabled.
XShape auto-detection... ()
  Found X11/extensions/shape.h in /usr/X11R6/include
XShape enabled.
Xinerama auto-detection... ()
  Found Xinerama lib in /usr/X11R6/lib
  Found X11/extensions/Xinerama.h in /usr/X11R6/include
Xinerama enabled.
XKB auto-detection... ()
  Found X11/XKBlib.h in /usr/X11R6/include
  XkbSetPerClientControls found.
XKB enabled.

This is the Qt/X11 Free Edition.

You are licensed to use this software under the terms of either
the Q Public License (QPL) or the GNU General Public License (GPL).

Type 'Q' to view the Q Public License.
Type 'G' to view the GNU General Public License.
Type 'yes' to accept this license offer.
Type 'no' to decline this license offer.

Do you accept the terms of either license?

mobileh1 · 07-09-2004, 05:21 PM

you typed 'yes' and then make && make install (as root)..

Then it gave you the error about QSQLITE driver not found right?

Ok, if thats what happened, I'll repeat your steps and take a look...

cyber · 07-09-2004, 06:13 PM

actually QT itself didn't give me any errors...I only got the error about QSQLITE not being found when I tried to run headunit-0.1

NoPistonPC · 07-09-2004, 06:35 PM

Quote: Originally Posted by cyber

actually QT itself didn't give me any errors...I only got the error about QSQLITE not being found when I tried to run headunit-0.1

cyber make sure your have sqlite.h in your /usr/include and libsqlite.a in your /usr/lib. That means sqlite was installed properly. Also try changing the -plugin-sql-sqlite flag to -qt-sql-sqlite. That will compile in SQLite support directly into the qt library instead of a separate plugin.

also, you can compile the plugin separately like this:

http://doc.trolltech.com/3.3/sql-driver.html#QSQLITE
NOTE: you may have to change that qmake command to this one instead of the one they tell you to use:
qmake -o Makefile "LIBS+=-lsqlite"

if that fails, try copying this file into your /usr/qt/3/plugins/sqldrivers directory:

libqsqlite.so

If all else fails, then you can still use mysql like mobileh1 suggested. But, that would mean having to run a separate sql server process, etc...

mobileh1 · 07-09-2004, 11:43 PM

NoPiston has it pretty much covered there. I guess you are still having troubles.

I rpm --erase'd all the qt* packages,
then downloaded the source
configured it, as you did (cyber)

it built fine, then I did a make install, making sure I installed to the old $QTDIR.

By default FC2 installs to /ust/lib/qt-3-3, where as the source will build to /usr/local/qt

make sure you either change the install directory or change your QTDIR or simply copy the files from the source build area over FC2's area (basically each and every file/directory in /usr/lib/qt3-3).

This works fine, I just did the above (well a few hours ago because QT isnt the fastest thing to build).

I bet you have the plugin now, but not in the right place.

Do the following:

[daren@lewis daren]$ ls $QTDIR/plugins/sqldrivers/
libqsqlite.so libqsqlmysql.so libqsqlodbc.so libqsqlpsql.so

make sure you see libqsqlite.so, if you dont, have a look using:
find /usr -name libqsqlite.so -print

As NoPiston said, it all boils down to having the libqsqlite.so so that'll get you out of trouble.

I switched to sqlite to make sure there were no problems, its much slower than mysql, but perfectly fast enough. QT adds an enormous overhead to the database load though.

NoPiston (if your still reading this). Its much faster to have the sql written to a file, then 'run' the file with a sql load tool (sqlite will be fine). I measured 8x faster peformance doing it that way. I know what you have is convenient, but a utility that scans the disk from some media root and fast-loads the databsae is going to be worthwhile later....

Hexerei · 07-10-2004, 05:53 PM

I don't know what I'm missing but for some reason headunit will not compile on my system.

I have these installed:
qt-x11-free-3.3.2
xine-lib-1-rc5
sqlite 3.0.2

So I have the requirements that were posted.

I am running Gentoo with the 2.4.26-gentoo-r3 kernel on a Epia MII 10000 board.

I double checked and ./configured qt with the options you said and xine-lib with --enable-sdl.

Whenever I do a 'make' for headunit it compiles a bit then returns a lot of errors from DirectShowMediaPlayer.cpp. The first of these errors being:
DirectShowMediaPlayer.cpp:5:21: windows.h: No such file or directory
DirectShowMediaPlayer.cpp:6:19: DShow.h: No such file or directory

What does windows.h and DShow.h come from ? Did I miss a package? Once I get this working I would like to help out in any way I can. Unfortunately my C skills are lacking since I havn't created anything in a few years. I guess if you still need testers then I would help with that. My strength is in web design (PHP/MySQL) so if you need a site..

I can be contacted on aim via unrootedbox or icq via # 537376

Thanks
-Hexerei

Hexerei · 07-10-2004, 07:21 PM

after downloading the tar.gz instead of using the files from the cvs it works.

Dumb mistake on my part.

mobileh1 · 07-10-2004, 09:45 PM

qmake should not have included the DirectShowMediaPlayer.cpp. Its a win32 only thing. windows.h is only present on windows systems... If you get from CVS and need to correct this, alter the Makefile (if necessary) to remove the DirectShowMediaPlayer.cpp. I built from CVS last night on Linux and had no problems. You did run qmake right?

Quote: Originally Posted by Hexerei

after downloading the tar.gz instead of using the files from the cvs it works.

Dumb mistake on my part.

Hexerei · 07-11-2004, 02:43 AM

yea I did:

qmake -project
qmake
make

NoPistonPC · 07-11-2004, 10:01 PM

Quote: Originally Posted by mobileh1

NoPiston (if your still reading this). Its much faster to have the sql written to a file, then 'run' the file with a sql load tool (sqlite will be fine). I measured 8x faster peformance doing it that way. I know what you have is convenient, but a utility that scans the disk from some media root and fast-loads the databsae is going to be worthwhile later....

Hey, sorry, I was out of town for the weekend. That's a good idea. Having a separate tool for synching the database is the way to go (using the method you suggested). It sounds like you already have something written for this. If so, I can add it to the sourceforge page.
It would be great of this tool could scan a directory and then, using something like libid3, get the ID3 info and add that to the database along with the filename, path, album art file, etc...

Quote: Originally Posted by Hexerei

yea I did:

qmake -project
qmake
make

Sorry, it's actually my fault. You shouldn't run "qmake -project". Only do: qmake and then make. Running "qmake -project" will auto-generate the headunit.pro file which tells qt which files to make and sets other variables. You should make sure you get the latest CVS sources and that you have the latest headunit.pro file. Then just do "qmake" followed by "make". If you get that message about windows.h missing, that means you probably ran "qmake -project" which will overwrite the original headunit.pro with a new, incorrect version.

Custommx3 · 07-13-2004, 11:06 AM

IF anyone wanst to make an animated character similar to Alexis...

http://www.reallusion.com/crazytalk/ct_introduction.asp
You could probably use this tool.

momanz · 07-15-2004, 01:00 AM

NoPistonPC,

A couple of things have come to mind for features...

1. The ability to read/display hardware sensor data (cpu temp, fanspeed, processor speed) would be a good diagnostic for those hot summer days.

2. The ability to program and use an IR remote.

And on a slightly related note... I've decided I want to learn to write my own code so I can maybe one day help out with some of these open source projects. Any suggestions on where to start? I'm planning on sticking to linux since I really like the idea of using an open source OS.

-momanz

NoPistonPC · 07-15-2004, 01:30 AM

momanz, those are both good suggestions...

Linux is a good environment for learning C and C++, but not so good for learning VB (requires Windows). I would suggest starting out with VB, but that would require you to buy a copy of Visual Studio. You can probably get up and running quicker with VB than with C.

However, if you are really serious about helping out with open source projects, than I would recommend learning C or C++ since most are written in that language (due to ease of maintenance). C++ isn't very forgiving to mistakes, so if you want to ease into it, I would suggest learning Java first. Going from Java to C++ is not so bad.

You should find some good books in your local bookstore to get you started with any of these languages.

Good luck!