| 1 |
Hi Peter, |
| 2 |
|
| 3 |
no , not one single line in any of the /var/log/mysql/* files, only when i start |
| 4 |
mysql manually with the parameters in the init script i see |
| 5 |
######## |
| 6 |
mysqld: ready for connections. |
| 7 |
Version: '4.1.21-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-4.1.21 |
| 8 |
060807 16:46:20 [Note] mysqld: Normal shutdown |
| 9 |
|
| 10 |
060807 16:46:21 [Note] mysqld: Shutdown complete |
| 11 |
|
| 12 |
mysqld: ready for connections. |
| 13 |
Version: '4.1.21' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-4.1.21 |
| 14 |
060823 14:09:54 [Note] mysqld: Normal shutdown |
| 15 |
|
| 16 |
060823 14:09:54 [Note] mysqld: Shutdown complete |
| 17 |
|
| 18 |
mysqld: ready for connections. |
| 19 |
Version: '4.1.21' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-4.1.21 |
| 20 |
060831 1:26:31 [Note] mysqld: Normal shutdown |
| 21 |
|
| 22 |
060831 1:26:31 [Note] mysqld: Shutdown complete |
| 23 |
|
| 24 |
mysqld: ready for connections. |
| 25 |
Version: '4.1.21' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-4.1.21 |
| 26 |
060905 15:18:15 [Note] mysqld: Normal shutdown |
| 27 |
|
| 28 |
060905 15:18:16 [Note] mysqld: Shutdown complete |
| 29 |
|
| 30 |
mysqld: ready for connections. |
| 31 |
Version: '4.1.21' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-4.1.21 |
| 32 |
######### |
| 33 |
|
| 34 |
in /var/log/mysql/mysqld.err |
| 35 |
|
| 36 |
mysql.err and mysql.log are empty |
| 37 |
|
| 38 |
when i try the init script i get: |
| 39 |
##### |
| 40 |
# /etc/init.d/mysql start |
| 41 |
dbg: >>> start() |
| 42 |
* ... |
| 43 |
dbg: >>> get_slot_config() |
| 44 |
dbg: srv 0 |
| 45 |
dbg: srv_slot 0 |
| 46 |
dbg: srv_num |
| 47 |
dbg: tmp_eval mysql_slot_0[@] |
| 48 |
dbg: conf_d_parameters |
| 49 |
dbg: MY_SUFFIX |
| 50 |
dbg: chroot dir => |
| 51 |
dbg: niceness => |
| 52 |
dbg: basedir => /usr |
| 53 |
dbg: datadir => /var/lib/mysql |
| 54 |
dbg: pidfile => /var/run/mysqld/mysqld.pid |
| 55 |
dbg: socket => /var/run/mysqld/mysqld.sock |
| 56 |
dbg: Unamanged => |
| 57 |
dbg: <<< get_slot_config() ok |
| 58 |
dbg: >>> checkconfig("/var/lib/mysql") |
| 59 |
dbg: <<< checkconfig() ok |
| 60 |
* Starting mysql (/etc/mysql/my.cnf) |
| 61 |
dbg: starting mysqld with: --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock |
| 62 |
dbg: |
| 63 |
49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,dbg: |
| 64 |
* MySQL NOT started (0) |
| 65 |
dbg: <<< start() |
| 66 |
###### |
| 67 |
|
| 68 |
*shrug* |
| 69 |
|
| 70 |
On Wed, 13 Sep 2006 18:51:44 -0700 |
| 71 |
"Peter Abrahamsen" <rainhead@×××××.com> wrote: |
| 72 |
|
| 73 |
> Hello Darko, |
| 74 |
> |
| 75 |
> Are you saying that turning up the debug puts nothing in the logs? I |
| 76 |
> don't use mysql, but something ought to be logged. If not, what I |
| 77 |
> often do is start the daemon manually, and if that isn't enough, |
| 78 |
> strace it. |
| 79 |
> |
| 80 |
> As to the vhosts thing, please read the documentation here: |
| 81 |
> http://httpd.apache.org/docs/2.0/vhosts/mass.html |
| 82 |
> |
| 83 |
> Good luck, |
| 84 |
> Peter |
| 85 |
> |
| 86 |
> On 9/13/06, Darko Luketic <webmaster@××××××××××××.com> wrote: |
| 87 |
> > Hello, |
| 88 |
> > |
| 89 |
> > i upgraded mysql a few months ago. |
| 90 |
> > i remember that this upgrade was that one that added the file server-running to /etc/init.d/mysql |
| 91 |
> > i've been running mysql 4 since 08/2005, 1st install. |
| 92 |
> > current installed version is 4.1.21. in this version the check for the server-running file was removed. |
| 93 |
> > the problem appeared 2 upgrades ago. (4.0.x) last version was 4.0.27 , previous 4.0.26 . |
| 94 |
> > when i upgraded to 4.1.21 from 4.0.27 i created a db dump, but not from 4.0.26->4.0.27. |
| 95 |
> > i'm using a nptl-enabled compilation. |
| 96 |
> > |
| 97 |
> > problem is i can't start the mysql server through the init script. |
| 98 |
> > i set debug to max possible, but the output is just a counter to 40 and starting mysql failed. |
| 99 |
> > when i'm starting the mysql server by hand with the parameters in the init script, |
| 100 |
> > it runs fine, however as soon as i want to restart daemons depending upon mysql, the mysql server stops, |
| 101 |
> > and i have to start it manually, which is annoying as e.g. i would like to restart apache or other daemons daily through cron. |
| 102 |
> > |
| 103 |
> > i know a reboot would very likely solve the problem, but thats not an option. (366 days uptime ruined, nooo :) ). |
| 104 |
> > it's not because of ibdata or similar files, it has to be something in the init script or in the content of some file that |
| 105 |
> > drives the start-stop-daemon crazy. |
| 106 |
> > |
| 107 |
> > any help appreciated |
| 108 |
> > |
| 109 |
> > i hope my english wasn't too bad. |
| 110 |
> > |
| 111 |
> > p.s.: does anyone know of a namebased virtualhosting module or similar for apache2 that doesn't require a graceful apache2 restart? |
| 112 |
> > |
| 113 |
> > -- |
| 114 |
> > Darko Luketic |
| 115 |
> > webmaster@××××××××××××.com |
| 116 |
> > |
| 117 |
> > -- |
| 118 |
> > gentoo-server@g.o mailing list |
| 119 |
> > |
| 120 |
> > |
| 121 |
> -- |
| 122 |
> gentoo-server@g.o mailing list |
| 123 |
> |
| 124 |
|
| 125 |
|
| 126 |
-- |
| 127 |
Darko Luketic |
| 128 |
webmaster@××××××××××××.com |
| 129 |
-- |
| 130 |
gentoo-server@g.o mailing list |
Archives