From cheyw2014@163.com Tue Apr 23 06:24:26 2013 From: cheyw To: buildservice@lists.opensuse.org Subject: [opensuse-buildservice] Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock Date: Mon, 22 Apr 2013 23:23:40 -0700 Message-ID: <1366698220629-4989197.post@n6.nabble.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8695068661803859968==" --===============8695068661803859968== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi,All My OBS instance sets up on opensuse 11.4 (64bit).The version of OBS server is 2.3.3. The version of Mysql client is 5.1.63. Now I Encountered a problem about OBS server. When I refresh a page always, I got an error says "Application Error" and the webui's log tells me " =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D [INFO |# 7620] Processing MonitorController#index (for 192.168.1.89 at 2013-04-23 14:13:02) [GET] [INFO |# 7620] Parameters: {"controller"=3D>"monitor", "action"=3D>"index"} [INFO |# 7620] Authenticated request to "/monitor" from cheneyche [INFO |# 7620] Rendering template within layouts/application [INFO |# 7620] Rendering monitor/index [INFO |# 7620] Completed in 757ms (View: 26, DB: 283) | 200 OK [http://192.168.1.24/monitor] [INFO |# 7620] Processing MonitorController#index (for 192.168.1.89 at 2013-04-23 14:13:03) [GET] [INFO |# 7620] Parameters: {"controller"=3D>"monitor", "action"=3D>"index"} [INFO |# 7620] Authenticated request to "/monitor" from cheneyche [FATAL|# 7620] BsRequest::ListError ( ): app/models/bs_request.rb:155:in `list' app/models/person.rb:195:in `requests_that_need_work' app/models/person.rb:192:in `requests_that_need_work' app/controllers/application_controller.rb:335:in `check_user' /usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/lib64/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib64/ruby/1.8/webrick/server.rb:92:in `each' /usr/lib64/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib64/ruby/1.8/webrick/server.rb:23:in `start' /usr/lib64/ruby/1.8/webrick/server.rb:82:in `start' [ERROR|# 7620] rescue_action: caught BsRequest::ListError: =20 [ERROR|# 7620] Couldn't parse error xml: # /usr/lib64/ruby/1.8/rexml/parsers/treeparser.rb:28:in `parse' /usr/ [INFO |# 7620] Rendering template within layouts/application [INFO |# 7620] Rendering error (400) [FATAL|# 7620] /!\ FAILSAFE /!\ Tue Apr 23 14:13:04 +0800 2013 Status: 500 Internal Server Error Mysql::Error: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2): UPDATE `sessions` SET `data` =3D 'BAh7CzoQbW9iaWxlX3ZpZXdGIgpmbGFzaElDOidBY3Rpb25Db250cm9sbGVy\nOjpGbGFzaDo6Rm= xhc2hIYXNoewAGOgpAdXNlZHsAOgtwYXNzd2QiCzExMTEx\nMToNcmVxdWVzdHNbADoKbG9naW4iD= mNoZW5leWNoZToQX2NzcmZfdG9rZW4i\nMVF4TFlJQmlRYjBxUXFZMHZtenZxMVptb3dROVNUeDMy= VytreTR2L3c3M1U9\n', `updated_at` =3D '2013-04-23 14:13:04' WHERE `id` =3D 5219 =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/abstract_adapter.rb:227:in `log' =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/mysql_adapter.rb:324:in `execute' =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/abstract/database_statements.rb:265:in `update_sql' =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/mysql_adapter.rb:339:in `update_sql' =E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6 =E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D " and the api's log tells me " =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D [INFO |#14010] Processing RequestController#index (for 192.168.1.24 at 2013-04-23 13:37:03) [GET] [INFO |#14010] Parameters: {"states"=3D>"declined", "user"=3D>"cheneyche", "view"=3D>"collection", "roles"=3D>"creator"} [INFO |#14010] Completed in 112ms (View: 1, DB: 1) | 200 OK [https://192.168.1.24/request?view=3Dcollection&states=3Ddeclined&roles=3Dcre= ator&user=3Dcheneyche] [INFO |#14010] Processing RequestController#index (for 192.168.1.24 at 2013-04-23 13:37:03) [GET] [INFO |#14010] Parameters: {"states"=3D>"review", "user"=3D>"cheneyche", "view"=3D>"collection", "reviewstates"=3D>"new", "roles"=3D>"reviewer"} [INFO |#14010] Completed in 579ms (View: 1, DB: 15) | 200 OK [https://192.168.1.24/request?view=3Dcollection&states=3Dreview&roles=3Drevie= wer&reviewstates=3Dnew&user=3Dcheneyche] [FATAL|#14010] /!\ FAILSAFE /!\ Tue Apr 23 13:37:04 +0800 2013 Status: 500 Internal Server Error Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/mysql_adapter.rb:620:in `real_connect' =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/mysql_adapter.rb:620:in `connect' =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/mysql_adapter.rb:294:in `reconnect!' =20 /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connectio= n_adapters/abstract_adapter.rb:152:in `verify!' =E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6 =E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D " =20 I'm sure the service MySql is running. BRs cheyw -- View this message in context: http://opensuse.14.x6.nabble.com/Can-t-connect-= to-local-MySQL-server-through-socket-var-run-mysql-mysql-sock-tp4989197.html Sent from the opensuse-buildservice mailing list archive at Nabble.com. --=20 To unsubscribe, e-mail: opensuse-buildservice+unsubscribe(a)opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner(a)opensuse.org --===============8695068661803859968==-- From coolo@suse.de Tue Apr 23 09:27:04 2013 From: Stephan Kulow To: buildservice@lists.opensuse.org Subject: Re: [opensuse-buildservice] Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock Date: Tue, 23 Apr 2013 11:27:04 +0200 Message-ID: <517653E8.8040207@suse.de> In-Reply-To: <1366698220629-4989197.post@n6.nabble.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7232171029879683693==" --===============7232171029879683693== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit On 23.04.2013 08:23, cheyw wrote: > Can't connect to local MySQL server through socket > '/var/run/mysql/mysql.sock Either your mysql is dead or you misconfigured the socket Greetings, Stephan -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe(a)opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner(a)opensuse.org --===============7232171029879683693==-- From cheyw2014@163.com Wed Apr 24 03:45:14 2013 From: cheyw To: buildservice@lists.opensuse.org Subject: [opensuse-buildservice] Re: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock Date: Tue, 23 Apr 2013 20:44:29 -0700 Message-ID: <1366775069477-4989255.post@n6.nabble.com> In-Reply-To: <517653E8.8040207@suse.de> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8414766303814856927==" --===============8414766303814856927== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi,Stephan=20 I'm sure the service MySql is running. Because my OBS server can be used normally in peacetime, this problem only happened that refresh a page many times=E3=80=82 Thanks=E3=80=82 -- View this message in context: http://opensuse.14.x6.nabble.com/Can-t-connect-= to-local-MySQL-server-through-socket-var-run-mysql-mysql-sock-tp4989197p49892= 55.html Sent from the opensuse-buildservice mailing list archive at Nabble.com. --=20 To unsubscribe, e-mail: opensuse-buildservice+unsubscribe(a)opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner(a)opensuse.org --===============8414766303814856927==-- From jengelh@inai.de Tue Apr 30 10:39:17 2013 From: Jan Engelhardt To: buildservice@lists.opensuse.org Subject: Re: [opensuse-buildservice] Re: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock Date: Tue, 30 Apr 2013 12:39:10 +0200 Message-ID: In-Reply-To: <1366775069477-4989255.post@n6.nabble.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5416908221921786339==" --===============5416908221921786339== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit On Wednesday 2013-04-24 05:44, cheyw wrote: >Hi,Stephan > I'm sure the service MySql is running. Because my OBS server can be used >normally in peacetime, this problem only happened that refresh a page many >times。 > Thanks。 Some time in the past, the socket was at /var/lib/mysql/mysql.sock. Check /etc/my.cnf. -- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe(a)opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner(a)opensuse.org --===============5416908221921786339==-- From cheyw2014@163.com Tue May 7 01:52:30 2013 From: cheyw To: buildservice@lists.opensuse.org Subject: [opensuse-buildservice] Re: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock Date: Mon, 06 May 2013 18:52:23 -0700 Message-ID: <1367891543081-4990267.post@n6.nabble.com> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3683199206761799103==" --===============3683199206761799103== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi=EF=BC=8CAll Thanks very much=E3=80=82The problem has been solved=E3=80=82The problem= is in the database of obs in mysql=E3=80=82 OBS service access an form of obs in mysql= =E3=80=82but the form is too big=E3=80=82After empty the form=EF=BC=8Cthe service work final= =E3=80=82 BRs cheyw -- View this message in context: http://opensuse.14.x6.nabble.com/Can-t-connect-= to-local-MySQL-server-through-socket-var-run-mysql-mysql-sock-tp4989197p49902= 67.html Sent from the opensuse-buildservice mailing list archive at Nabble.com. --=20 To unsubscribe, e-mail: opensuse-buildservice+unsubscribe(a)opensuse.org To contact the owner, e-mail: opensuse-buildservice+owner(a)opensuse.org --===============3683199206761799103==--