forum.vmspython.org Forum Index forum.vmspython.org
Forum system
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

New Installation on different destination does not work

 
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS
View previous topic :: View next topic  
Author Message
FWeichert



Joined: 12 Sep 2011
Posts: 12

PostPosted: Mon Sep 12, 2011 10:25 pm    Post subject: New Installation on different destination does not work Reply with quote

First Installation MYSQL051 V46.3-0

$ PRODUCT INSTALL MYSQL051 /DESTINATION=DB_DISK:[MYSQL]
...
$ SET DEFAULT DB_DISK:[MYSQL.MYSQL051.VMS]

$ @LOGICALS "/SYSTEM/EXEC"
$ @SYMBOLS
...
$ copy my.cnf_template my.cnf/prot=w:re
$ edit my.cnf
...
$ copy [.mysql]run_mysqld.com_template [.mysql]run_mysqld.com/prot=w:re
$ edit [.mysql]run_mysqld.com
...
$ @[.MYSQL]FIRST_START_MYSQLD
->
ERROR 1004 Can't create file '/mysql051_root/mysql_server/tmp/#sql20352358_1_0.frm' (errno:5)
[ERROR] Aborting
....


If I use "PRODUCT INSTALL" without /DEST=... then the installation works fine. But I get
mySQL installed on SYSTEM-Disk and not on my DATABASE-Disk.

What can I do?

Regards, Frank
Back to top
View user's profile Send private message
FWeichert



Joined: 12 Sep 2011
Posts: 12

PostPosted: Tue Sep 13, 2011 1:04 pm    Post subject: Re: New Installation on different destination does not work Reply with quote

While searching for differences I found:
- System-Disk: ODS-5
- DB_DISK: ODS-2
Does MYSQL needs an ODS-5-Disk to run?

Regards, Frank


FWeichert wrote:
First Installation MYSQL051 V46.3-0

$ PRODUCT INSTALL MYSQL051 /DESTINATION=DB_DISK:[MYSQL]
...
$ SET DEFAULT DB_DISK:[MYSQL.MYSQL051.VMS]

$ @LOGICALS "/SYSTEM/EXEC"
$ @SYMBOLS
...
$ copy my.cnf_template my.cnf/prot=w:re
$ edit my.cnf
...
$ copy [.mysql]run_mysqld.com_template [.mysql]run_mysqld.com/prot=w:re
$ edit [.mysql]run_mysqld.com
...
$ @[.MYSQL]FIRST_START_MYSQLD
->
ERROR 1004 Can't create file '/mysql051_root/mysql_server/tmp/#sql20352358_1_0.frm' (errno:5)
[ERROR] Aborting
....


If I use "PRODUCT INSTALL" without /DEST=... then the installation works fine. But I get
mySQL installed on SYSTEM-Disk and not on my DATABASE-Disk.

What can I do?

Regards, Frank
Back to top
View user's profile Send private message
jfp



Joined: 12 Jul 2004
Posts: 618

PostPosted: Tue Sep 13, 2011 1:22 pm    Post subject: Reply with quote

Hello Frank,

You're correct MySQL need the data disk to be ODS-5.

You can have (probably) the installation on an ODS-2 disk but the data files need to be on an ODS-5 disk.


Regards,

JF
Back to top
View user's profile Send private message Send e-mail Visit poster's website
FWeichert



Joined: 12 Sep 2011
Posts: 12

PostPosted: Tue Sep 13, 2011 2:30 pm    Post subject: Reply with quote

Hello JF

I've changed the volume to ODS-5. Now it works. Many thanks.

May be someone can add "ODS-5" to the Requirements at site

http://www.vmsmysql.org/DownloadAndInstallationMySQL5122

That could be helpfull for other beginners like me.

Regards, Frank


jfp wrote:
Hello Frank,

You're correct MySQL need the data disk to be ODS-5.

You can have (probably) the installation on an ODS-2 disk but the data files need to be on an ODS-5 disk.


Regards,

JF
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group