2
Copyright (c) 2003 Novell, Inc. All Rights Reserved.
4
This program is free software; you can redistribute it and/or modify
5
it under the terms of the GNU General Public License as published by
6
the Free Software Foundation; either version 2 of the License, or
7
(at your option) any later version.
9
This program is distributed in the hope that it will be useful,
10
but WITHOUT ANY WARRANTY; without even the implied warranty of
11
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12
GNU General Public License for more details.
14
You should have received a copy of the GNU General Public License
15
along with this program; if not, write to the Free Software
16
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
29
#include "my_config.h"
30
#include "my_manage.h"
31
#include "mysql_version.h"
33
/******************************************************************************
37
******************************************************************************/
39
char basedir[PATH_MAX];
41
char datadir[PATH_MAX];
42
char pid_file[PATH_MAX];
43
char address[PATH_MAX];
45
char err_log[PATH_MAX];
46
char safe_log[PATH_MAX];
47
char mysqld[PATH_MAX];
48
char hostname[PATH_MAX];
49
char default_option[PATH_MAX];
53
/******************************************************************************
57
******************************************************************************/
60
void vlog(char *, va_list);
61
void log(char *, ...);
62
void start_defaults(int, char *[]);
63
void finish_defaults();
64
void read_defaults(arg_list_t *);
65
void parse_args(int, char *[]);
66
void get_options(int, char *[]);
67
void check_data_vol();
70
void mysql_start(int, char *[]);
71
void parse_setvar(char *arg);
73
/******************************************************************************
77
******************************************************************************/
79
/******************************************************************************
85
******************************************************************************/
89
setscreenmode(SCR_NO_MODE);
93
usage: mysqld_safe [options]\n\
95
Program to start the MySQL daemon and restart it if it dies unexpectedly.\n\
96
All options, besides those listed below, are passed on to the MySQL daemon.\n\
100
--autoclose Automatically close the mysqld_safe screen.\n\
102
--check-tables Check the tables before starting the MySQL daemon.\n\
104
--err-log=<file> Send the MySQL daemon error output to <file>.\n\
106
--help Show this help information.\n\
108
--mysqld=<file> Use the <file> MySQL daemon.\n\
115
/******************************************************************************
121
******************************************************************************/
122
void vlog(char *format, va_list ap)
124
vfprintf(stdout, format, ap);
129
vfprintf(log_fd, format, ap);
134
/******************************************************************************
140
******************************************************************************/
141
void log(char *format, ...)
145
va_start(ap, format);
152
/******************************************************************************
156
Start setting the defaults.
158
******************************************************************************/
159
void start_defaults(int argc, char *argv[])
165
static char *default_options[]=
169
"--defaults-extra-file=",
177
get_basedir(argv[0], basedir);
183
if (gethostname(hostname, PATH_MAX) < 0)
186
strcpy(hostname, "mysql");
190
snprintf(address, PATH_MAX, "0.0.0.0");
193
snprintf(port, PATH_MAX, "%d", MYSQL_PORT);
196
default_option[0]= NULL;
197
for (i= 0; (argc > 1) && default_options[i]; i++)
199
if (!strnicmp(argv[1], default_options[i], strlen(default_options[i])))
201
strncpy(default_option, argv[1], PATH_MAX);
206
// set after basedir is established
214
/******************************************************************************
218
Finish settig the defaults.
220
******************************************************************************/
221
void finish_defaults()
228
snprintf(datadir, PATH_MAX, "%s/data", basedir);
232
snprintf(pid_file, PATH_MAX, "%s/%s.pid", datadir, hostname);
236
snprintf(err_log, PATH_MAX, "%s/%s.err", datadir, hostname);
240
snprintf(safe_log, PATH_MAX, "%s/%s.safe", datadir, hostname);
244
snprintf(mysqld, PATH_MAX, "%s/bin/mysqld-max", basedir);
246
if (stat(mysqld, &buf))
248
snprintf(mysqld, PATH_MAX, "%s/bin/mysqld", basedir);
252
/******************************************************************************
258
******************************************************************************/
259
void read_defaults(arg_list_t *pal)
262
char defaults_file[PATH_MAX];
263
char mydefaults[PATH_MAX];
267
// defaults output file
268
snprintf(defaults_file, PATH_MAX, "%s/bin/defaults.out", basedir);
269
remove(defaults_file);
272
snprintf(mydefaults, PATH_MAX, "%s/bin/my_print_defaults", basedir);
276
add_arg(&al, mydefaults);
277
if (default_option[0])
278
add_arg(&al, default_option);
279
add_arg(&al, "mysqld");
280
add_arg(&al, "server");
281
add_arg(&al, "mysqld_safe");
282
add_arg(&al, "safe_mysqld");
284
spawn(mydefaults, &al, TRUE, NULL, defaults_file, NULL);
289
if ((fp= fopen(defaults_file, "r")) != NULL)
291
while (fgets(line, PATH_MAX, fp))
295
// remove end-of-line character
296
if ((p= strrchr(line, '\n')) != NULL)
299
// add the option as an argument
307
remove(defaults_file);
310
/******************************************************************************
316
******************************************************************************/
317
void parse_args(int argc, char *argv[])
337
static struct option options[]=
339
{"autoclose", no_argument, &autoclose, TRUE},
340
{"basedir", required_argument, 0, OPT_BASEDIR},
341
{"check-tables", no_argument, &checktables, TRUE},
342
{"datadir", required_argument, 0, OPT_DATADIR},
343
{"pid-file", required_argument, 0, OPT_PID_FILE},
344
{"bind-address", required_argument, 0, OPT_BIND_ADDRESS},
345
{"port", required_argument, 0, OPT_PORT},
346
{"err-log", required_argument, 0, OPT_ERR_LOG},
347
{"safe-log", required_argument, 0, OPT_SAFE_LOG},
348
{"mysqld", required_argument, 0, OPT_MYSQLD},
349
{"help", no_argument, 0, OPT_HELP},
350
{"set-variable", required_argument, 0, OPT_SETVAR},
354
// we have to reset getopt_long because we use it multiple times
357
// turn off error reporting
360
while ((c= getopt_long(argc, argv, "b:h:P:", options, &index)) >= 0)
365
strcpy(basedir, optarg);
370
strcpy(datadir, optarg);
374
strcpy(pid_file, optarg);
377
case OPT_BIND_ADDRESS:
378
strcpy(address, optarg);
383
strcpy(port, optarg);
387
strcpy(err_log, optarg);
391
strcpy(safe_log, optarg);
395
strcpy(mysqld, optarg);
399
parse_setvar(optarg);
414
parse_setvar(char *arg)
415
Pasrsing for port just to display the port num on the mysqld_safe screen
417
void parse_setvar(char *arg)
421
if ((pos= strindex(arg, "port")))
423
for (; *pos && *pos != '='; pos++);
425
strcpy(port, pos + 1);
429
/******************************************************************************
433
/******************************************************************************
439
******************************************************************************/
440
void get_options(int argc, char *argv[])
445
start_defaults(argc, argv);
447
// default file arguments
449
add_arg(&al, "ignore");
451
parse_args(al.argc, al.argv);
454
// command-line arguments
455
parse_args(argc, argv);
461
/******************************************************************************
465
Check the database volume.
467
******************************************************************************/
468
void check_data_vol()
470
// warn if the data is on a Traditional volume
471
struct volume_info vol;
476
memset(&vol, 0, sizeof(vol));
479
strcpy(buff, datadir);
480
if (p= strchr(buff, ':'))
482
// terminate after volume name
491
// retrieve information
492
netware_vol_info_from_name(&vol, buff);
494
if ((vol.flags & VOL_NSS_PRESENT) == 0)
496
log("Error: Either the data directory does not exist or is not on an NSS volume!\n\n");
501
/******************************************************************************
505
Check the current setup.
507
******************************************************************************/
513
// remove any current pid_file
514
if (!stat(pid_file, &info) && (remove(pid_file) < 0))
516
log("ERROR: Unable to remove current pid file!\n\n");
520
// check the data volume
523
// check for a database
524
snprintf(temp, PATH_MAX, "%s/mysql/host.frm", datadir);
525
if (stat(temp, &info))
527
log("ERROR: No database found in the data directory!\n\n");
532
/******************************************************************************
536
Check the database tables.
538
******************************************************************************/
542
char mycheck[PATH_MAX];
543
char table[PATH_MAX];
545
DIR *datadir_entry, *db_entry, *table_entry;
548
log("checking tables...\n");
551
if ((datadir_entry= opendir(datadir)) == NULL)
556
while ((db_entry= readdir(datadir_entry)) != NULL)
558
if (db_entry->d_name[0] == '.')
562
else if (S_ISDIR(db_entry->d_type))
564
// create long db name
565
snprintf(db, PATH_MAX, "%s/%s", datadir, db_entry->d_name);
568
if ((db_entry= opendir(db)) == NULL)
573
while ((table_entry= readdir(db_entry)) != NULL)
575
// create long table name
576
snprintf(table, PATH_MAX, "%s/%s", db, strlwr(table_entry->d_name));
578
if (strindex(table, ".myi"))
583
snprintf(mycheck, PATH_MAX, "%s/bin/myisamchk", basedir);
587
add_arg(&al, mycheck);
588
add_arg(&al, "--silent");
589
add_arg(&al, "--force");
590
add_arg(&al, "--fast");
591
add_arg(&al, "--medium-check");
593
add_arg(&al, "key_buffer=64M");
595
add_arg(&al, "sort_buffer=64M");
598
spawn(mycheck, &al, TRUE, NULL, NULL, NULL);
602
else if (strindex(table, ".ism"))
607
snprintf(mycheck, PATH_MAX, "%s/bin/isamchk", basedir);
611
add_arg(&al, mycheck);
612
add_arg(&al, "--silent");
613
add_arg(&al, "--force");
615
add_arg(&al, "sort_buffer=64M");
618
spawn(mycheck, &al, TRUE, NULL, NULL, NULL);
627
/******************************************************************************
631
Start the mysql server.
633
******************************************************************************/
634
void mysql_start(int argc, char *argv[])
641
char stamp[PATH_MAX];
645
static char *private_options[]=
657
add_arg(&al, "%s", mysqld);
660
for (i= 1; i < argc; i++)
664
// skip private arguments
665
for (j= 0; private_options[j]; j++)
667
if (!strnicmp(argv[i], private_options[j], strlen(private_options[j])))
676
add_arg(&al, "%s", argv[i]);
682
// check the database tables
688
localtime_r(&cal, <);
689
strftime(stamp, PATH_MAX, "%d %b %Y %H:%M:%S", <);
690
log("mysql started : %s\n", stamp);
693
spawn(mysqld, &al, TRUE, NULL, NULL, err_log);
695
while (!stat(pid_file, &info));
699
localtime_r(&cal, <);
700
strftime(stamp, PATH_MAX, "%d %b %Y %H:%M:%S", <);
701
log("mysql stopped : %s\n\n", stamp);
707
/******************************************************************************
711
******************************************************************************/
712
int main(int argc, char **argv)
717
get_options(argc, argv);
719
// keep the screen up
721
setscreenmode(SCR_NO_MODE);
724
log_fd= fopen(safe_log, "w+");
727
log("MySQL Server %s, for %s (%s)\n\n", VERSION, SYSTEM_TYPE, MACHINE_TYPE);
730
log("address : %s\n", address);
731
log("port : %s\n", port);
732
log("daemon : %s\n", mysqld);
733
log("base directory : %s\n", basedir);
734
log("data directory : %s\n", datadir);
735
log("pid file : %s\n", pid_file);
736
log("error file : %s\n", err_log);
737
log("log file : %s\n", safe_log);
743
// start the MySQL server
744
mysql_start(argc, argv);