problème installation php-syslog-ng Step2

[mimiche1]

Bonjour,

Je rencontre un petit problème lors de linstallationde php-syslog-ng.

Les 3 premières étapes se sont bien passées.

Mais au step 2 j'ai ce message d'erreur :

Code :

1
2
3
 
Looks like there have been some errors with inserting data into your database!
You cannot continue.

error log :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
 
 
SQL=Table 'logs' already exists:
- - - - - - - - - -
CREATE TABLE logs (
host varchar(128) default NULL,
facility varchar(10) default NULL,
priority varchar(10) default NULL,
level varchar(10) default NULL,
tag varchar(10) default NULL,
datetime datetime default NULL,
program varchar(15) default NULL,
msg text,
seq bigint(20) unsigned NOT NULL auto_increment,
counter int(11) NOT NULL default '1',
fo datetime default NULL,
lo datetime default NULL,
PRIMARY KEY  (seq),
KEY datetime (datetime),
KEY priority (priority),
KEY facility (facility),
KEY program (program),
KEY host (host)
) ENGINE=MyISAM
= = = = = = = = = =
 
SQL=Table 'users' already exists:
- - - - - - - - - -
CREATE TABLE users (
username varchar(128) default NULL,
pwhash char(40) default NULL,
sessionid char(32) default NULL,
exptime datetime default NULL,
PRIMARY KEY (username)
) TYPE=MyISAM
= = = = = = = = = =
 
SQL=Table 'search_cache' already exists:
- - - - - - - - - -
CREATE TABLE search_cache (
tablename varchar(32) DEFAULT NULL,
type ENUM('HOST','FACILITY','PROGRAM','LPD'),
value varchar(128) DEFAULT NULL,
updatetime datetime DEFAULT NULL,
INDEX type_name (type, tablename)
) TYPE=MEMORY
= = = = = = = = = =
 
SQL=Table 'user_access' already exists:
- - - - - - - - - -
CREATE TABLE user_access (
username varchar(128) DEFAULT NULL,
actionname varchar(32) DEFAULT NULL,
access ENUM('TRUE','FALSE'),
INDEX user_action (username, actionname)
) TYPE=MyISAM
= = = = = = = = = =
 
SQL=Table 'actions' already exists:
- - - - - - - - - -
CREATE TABLE actions (
actionname varchar(32) NOT NULL,
actiondescr varchar(64) DEFAULT NULL,
defaultaccess ENUM('TRUE','FALSE'),
PRIMARY KEY (actionname)
) TYPE=MyISAM
= = = = = = = = = =
 
SQL=Table 'cemdb' already exists:
- - - - - - - - - -
--
-- Table structure for table cemdb
--
 
CREATE TABLE cemdb (
id int(5) unsigned NOT NULL auto_increment,
name varchar(128) NOT NULL default '',
message text,
explanation text,
action text,
datetime datetime default NULL,
PRIMARY KEY  (id),
UNIQUE KEY name (name)
) ENGINE=MyISAM  COMMENT='Cisco Error Message Database'
= = = = = = = = = =
 
SQL=Duplicate entry 'add_user' for key 1:
- - - - - - - - - -
INSERT INTO actions (actionname, actiondescr, defaultaccess) VALUES ('add_user', 'Add users', 'TRUE')
= = = = = = = = = =
 
SQL=Duplicate entry 'edit_user' for key 1:
- - - - - - - - - -
INSERT INTO actions (actionname, actiondescr, defaultaccess) VALUES ('edit_user', 'Edit users (delete and change password)', 'TRUE')
= = = = = = = = = =
 
SQL=Duplicate entry 'reload_cache' for key 1:
- - - - - - - - - -
INSERT INTO actions (actionname, actiondescr, defaultaccess) VALUES ('reload_cache', 'Reload search cache', 'TRUE')
= = = = = = = = = =
 
SQL=Duplicate entry 'edit_acl' for key 1:
- - - - - - - - - -
INSERT INTO actions (actionname, actiondescr, defaultaccess) VALUES ('edit_acl', 'Edit access control settings', 'TRUE');
= = = = = = = = = =
 
SQL=Column count doesn't match value count at row 1:
- - - - - - - - - -
INSERT INTO `logs` VALUES ('srv-www-001','daemon','warning','alert','Tag','2006-06-15 22:25:32','Test Script','%AAA-3-IPILLEGALMSG: Fan 1 had a rotation error reported.',1),('as-3550-2','kern','info','alert','Tag','2006-06-15 22:25:34','Test Script','Duplicate address 10.10.2.2 on Vlan20',2),('as-3550-2','mail','warning','crit','Tag','2006-06-15 22:25:36','Test Script','Line protocol on Interface FastEthernet0/7, changed state to up',3)
= = = = = = = = = =

Je ne vois pas ce que je dois faire ...

Merci

[Meskalyn]

SQL=Table 'logs' already exists:

La table "logs" ainsi que les autres existes déjà. Tu devrais supprimer ces tables avant d'effectuer une réinstallation.

[mimiche1]

Bonjour,

J'ai supprimer les tables qui existaient déjà.
voici le problème que je rencontre maintenant:

Code :

1
2
3
4
5
6
 
 
SQL=Column count doesn't match value count at row 1:
- - - - - - - - - -
INSERT INTO `logs` VALUES ('srv-www-001','daemon','warning','alert','Tag','2006-06-15 22:25:32','Test Script','%AAA-3-IPILLEGALMSG: Fan 1 had a rotation error reported.',1),('as-3550-2','kern','info','alert','Tag','2006-06-15 22:25:34','Test Script','Duplicate address 10.10.2.2 on Vlan20',2),('as-3550-2','mail','warning','crit','Tag','2006-06-15 22:25:36','Test Script','Line protocol on Interface FastEthernet0/7, changed state to up',3)
= = = = = = = = = =

Merci