Bonjour,
Je suis sur ubuntu 11,10 et j'ai un petit soucis avec le mysql de xampp 1.7.7 (je préfere rester sur xampp)
Voici le contenu de mon liberty-chat.be.err :
Voici mon fichier my.cnf
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 120421 19:18:24 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql 120421 19:18:24 [Note] Plugin 'FEDERATED' is disabled. /opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 120421 19:18:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120421 19:18:24 InnoDB: The InnoDB memory heap is disabled 120421 19:18:24 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 120421 19:18:24 InnoDB: Compressed tables use zlib 1.2.3 120421 19:18:24 InnoDB: Initializing buffer pool, size = 16.0M 120421 19:18:24 InnoDB: Completed initialization of buffer pool 120421 19:18:24 InnoDB: highest supported file format is Barracuda. 120421 19:18:24 InnoDB: Waiting for the background threads to start 120421 19:18:25 InnoDB: 1.1.8 started; log sequence number 4566792 120421 19:18:25 [ERROR] Can't start server : Bind on unix socket: Permission denied 120421 19:18:25 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ? 120421 19:18:25 [ERROR] Aborting 120421 19:18:25 InnoDB: Starting shutdown... 120421 19:18:26 InnoDB: Shutdown completed; log sequence number 4566792 120421 19:18:26 [Note] /opt/lampp/sbin/mysqld: Shutdown complete 120421 19:18:26 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/liberty-chat.be.pid ended
Voici la réponse à la commande : "ll /opt/lampp/var" :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162 # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /opt/lampp/var/mysql) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3307 socket = /opt/lampp/var/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] user = nobody port = 3306 socket = /opt/lampp/var/mysql/mysql.sock skip-external-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # Where do all the plugins live plugin_dir = /opt/lampp/lib/mysql/plugin/ # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the "enable-named-pipe" option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication # log-bin deactivated by default since XAMPP 1.4.11 #log-bin=mysql-bin # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - # the syntax is: # # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, # MASTER_USER=<user>, MASTER_PASSWORD=<password> ; # # where you replace <host>, <user>, <password> by quoted strings and # <port> by the master's port number (3306 by default). # # Example: # # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, # MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then # start replication for the first time (even unsuccessfully, for example # if you mistyped the password in master-password and the slave fails to # connect), the slave will create a master.info file, and any later # change in this file to the variables' values below will be ignored and # overridden by the content of the master.info file, unless you shutdown # the slave server, delete master.info and restart the slaver server. # For that reason, you may want to leave the lines below untouched # (commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id = 2 # # The replication master for this slave - required #master-host = <hostname> # # The username the slave will use for authentication when connecting # to the master - required #master-user = <username> # # The password the slave will authenticate with when connecting to # the master - required #master-password = <password> # # The port the master is listening on. # optional - defaults to 3306 #master-port = <port> # # binary logging - not required for slaves, but recommended #log-bin=mysql-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #bdb_cache_size = 4M #bdb_max_lock = 10000 # Comment the following if you are using InnoDB tables #skip-innodb innodb_data_home_dir = /opt/lampp/var/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /opt/lampp/var/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
Voici la réponse à la commande : "ll /opt/lampp/var/mysql" :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 root@liberty-chat:~# ll /opt/lampp/var total 36 drwxr-xr-x 6 root root 4096 2012-04-21 02:33 ./ drwxr-xr-x 19 root root 4096 2012-04-09 21:43 ../ drwxrwxr-x 19 root root 4096 2012-04-21 19:18 mysql/ drwxr-xr-x 4 root root 4096 2009-07-30 11:18 perl/ drwxr-xr-x 2 root root 4096 2012-04-08 01:20 proftpd/ -rw-r--r-- 1 root root 6440 2012-04-21 02:18 proftpd.delay -rw-r--r-- 1 root root 0 2012-04-21 02:33 proftpd.pid -rw-r--r-- 1 root root 16 2012-04-21 02:33 proftpd.scoreboard drwxr-xr-x 2 root root 4096 2007-05-09 14:25 run/
Voici ce que me donne comme réponse aux commandes "ps aux | grep mysql" et "whereis mysql{,d}" :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 root@liberty-chat:~# ll /opt/lampp/var/mysql total 36988 drwxrwxr-x 19 root root 4096 2012-04-21 19:18 ./ drwxr-xr-x 6 root root 4096 2012-04-21 02:33 ../ drwx------ 2 root root 4096 2007-03-23 19:54 cdcol/ drwx------ 2 root nogroup 4096 2012-04-09 03:06 characters/ drwx------ 2 root nogroup 4096 2012-04-19 00:15 gamepanel/ drwx------ 2 root nogroup 4096 2012-04-18 22:45 gpx/ -rw-rw---- 1 root nogroup 27262976 2012-04-21 19:18 ibdata1 -rw-rw---- 1 root nogroup 5242880 2012-04-21 19:18 ib_logfile0 -rw-rw---- 1 root nogroup 5242880 2012-04-08 01:20 ib_logfile1 -rw-rw---- 1 nobody root 1362 2012-04-21 19:18 liberty-chat.be.err drwx------ 2 root nogroup 20480 2012-04-09 03:11 mangos/ drwxrwxrwx 2 root root 4096 2011-01-10 14:49 mysql/ -rw-r--r-- 1 root root 5 2011-01-10 14:49 mysql_upgrade_info -rw-rw---- 1 root root 0 2012-04-21 17:09 ns395751.ovh.net.err drwxr-xr-x 2 root root 12288 2012-04-08 04:18 nuked/ drwx------ 2 root nogroup 4096 2012-04-16 23:16 partage/ drwx------ 2 root root 4096 2011-01-10 14:49 performance_schema/ drwx------ 2 root root 4096 2011-05-17 15:15 phpmyadmin/ drwx------ 2 root nogroup 4096 2012-04-21 00:57 rankme/ drwx------ 2 root nogroup 4096 2012-04-09 03:05 realmd/ drwx------ 2 root nogroup 4096 2012-04-10 00:58 SAMDB/ drwx------ 2 root nogroup 4096 2012-04-09 02:53 scriptdev2/ drwx------ 2 root nogroup 4096 2012-04-20 22:40 sourcemod/ drwx------ 2 root root 4096 2010-05-04 12:29 test/ drwx------ 2 root nogroup 20480 2012-04-10 01:49 xoops/
Je ne comprends pas grand chose a ses lignes.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5 root@liberty-chat:~# ps aux | grep mysql root 24192 0.0 0.0 9772 896 pts/1 S+ 20:41 0:00 grep --color=auto mysql root@liberty-chat:~# whereis mysql{,d} mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /opt/lampp/bin/mysql /opt/lampp/bin/mysql.server /usr/share/man/man1/mysql.1.gz mysqld: /usr/sbin/mysqld /usr/share/man/man8/mysqld.8.gz
Dans le dossier "/opt/lampp/var/run/mysql", les fichiers suivant ont disparu :
[*]liberty-chat.be.pid
ns395751.ovh.net.pid
mysql.sock[/*]
Ce qui est bizzare c'est que quand j'utilise putty en ligne de commande par "locate", je les trouvent et ce dans le bon dossier, mais si j'essaye de faire par exemple un chmod il dit que le fichier est inexistant (je suis bien dans le bon dossier) et dans WinScp il apparaissent meme pas.
J'avais fais un lien symbolique de :
et
Code : Sélectionner tout - Visualiser dans une fenêtre à part /tmp/var/ vers /opt/lampp/var/run/mysql/mysql.sock
et un de
Code : Sélectionner tout - Visualiser dans une fenêtre à part /etc/mysql/ vers /opt/lampp/var/run/mysql/mysql.sock
Suite aux erreurs suivantes :
Code : Sélectionner tout - Visualiser dans une fenêtre à part /var/lib/mysql/ vers /opt/lampp/var/run/mysql/mysql.sock
Code : Sélectionner tout - Visualiser dans une fenêtre à part ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/var/mysql.sock' (2)
Code : Sélectionner tout - Visualiser dans une fenêtre à part ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/etc/mysql/mysql.sock' (2)Pourriez-vous m'aider svp ?
Code : Sélectionner tout - Visualiser dans une fenêtre à part ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Merci d'avance.
Bien à vous.
Partager