[Bug 917629] Re: MySQL Server 5.1 fails to start after install
-- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/917629 Title: MySQL Server 5.1 fails to start after install To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/917629/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 917629] [NEW] MySQL Server 5.1 fails to start after install
Public bug reported:
On a fresh an newly installed server, ubuntu 11.10 x64,
I install mysql server with the following command as root :
aptitue update
aptitude full-upgrade
... (update last available package)
aptitude install mysql-server-5.1
Install ask for root password, the complete.
MySQL starts, create the system database and fails due to a syntax error and
then shutdown.
Next startup fails also as it says the table plugin already exists.
Regards,
Thomas
120117 13:56:50 [Note] Plugin 'FEDERATED' is disabled.
120117 13:56:50 InnoDB: Initializing buffer pool, size = 8.0M
120117 13:56:50 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
120117 13:56:50 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120117 13:56:50 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120117 13:56:50 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
120117 13:56:50 InnoDB: Started; log sequence number 0 0
120117 13:56:50 InnoDB: Starting shutdown...
120117 13:56:56 InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:56:56 [Note] Plugin 'FEDERATED' is disabled.
120117 13:56:56 InnoDB: Initializing buffer pool, size = 8.0M
120117 13:56:56 InnoDB: Completed initialization of buffer pool
120117 13:56:56 InnoDB: Started; log sequence number 0 44233
120117 13:56:56 InnoDB: Starting shutdown...
120117 13:57:01 InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:01 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:01 InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:01 InnoDB: Completed initialization of buffer pool
120117 13:57:01 InnoDB: Started; log sequence number 0 44233
ERROR: 1064 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
'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8
NOT ' at line 1
120117 13:57:01 [ERROR] Aborting
120117 13:57:01 InnoDB: Starting shutdown...
120117 13:57:06 InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:06 [Note] /usr/sbin/mysqld: Shutdown complete
120117 13:57:06 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:06 InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:06 InnoDB: Completed initialization of buffer pool
120117 13:57:06 InnoDB: Started; log sequence number 0 44233
120117 13:57:06 InnoDB: Starting shutdown...
120117 13:57:11 InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:11 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:11 InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:11 InnoDB: Completed initialization of buffer pool
120117 13:57:11 InnoDB: Started; log sequence number 0 44233
ERROR: 1050 Table 'plugin' already exists
120117 13:57:11 [ERROR] Aborting
120117 13:57:11 InnoDB: Starting shutdown...
120117 13:57:17 InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:17 [Note] /usr/sbin/mysqld: Shutdown complete
120117 13:57:17 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:17 InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:17 InnoDB: Completed initialization of buffer pool
120117 13:57:17 InnoDB: Started; log sequence number 0 44233
120117 13:57:17 [Note] Event Scheduler: Loaded 0 events
ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: mysql-server-5.1 5.1.58-1ubuntu1
ProcVersionSignature: Ubuntu 3.0.0-12.20-server 3.0.4
Uname: Linux 3.0.0-12-server x86_64
ApportVersion: 1.23-0ubuntu4
Architecture: amd64
Date: Tue Jan 17 14:01:12 2012
ProcEnviron:
LANGUAGE=en_US:en:en_GB:en
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-5.1
UpgradeStatus: Upgraded to oneiric on 2011-11-07 (70 days ago)
** Affects: mysql-5.1 (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug oneiric
--
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/917629
Title:
MySQL Server 5.1 fails to start after install
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/917629/+subscriptions
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 579924] Re: Upgrading Ubuntu LTS skips database version - Fatal error: Version error for database bacula. Wanted 12, got 10
Hi, I'm affected too but in my case I upgrade from 9.10 to 10.04. Thomas. -- Upgrading Ubuntu LTS skips database version - Fatal error: Version error for database bacula. Wanted 12, got 10 https://bugs.launchpad.net/bugs/579924 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bacula in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 573318] Re: mysql server will not start
@thecapsaicinkid is your file readable ?
because if you look at the pre-start script it makes the following check
:
pre-start script
#Sanity checks
[ -r $HOME/my.cnf ]
[ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d /var/run/mysqld
LC_ALL=C BLOCKSIZE= df --portability /var/lib/mysql/. | tail -n 1 | awk '{
exit ($44096) }'
end script
What you can do is :
su - mysql
export HOME=/etc/mysql
and try to run the command and check which one return false ( something
!= 0)
ex:
$[ -r $HOME/my.cnf ]
$echo $?
0
--
mysql server will not start
https://bugs.launchpad.net/bugs/573318
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 573318] Re: mysql server will not start
Hi, i've the same issue, it's a very bad time for me to have this issue... daemon.log shows only this : May 17 19:05:28 sd1 init: mysql pre-start process (4506) terminated with status 1 nothing in kern.log in safe mode, it works. It seems that some ubuntu specific init scripts is wrong here... r...@sd1:~# mysqld_safe --user=mysql [1] 4693 r...@sd1:~# 100517 19:14:21 mysqld_safe Logging to '/var/lib/mysql/sd1.123monsite.com.err'. 100517 19:14:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql r...@sd1:~# r...@sd1:~# r...@sd1:~# mysqladmin version mysqladmin Ver 8.42 Distrib 5.1.41, for debian-linux-gnu on x86_64 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.1.41-3ubuntu12 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 7 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.142 r...@sd1:~# mysqladmin -u root shutdown 100517 19:14:43 mysqld_safe mysqld from pid file /var/lib/mysql/sd1.123monsite.com.pid ended [1]+ Donemysqld_safe --user=mysql r...@sd1:~# -- mysql server will not start https://bugs.launchpad.net/bugs/573318 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 573318] Re: mysql server will not start
r...@sd1:/etc# ll mysql total 24 drwxr-xr-x 3 root root 4096 2010-05-17 19:15 . drwxr-xr-x 111 root root 12288 2010-05-17 19:02 .. drwxr-xr-x 2 root root 4096 2010-05-17 19:02 conf.d -rw--- 1 root root 333 2010-05-17 14:20 debian.cnf no debian.start script, is it normal ? I've once seen it, but I've remove --purge the package to reinstall it, upon reinstall, the init script that ask for root password was not triggered (ie i didnt have the possiblity to enter a root password) -- mysql server will not start https://bugs.launchpad.net/bugs/573318 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 573318] Re: mysql server will not start
Lol... /etc/mysql/my.cnf is absent and that's whay the pre-init script fails I've taken a my.cnf.dpkg-dist, put it inside /etc/mysql/my.cnf and mysql was able to start ! -- mysql server will not start https://bugs.launchpad.net/bugs/573318 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 573318] Re: mysql server will not start
/etc/mysql/my.cnf is missing, here is a default ( my.cnf.dpkg-dist) file to put in /etc/mysql ** Attachment added: default /etc/mysql/my.cnf to put so that myslq start http://launchpadlibrarian.net/48615270/my.cnf -- mysql server will not start https://bugs.launchpad.net/bugs/573318 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 234926] Re: logwatch missing conf files
Is there a workaround ? -- logwatch missing conf files https://bugs.launchpad.net/bugs/234926 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to logwatch in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 234926] Re: logwatch missing conf files
I'm mean what cviniciusm reports on 2009-11-12, affects me too in the exact same way. It seems to be a recent bug, because some of my server on which logwatch was installed for a while do not have the issue. On a working server : tho...@home:/home/special/thomas/emule/done$ locate header.html /etc/logwatch/conf/html/header.html And I also largely agree that all logwatch conf should be under /etc/logwatch (both standart config and custom modification), it's very disturbing to have to search where the conf is for this very package. Customizing feature is a good thing, but configuration should be where configuration is usually placed : in /etc When I first installed logwatch I found it very strange to configure something in /var/something. -- logwatch missing conf files https://bugs.launchpad.net/bugs/234926 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to logwatch in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 234926] Re: logwatch missing conf files
workaround :
create the missing file in /usr/share/logwatch/default.conf/html/.
here is one I've got in my server :
footer.html
###
!-- Start footer.html --
div class=\copyright\
hr
pLogwatch copy;Copyright 2002-2006 Kirk Bauer/p
p
Permission is hereby granted, free of charge, to any person obtaining a copy of
this software and associated documentation files (the Software), to deal in
the Software without restriction, including without limitation the rights to
use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies
of the Software, and to permit persons to whom the Software is furnished to do
so, subject to the following conditions:
/p
p
The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.
/p
p
THE SOFTWARE IS PROVIDED AS IS, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.
/p/div
/body/html
###
header.html
###
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
http://www.w3.org/TR/REC-html40/loose.dtd;
html
head
titleLogwatch $Version ( $VDate )/title
meta name=generator content=Logwatch $Version ( $VDate )
style type=text/css
h1 {color: gray; border-bottom: 3px double silver; font-family: sans-serif; }
h2 {color: white; border-bottom: 1px solid silver; font-family: sans-serif; }
h3 {color: white; border-bottom: 1px solid silver; font-family: sans-serif; }
th {background: #6D88AD; text-align: left; font-family: sans-serif; }
td {background: #EFEFEF; text-align: left; font-family: courier,serif;
font-size: 10px; }
li { font-family: sans-serif; }
.ref {padding-left: 1%; }
.service {padding-left: 1%; }
.return_link {border-top: 1px; border-bottom: 1px;
padding: 1%; margin-top: 1%; margin-bottom: 1%; font-family: sans-serif; }
.copyright {color: black; border-top: 1px solid grey;
border-bottom: 1px solid grey;
padding: 1%; margin-top: 1%; margin-bottom: 1%;}
/style
/head
body style=width:90%; margin-left: 5%; margin-right: 5% bgcolor=#FF
hr
!-- End header.html --
###
--
logwatch missing conf files
https://bugs.launchpad.net/bugs/234926
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to logwatch in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 249824] Re: [intrepid] IPv6 unusable
Hi Matt, Thanks very very much for the backport to Intrepid, my life is getting better now ;) I've installed the patch on my production secondary DNS server and it successfully solved the issue. One question : I've you're patch repository in my /etc/apt/sources.list. When the patch will be generally available on intrepedid, what are the steps for me to return in the intrepid branch (without loosing the fix (or not for too long time)) ? Thanks again, Thomas. -- [intrepid] IPv6 unusable https://bugs.launchpad.net/bugs/249824 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bind9 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 249824] Re: [intrepid] IPv6 unusable
Thanks for this precision Matt ! Thomas. -- [intrepid] IPv6 unusable https://bugs.launchpad.net/bugs/249824 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bind9 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 249824] Re: [intrepid] IPv6 unusable
Will anybody have the decency to answer ? any ubuntero here ? I had to disable my secondary DNS server for dozens of .fr. domains because of this bug. Some people are becoming upset and I totally agree with that. Please, give an answer or a decent workaround. Thanks -- [intrepid] IPv6 unusable https://bugs.launchpad.net/bugs/249824 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bind9 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 249824] Re: [intrepid] IPv6 unusable
Can anybody answer ? I don't see the fix comming with sudo apt-get update;sudo apt-get ugprade Thomas. -- [intrepid] IPv6 unusable https://bugs.launchpad.net/bugs/249824 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bind9 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 249824] Re: [intrepid] IPv6 unusable
Hi, From Adam Track from the Bind mailing list, told me : I think BIND from Ubuntu distribution is not compiled as GNU source (with _GNU_SOURCE macro defined). It is needed to get IPv6 working. The best solution is to open ticket in Ubuntu bug tracker. Adam Thomas. -- [intrepid] IPv6 unusable https://bugs.launchpad.net/bugs/249824 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bind9 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 249824] Re: [intrepid] IPv6 unusable
Hi, I reproduce this bug on a Secondary DNS Server, ubuntu x86-64 8.10. Thinks were ok on 8.04 and after upgrade I get this message in the log : Nov 18 13:36:11 ns1 named[32579]: no IPv6 interfaces found while I'm on a machine with both ipv4 and ipv6 activated. Does anyone have an idea of when the fix will be available on apt-get upgrade ? Is there a mean to get the fix earlier to test it ? Note : I can provide some more info on my server or make some test if I'm asked to do so ;) Thomas. -- [intrepid] IPv6 unusable https://bugs.launchpad.net/bugs/249824 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to bind9 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
