bekomme XXV nicht installiert

hi all,

versuche seit tagen erfolglos xxv zu installieren:

SUSE10
XXV letztes checkout

/.../XXV/install.sh

...
...
Info: new database version: 21
Info: Starting update...
Info: Saving Data
ERROR 1146 (42S02) at line 1: Table 'xxv.AUTOTIMER' doesn't exist
Error: Can't save table 'AUTOTIMER'

********* Set permissions *************

********* Set startscript *************

xxv has been installed!

*) open your browser with http://host:8080
login with xxv / xxv
and adjust all preferences for your system
*) and watch "/var/log/xxvd.log" for messages

/etc/init.d/xxvd start

Start ./xxvd: xxvd started with pid 13635.
server:/usr/local/src/XXV # Can't call method "selectall_arrayref" on unblessed reference at /usr/local/lib/xxv/Tools.pm line 236.

server:/ # tail -f /var/log/xxvd.log
----------------------------
---- XXVD System started ---
----------------------------
2 (250) [12:34:56] : Verbose Level is set to 3
3 (250) [12:34:56] : Use configuration file "/etc/xxv/xxvd.cfg"
4 (250) [12:34:56] : Schnelle Template Unterstützung ist aktiv!
5 (501) [12:34:56] DBI: DBI connect('database=xxv;host=localhost;port=3306','xxv',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at ././xxvd line 378
6 (550) [12:34:56] main: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
7 (250) [12:34:56] main: Successfully connect to: DBI:mysql:database=xxv;host=localhost;port=3306
8 (550) [12:34:56] main: Can't call method "selectall_arrayref" on unblessed reference at /usr/local/lib/xxv/Tools.pm line 236.

habe einen einzigen thread mit gleichen fehlermeldungen gefunden. werde aber nicht wirklich daraus schlau.

any hints?

thx

bernd

hi,

"Hm sieht aus, daß er sich nicht mit MySQL verbinden kann. MySQL ist installiert und läuft? "

server:~ # mysqld_safe --user=mysql
Starting mysqld daemon with databases from /usr/local/var

aus o.g. log:
...
7 (250) [12:34:56] main: Successfully connect to: DBI:mysql:database=xxv;host=localhost;port=3306
...

denke aber doch, dass das alles mit der fehlermeldung bein ./install.sh
zusammenhängt:

...
Info: Starting update...
Info: Saving Data
ERROR 1146 (42S02) at line 1: Table 'xxv.AUTOTIMER' doesn't exist
Error: Can't save table 'AUTOTIMER'
...

thx

bernd

hi,

server:/ # find / -name mysql.sock
/tmp/mysql.sock

finde weder in mysql eine möglichkeint einen anderen pfad anzulegen noch in xxv, in einem anderen pfad suchen zu lassen.

auf der anderen seite kommt doch:

7 (250) [12:34:56] main: Successfully connect to: DBI:mysql:database=xxv;host=localhost;port=3306

dann wieder auf der anderen seite:

erscheint in "netstat" nix mit mysql.

edit:

habe ein link von /tmp/mysql.sock /var/lib/mysql/mysql.sock gelegt.
scheint jetzt irgendwas zu funkionieren.

erstmal danke

melde mich

bernd

hi,

so, scheint soweit zu laufen, bis auf:

auffälligkeiten bein start:

46 (250) [19:33:13] main: REMOTE: Parse Commandfile ...
47 (501) [19:33:13] REMOTE: Use of uninitialized value in split at /usr/local/lib/xxv/XXV/MODULES/REMOTE.pm line 128.
48 (250) [19:33:13] main: RECORDS: Store records in database ...
49 (501) [19:33:14] RECORDS: Can't assign recording with title: 'Einsatz in 4 Wänden'
50 (501) [19:33:14] RECORDS: Can not find recording for Id 1!
51 (501) [19:33:14] RECORDS: Can't assign recording with title: 'taff'
52 (501) [19:33:14] RECORDS: Can not find recording for Id 2!
53 (501) [19:33:14] RECORDS: Can't assign recording with title: 'Galileo'
54 (501) [19:33:14] RECORDS: Can not find recording for Id 3!
55 (501) [19:33:14] RECORDS: Can't assign recording with title: 'Die Fleischmafia~Gesellschaft und Wirtschaft'
56 (501) [19:33:14] RECORDS: Can not find recording for Id 4!
57 (250) [19:33:14] : Dokumentation wurde in '/usr/local/share/xxv/doc' generiert

bei anwahl von "kommandos":

passiert garnix, nicht im log, nicht im browser

bei anwahl von "autotimer":

68 (501) [19:49:22] AUTOTIMER: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¤le,
Dir as Dir,
Start as Start,
Stop as Stopp,
MinLengt' at line 5 at /usr/local/lib/xxv/Tools.pm line 225, <DATA> line 1001.
69 (501) [19:49:22] AUTOTIMER: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¤le,
Dir as Dir,
Start as Start,
Stop as Stopp,
MinLengt' at line 5 -
select
Id as Service,
Activ as Akt,
Search as Suche,
Channels as Kanäle,
Dir as Dir,
Start as Start,
Stop as Stopp,
MinLength as Min
FROM
AUTOTIMER
WHERE Search LIKE '%' or Dir LIKE '%'
AND 0 = 1
70 (501) [19:49:22] AUTOTIMER: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¤le,
Dir as Dir,
Start as Start,
Stop as Stopp,
MinLengt' at line 5 at /usr/local/lib/xxv/XXV/MODULES/AUTOTIMER.pm line 917, <DATA> line 1001.

im log und im browser werden bereits programmierte autotimer nicht angezeigt.

bei anwahl von "timer":

74 (501) [19:51:39] TIMERS: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¤t,
UNIX_TIMESTAMP(t.NextStartTime) as __Day,
t.Collision as __Collision' at line 10 at /usr/local/lib/xxv/Tools.pm line 225, <DATA> line 1287.
75 (501) [19:51:39] TIMERS: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¤t,
UNIX_TIMESTAMP(t.NextStartTime) as __Day,
t.Collision as __Collision' at line 10 -
SELECT
t.Id as Sv,
t.Status as Status,
c.Name as Kanal,
c.Pos as __Pos,
t.Day as Tag,
t.Start as Start,
t.Stop as Stopp,
t.File as Titel,
t.Priority as Priorität,
UNIX_TIMESTAMP(t.NextStartTime) as __Day,
t.Collision as __Collision,
t.NextEpgId as __NextEpgId,
t.AutotimerId as __AutotimerId
FROM
TIMERS as t,
CHANNELS as c
WHERE
t.ChannelID = c.Id

AND 0 = 1
76 (501) [19:51:39] TIMERS: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '¤t,
UNIX_TIMESTAMP(t.NextStartTime) as __Day,
t.Collision as __Collision' at line 10 at /usr/local/lib/xxv/XXV/MODULES/TIMERS.pm line 1029, <DATA> line 1287.

so auch bei weiteren auswahlmöglichkeiten.

any ideas?

thx

bernd