- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: mysql and hpux installation issues
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-27-2007 03:08 AM
тАО08-27-2007 03:08 AM
mysql and hpux installation issues
Has anyone installed mysql on hpux 11.11?
I have downloaded a recent release from mysql in depot format and it installs fine.
However, when I execute the install db script to set up the tables, it errors out. I suspect a permissions issue because i am specifying user mysql. If i specify user root it runs fine. But of course I don't want my tables to be created under root.
And advise?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-27-2007 03:21 AM
тАО08-27-2007 03:21 AM
Re: mysql and hpux installation issues
Make the location of the tables, which is defined in my.cnf owned by user mysql
Provide the exact error codes for further assistance.
In answer to your question, yes I have installed it and used it.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-27-2007 03:40 AM
тАО08-27-2007 03:40 AM
Re: mysql and hpux installation issues
Thank you for your reply.
I cannot find the file you mention:
root-doc# find / -name my.cnf
root-doc#
Here is the error:
root-doc# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1005 Can't create table 'db' (errno: 13)
070827 10:37:54 [ERROR] Aborting
070827 10:37:54 [Note] ./bin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in ./data for more information.
You can try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
and use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-27-2007 08:08 PM
тАО08-27-2007 08:08 PM
Re: mysql and hpux installation issues
what's when you start the script when you're logged in as user mysql and with the option --no-defaults ?
Volkmar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2007 02:07 AM
тАО08-28-2007 02:07 AM
Re: mysql and hpux installation issues
Same results:
$ whoami
mysql
$ pwd
/usr/local/mysql
$ scripts/mysql_install_db --no-defaults
Installing MySQL system tables...
ERROR: 1005 Can't create table 'db' (errno: 13)
070828 9:06:30 [ERROR] Aborting
070828 9:06:30 [Note] ./bin/mysqld: Shutdown complete
Installation of system tables failed!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2007 02:13 AM
тАО08-28-2007 02:13 AM
Re: mysql and hpux installation issues
Can you give us a 'll' of /usr/local/mysql ?
V.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2007 02:16 AM
тАО08-28-2007 02:16 AM
Re: mysql and hpux installation issues
root
root-doc# pwd
/usr/local/mysql
root-doc# ll
total 272
-rwxrwxrwx 1 mysql mysql 19071 Apr 26 13:08 COPYING
-rwxrwxrwx 1 mysql mysql 5139 Apr 26 13:08 EXCEPTIONS-CLIENT
-rwxrwxrwx 1 mysql mysql 8482 Apr 26 16:23 INSTALL-BINARY
-rwxrwxrwx 1 mysql mysql 1410 Apr 26 13:08 README
drwxrwxrwx 2 mysql mysql 8192 Aug 24 07:34 bin
-rwxrwxrwx 1 mysql mysql 801 Apr 26 16:53 configure
drwxrwxrwx 4 mysql mysql 8192 Aug 28 09:06 data
drwxrwxrwx 2 mysql mysql 96 Aug 24 07:34 docs
drwxrwxrwx 3 mysql mysql 8192 Aug 24 07:34 include
drwxrwxrwx 2 mysql mysql 8192 Aug 24 07:34 lib
drwxrwxrwx 4 mysql mysql 96 Aug 24 07:34 man
drwxrwxrwx 8 mysql mysql 8192 Aug 24 07:34 mysql-test
drwxrwxrwx 2 mysql mysql 96 Aug 24 07:34 scripts
drwxrwxrwx 3 mysql mysql 8192 Aug 24 07:34 share
drwxrwxrwx 5 mysql mysql 8192 Aug 24 07:34 sql-bench
drwxrwxrwx 2 mysql mysql 8192 Aug 24 07:34 support-files
drwxrwxrwx 2 mysql mysql 8192 Aug 24 07:34 tests
root-doc#
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2007 02:22 AM
тАО08-28-2007 02:22 AM
Re: mysql and hpux installation issues
run the file 'configure' in your mysql directory.
What's the result?
V.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2007 02:26 AM
тАО08-28-2007 02:26 AM
Re: mysql and hpux installation issues
This is the mysql hp depot version but I ran the configure anyway as you suggested.
But, now there is a problem because it did the work as root automatically.
Can we undo this or should I restore a sys image and try again as user mysql?
root-doc# whoami
root
root-doc# pwd
/usr/local/mysql
root-doc# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h doc password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-28-2007 02:36 AM
тАО08-28-2007 02:36 AM
Re: mysql and hpux installation issues
You've already tested it as root and it worked ...
Can you see what the script has done?
Any tables in data?
I have only the data directory assigned to mysql anything else is owned by root.
If you don't waste to much time, you can restore the system and try it as mysql again.
But maybe you have to run it as root ...
Volkmar