e-mail   
 Menu
  Home
  Download
  Top 10 Downloads
  Last 15 New Files
  Web Links
  Tips
  Last 15 New Tips
  NLM Programming
  Admins Club





SUPLA System
Internet of Things




Installation and Administration






Polish Forum SUSE


 
Who's Online

 There are currently,
6 guest(s)
that is (are) online.
 


Technical Information

Back to List of Categories

Technical Information about
  An Introduction to JBoss
  An Introduction to LDAP: Part 1-LDAP Primer
  An Introduction to LDAP: Part 2-Using LDAP to Create a User Authentication
  AppNote: Configuring an OpenSLP DA on OES or SUSE LINUX Enterprise Servers
  AppNote: Installing Oracle 10g on SLES9
  Developing PHP Scripts with SUSE LINUX
  Encrypting Data Partitions
  How to configure MySQL for NSS File System in OES for Linux
  How to install Webmin - A Web-Based System Admin Tool
  How to Run Binary-Only Application Packages on Various Versions of Linux
  Integrating Novell OES Linux iManager, Virtual Office and Welcome Page with Apache 2.2.2, Tomcat 5.5.17 and Sun Java2 1.4.2
  Keeping Sync with a Remote NTP Server
  Lab Guide for installing Open Enterprise Server with Linux Kernel
  Make your computer a SUSE LINUX Enterprise Server with a normal cable connection.
  Novell SLES9 vs Windows2003 Server
  NTP Active Servers
  Patching Open Enterprise Server with rug/Red Carpet FAQ
  Performance Tuning Installation Tips
  Remote administration

Technical Information
 How to configure MySQL for NSS File System in OES for Linux

Printer-friendly version

Posted: 24 Aug 2005

Abstract:

This document describes how to configure MySQL server to use the NSS file system on Novell® Open Enterprise Server for Linux.

1. Introduction

The MySQL database server is one of the world's most popular open source database and is available on OES NetWare and OES Linux servers.

Novell Open Enterprise Server provides Novell Storage Services™ (NSS) File System for both Linux and NetWare® kernels. Its many features and capabilities include visibility, a trustee access control model, multiple simultaneous namespace support, native Unicode*, user and directory quotas, rich file attributes, multiple data stream support, event file lists, and a file salvage subsystem.

This document explains in six simple steps how a MySQL adminstrator or user can leverage NSS file system available on Novell Open Enterprise Linux Server (OES Linux server) to store the database.

2. System Requirements

  1. OES Linux server must be installed with EVMS as the default volume manager.
  2. During the installation process of Linux server, select "Novell NSS" package. This will install NSS on the OES Linux server.

3. Configuring MySQL

  1. Stop existing MySQL service on the server:
shell> /etc/init.d/mysql stop
  1. Create an NSS volume using the nssmu utility.
    For example, let the volume name be NSSVOL.
    By default, this volume is mounted for use under /media/nss/NSSVOL

  2. Edit the file /etc/passwd, and comment the entry for "mysql" user.

  3. Create an eDirectory user named "mysql"
shell> namuseradd -x <user_context> -g <primary_groupFDN> mysql

For example,
shell> namuseradd -x o=testorg -g cn=admingroup,o=testorg  mysql
  1. Create MySQL data directory in NSS volume, assign appropriate rights. For example,
shell> mkdir /media/nss/NSSVOL/mysql
shell> mkdir /media/nss/NSSVOL/mysql/data
shell> rights -f /media/nss/NSSVOL/mysql -r rwcf trustee mysql.<user_context>.<treename>

where NSSVOL= NSS volume
  1. Create new privilege tables and start MySQL service.
shell> mysql_install_db --user=mysql --datadir=/media/nss/NSSVOL/mysql/data/
shell> mysqld_safe --user=mysql --datadir=/media/nss/NSSVOL/mysql/data/ &

The MySQL server is now configured to use the NSS file system on Novell Open Enterprise Linux Server.






Since 2003

Portal posiada akceptację firmy Novell Polska
Wszystkie materiały dotyczące produktów firmy Novell umieszczono za zgodą Novell Polska
Portal has been accepted by the Novell Polska
All materials concerning products of Novell firm are placed with Novell Polska consent.
NetWare is a registered trademark of Novell Inc. in the United States and other countries.
Windows is a trademark or a registered trademark of Microsoft Corporation in the United States and other countries.
Sybase is a registered trademark of Sybase Inc. in the United States of America.
Other company and product names are trademarks or registered trademarks of their respective owners.