Re: Need Help setting up Mysql on Openserver 6.0

From: Steve M. Fabac, Jr. (smfabac_at_att.net)
Date: 11/25/05 

Date: Fri, 25 Nov 2005 05:08:06 GMT

"Steve M. Fabac, Jr." wrote:
>
> "Steve M. Fabac, Jr." wrote:
> >
> > Boyd Lynn Gerber wrote:
> > >
> > > On Fri, 18 Nov 2005, Steve M. Fabac, Jr. wrote:
> > > > >Boyd Lynn Gerber wrote:
> > > >
> > > > Thanks for that offer. But, I want to evaluate SCO's Openserver 6.0 distribution
> > > > "out of the box" to see if it is of any value. If they are going to distribute
> > > > Mysql with the OS, then they should provide instructions for the "non-wizard"
> > > > on how to get started with the program.
> > > > > Read ...
> > > > > http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html
> > > > > http://dev.mysql.com/doc/refman/5.0/en/mysql-binaries.html
> > > >
> > > > Essentially the same as included with the SCO Doc server.
> > >
> > > I always prefer more information. Please read A.4.1. How to Reset
> > > the Root Password...
> > >
> > > http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
> > >
Snip.

> # mysql -u root -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Snip.

> OKAY!! The following seems to work:
>
> # cat /tmp/mysql-init
> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('29$bob31');
> SET PASSWORD FOR 'root'@'192.168.111.235' = PASSWORD('29$bob31');
> SET PASSWORD FOR 'root'@'unix' = PASSWORD('29$bob31');
> #
>
> Edit /etc/init.d/mysql:
> # start the server
> if test -d $datadir; then
> if test -x $bindir/mysqld_safe
> then
> # Give extra arguments to mysqld with the my.cnf file. This script may
> # be overwritten at next upgrade.
> dspmsg $CAT 3 "Starting %s ... " $MYSQL_LABEL
> > $bindir/mysqld_safe \
> > --init-file=/tmp/mysql-init \
> > --datadir=$datadir \
> > --pid-file=$pid_file >/dev/null 2>&1 &
> if test -w /var/lock/subsys
> then
> touch /var/lock/subsys/mysql
> fi
> :q
>
> # ps -ef | grep mysql
> root 7426 6735 0 17:11:53 ttyp1 00:00:00 grep mysql
> root 3368 1 0 Nov-17 ? 00:00:00 mysqlmanager
> mysql 7395 7372 0 17:03:32 ttyp1 00:00:01 /usr/sbin/mysqld --basedi
> r=/ --datadir=/usr/mysql/data --user=mysql --pid-file=
> root 3267 1 0 Nov-17 ? 00:00:00 mysqlmanager
> root 7372 1 0 17:03:32 ttyp1 00:00:00 /usr/bin/mysqld_safe --in
> it-file=/tmp/mysql-init --datadir=/usr/mysql/data --pi
> #
>
> > AND !!!!
> # mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 2 to server version: 4.1.10a
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> status
> --------------
> mysql Ver 14.7 Distrib 4.1.10a, for unknown-sysv5UnixWare7.1.4 (i686)
>
> Connection id: 5
> Current database:
> Current user: root@localhost
> SSL: Not in use
> Current pager: stdout
> Using outfile: ''
> Using delimiter: ;
> Server version: 4.1.10a
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Server characterset: latin1
> Db characterset: latin1
> Client characterset: latin1
> Conn. characterset: latin1
> UNIX socket: /var/lib/mysql/mysql.sock
> Uptime: 9 min 36 sec
>
> Threads: 2 Questions: 10 Slow queries: 0 Opens: 12 Flush tables: 1 Open tab
> les: 1 Queries per second avg: 0.017
> --------------
>
> mysql>
>
> Also, SQLYog will connect using the 29$bob31 password and fail if the
> password is blank.
>
> OK SCO fix this *** so that the next user (am I the first?) does not have to
> find this thread to get this resolved.
>

Mea culpa.

I have posted several messages to the group with problems I have experienced
evaluating Openserver 6.0 installed on a test system. The first one
concerned how to set up a memfs for /tmp after failing to choose that option
on the installation screen file system layout.

The resolution to that problems seemed to be to manually add the entry into
/etc/default/filesys:

http://groups.google.com/group/comp.unix.sco.misc/msg/ec4f8c1f5fb8fca3
> With the above items as examples, I added the following to /etc/default/filesys:
>
> bdev=/dev/mem mountdir=/tmp mount=yes fstyp=memfs \
> rcmount=yes fsck=no rcfsck=no mntopts=global_swapmax=120000000
> bdev=/dev/mem mountdir=/var/tmp mount=yes fstyp=memfs \
> rcmount=yes fsck=no rcfsck=no mntopts=

What I failed to check was the perms on the /tmp and /var/tmp mount points.

The above modifications to /etc/default/filesys worked but /tmp and /var/tmp
had 755 permissions. After reinstalling Openserver 6.0 and correctly
selecting memfs for /tmp and /var/tmp the resulting /etc/default/filesys
contains the following:
bdev=/tmp mountdir=/tmp mount=yes \
        fstyp=memfs rcmount=yes fsck=no \
        rcfsck=no mntopts=global_swapmax=674234368,rootmode=1777
bdev=/var/tmp mountdir=/var/tmp mount=yes \
        fstyp=memfs rcmount=yes fsck=no \
        rcfsck=no mntopts=rootmode=1777

On the newly reinstalled Openserver 6.0 running mkdev mysql
worked and I was immediately able to execute "mysql" as root
without argument. Even the "help contents" that had failed
previously is now working:

For server side help, type 'help contents'

mysql> help contents
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
   Administration
   Column Types
   Data Definition
   Data Manipulation
   Functions
   Geographic features
   Transactions

mysql>

So, The mkdev mysql script on Openserver 6.0 was not at fault for failing
to setup Mysql correctly with /tmp and /var/tmp with 755 permissions.

I am disappointed that searching the doc server for memfs and /tmp did not
produce usable information on how to set up /tmp as type memfs after I neglected
to make the proper selection during installation.

So I'm tempering my assessment that Openserver 6.0 is not ready for prime time.

Little nagging things are still popping up: Sar 5 5 fails to run at unpredictable
times. with an error message (not recorded). Fdisk on 5.0.6 and 6.0 (where 5.0.6
was installed first in partition 1 and 6.0 was later installed in partition 2)
report an overlap:

Current Hard Disk Drive: /dev/rhd00

        +-------------+----------+-----------+---------+---------+---------+
        | Partition | Status | Type | Start | End | Size |
        +-------------+----------+-----------+---------+---------+---------+
        | 2 | Inactive | UNIX | 550800 | 1147499 | 596700 |
        | 3 | Active | UNIX | 3316 | 550815 | 547500 |
        | 4 | Inactive | DOS (32) | 1 | 3314 | 3314 |
        +-------------+----------+-----------+---------+---------+---------+

Total disk size: 1147500 tracks (256 reserved for masterboot and diagnostics)

Fdisk on 6.0:
Total disk size is 4500 cylinders (35299.1 MB)

                                           Cylinders Approx
Partition Status Type Start End Length % MB
========= ====== =========== ===== === ====== === ======
    1 DOS 0 12 13 0 101.9
    2 UNIX System 13 2159 2147 48 16842.0
    3 Active UNIX System 2160 4499 2340 52 18355.5

The bootblock written with the 6.0 installation will boot the DOS partition
and the 6.0 partition but not the 5.0.6 partition. And initially, using
fdisk to change the active partition to the 5.0.6 partition resulted in the
5.0.6 partition failing to boot, just hanging. I resolved that one by booting
the BackupEdge recovery disk for the 5.0.6 partition and using the "force
boot block" option. Thereafter, I can switch active partitions (via fdisk)
and both 5.0.6 and 6.0 boot ok. 

--
                                      Steve Fabac
                                       S.M. Fabac & Associates
                                        816/765-1670