Subject: Re: new releases of MySQL and Python From: Jean-François PIÉRONNE Date: Sat, 22 Mar 2003 17:59:30 +0100 CC: p_sture@elias.decus.ch Newsgroups: comp.os.vms >> >> I've downloaded that thanks. It built successfully, although with quite a >> few warnings. Unfortunately when I come to run it, it gives this: >> >> @RUN_MYSQLD.COM;10 >> 030322 14:44:07 InnoDB: Started >> 030322 14:44:08 Fatal error: Can't open privilege tables: Can't find file: >> './m >> ysql/host.frm' (errno: 65535) >> 030322 14:44:08 Aborting >> >> 030322 14:44:08 InnoDB: Starting shutdown... >> 030322 14:44:09 InnoDB: Shutdown completed >> 030322 14:44:09 /$1$DKA0/user/sy/mysql-4_0_12/vms/mysql/mysqld.exe.2: Shutdown >> Complete >> >> I have looked on www.mysql.org and it talks about setting file ownership: >> >> Can't find file: './mysql/host.frm' (errno: 13) >> >> , and you've tried setting >> --datadir=/path/to/my/data/directory but you >> still get the same error, it may be because the >> databases installed in the mysql data directory >> (usually /var/lib/mysql) are not owned by the >> mysql daemon, but by the user who ran >> mysql_install_db. chown them to mysql and chgrp >> them to the appropriate group e.g. >> >> chown -R mysql /var/lib/mysql/mysql >> chgrp -R daemons /var/lib/mysql/mysql >> Currently, documentation is missing but I have planned to put it on a new site named http://vmsmysql.dyndns.org. I will start this work probably next week. Basic installation guide: 1) unzip the file 2) restore the saveset, you probably need a ODS-5 disk not sure. 3) goto the sub directory named vms 4) @logicals "/system" 5) building procedure @build_all [vms_ssl/openssl] [zlib] vms_ssl if you have installed HP OpenSSL distribuion openssl if you have installed standard OpenSSL distribution zlib if you have zlib installed (need libz:libz.olb and libz:*.h files) 6) goto the sub directory vms.mysql $ spawn/nowait/input=nl:/notif @mysql_root:[vms.mysql]first_run_mysqld $ @mysql_root:[vms]symbols $ @mysql_root:[vms.mysql]mysql_privileges finally (you really have to do the command twice): $ mysqladmin -u root shutdown $ mysqladmin -u root shutdown optionally build a few demonstration databases: $ spawn/nowait/input=nl:/notif run_mysqld.com $ @mysql_root:[vms.mysql]samp_db $ @mysql_root:[vms.mysql]vmsmod $ @mysql_root:[vms.mysql]load_repository $ @mysql_root:[vms.mysql]load_objects $ mysqladmin -u root shutdown $ mysqladmin -u root shutdown 7) now use the run_mysqld.com to run MySQL server Sorry for any inconvenience. >> That raises a few questions: >> >> 1. Should I set up a separate username to run MYSQL? Probably better. I would be nice to build some start procedure which do some run/detach >> 2. I cannot find host.frm anywhere in the directory tree. Is it >> created during initialization or is it simply missing? See previous instruction >> 3. Which .EXE should I point the symbol "MYSQL" at? (Used in >> MYSQL_PRIVLIEGES.COM) >> symbol MYSQL and some others are defined by the procedues mysql_root:[vms]symbols.com Jean-François Piéronne