mysql/ 0000777 0000000 0000000 00000000000 11301211130 013071 5 ustar admin administrators mysql/inc/ 0000777 0000000 0000000 00000000000 11277216600 013665 5 ustar admin administrators mysql/inc/98-phpmyadmin.conf 0000766 0000000 0000000 00000001074 11270362207 017141 0 ustar admin administrators # **********************************************************************
# Lighttpd web server configuration for OpenNMP
# AdNovea - oct 2009
# phpMyAdmin Configuration
# **********************************************************************
# Rule to restric access to phpMyAdmin for OpenNMP admin account only
$HTTP["url"] =~ "/phpmyadmin/" {
auth.backend = "htpasswd"
auth.backend.htpasswd.userfile = "/opt/etc/htpasswd"
auth.require = ( "/phpmyadmin" =>
(
"method" => "basic",
"realm" => "PHPMyAdmin Interface",
"require" => "user=admin"
)
)
} mysql/inc/config.inc.php 0000766 0000000 0000000 00000004155 11277313164 016424 0 ustar admin administrators
mysql/inc/my.cnf 0000766 0000000 0000000 00000005265 11270362207 015011 0 ustar admin administrators # Unslung MySQL config file.
# Based on my-small.cnf
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# /opt/etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /opt/var) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
# Set password for SQL queries during NPKG installation
password = admin
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
user = root
datadir = /opt/var/lib/mysql
port = 3306
socket = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
net_buffer_length = 8K
thread_stack = 64K
myisam_sort_buffer_size = 8M
#skip-locking
#skip-name-resolve
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id = 1
# Uncomment the following if you want to log updates
#log-bin
# Uncomment the following if you are NOT using BDB tables
skip-bdb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /opt/var/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /opt/var/
#innodb_log_arch_dir = /opt/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysql.server]
user=root
[safe_mysqld]
mysql/inc/cfg-mysql.php 0000766 0000000 0000000 00000006222 11277314227 016307 0 ustar admin administrators window.location='$url_npkg&action=setup&npkg=$npkg';";
// NPKG Configuration page header
$show_enable = true; $show_disable = true; $show_remove = true;
include("npkg_head.php");
// Set MySQL params (disable the service before updating)
if (isset($_POST['Mysql_port'])) {
exec(WRITE_HTTP."npkg.cgi?action=$npkg&set_param=".(isset($_POST['chk_Networking'])?"true":"false")."&port=".$_POST['Mysql_port'].WRITE_HTTP_END);
echo $url_reload;
}
// Reset MySQL password
if (isset($_POST['reset'])) {
exec(WRITE_HTTP."npkg.cgi?action=$npkg&reset_pwd=ok".WRITE_HTTP_END);
echo $url_reload;
}
// Reinitialize Database
if (isset($_GET['reset']) && ($_GET['reset'] == "db" )) {
exec(WRITE_HTTP."npkg.cgi?action=$npkg&reset_db=ok".WRITE_HTTP_END);
echo $url_reload;
}
// Configuration page
$output = null; exec(CMD_CAT." /opt/etc/my.cnf | ".CMD_GREP." -i skip-networking",$output); $networking = ($output[0]=="#skip-networking"?true:false);
$output = null; exec(CMD_GETCFG." 'mysqld' 'port' -f /opt/etc/my.cnf",$output); $port = $output[0];
echo "
";
?> mysql/inc/mysqld.sh 0000766 0000000 0000000 00000014333 11277205515 015542 0 ustar admin administrators #!/bin/sh
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind
# MySQL daemon start/stop script.
# Usually this is put in /etc/init.d (at least on machines SYSV R4 based
# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
# When this is done the mysql server will be started when the machine is
# started and shut down when the systems goes down.
# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 64 36
# description: A very fast and reliable SQL database engine.
# Comments to support LSB init script conventions
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $local_fs $network $remote_fs
# Should-Start: ypbind nscd ldap ntpd xntpd
# Required-Stop: $local_fs $network $remote_fs
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: start and stop MySQL
# Description: MySQL is a very fast and reliable SQL database engine.
### END INIT INFO
# If you install MySQL on some other places than /opt, then you
# have to do one of the following things for this script to work:
#
# - Run this script from within the MySQL installation directory
# - Create a /etc/my.cnf file with the following information:
# [mysqld]
# basedir=
# - Add the above to any other configuration file (for example ~/.my.ini)
# and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
# below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.
basedir=
# The following variables are only set for letting mysql.server find things.
# Set some defaults
datadir=/opt/var
pid_file=
if test -z "$basedir"
then
basedir=/opt
bindir=/opt/bin
else
bindir="$basedir/bin"
fi
#
# Use LSB init script functions for printing messages, if possible
#
lsb_functions="/lib/lsb/init-functions"
if test -f $lsb_functions ; then
source $lsb_functions
else
log_success_msg()
{
echo " SUCCESS! $@"
}
log_failure_msg()
{
echo " ERROR! $@"
}
fi
PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin
export PATH
mode=$1 # start or stop
case `echo "testing\c"`,`echo -n testing` in
*c*,-n*) echo_n= echo_c= ;;
*c*,*) echo_n=-n echo_c= ;;
*) echo_n= echo_c='\c' ;;
esac
parse_arguments() {
for arg do
case "$arg" in
--basedir=*) basedir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
--datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
--pid-file=*) pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
esac
done
}
wait_for_pid () {
i=0
while test $i -lt 35 ; do
sleep 1
case "$1" in
'created')
test -s $pid_file && i='' && break
;;
'removed')
test ! -s $pid_file && i='' && break
;;
*)
echo "wait_for_pid () usage: wait_for_pid created|removed"
exit 1
;;
esac
echo $echo_n ".$echo_c"
i=`expr $i + 1`
done
if test -z "$i" ; then
log_success_msg
else
log_failure_msg
fi
}
# Get arguments from the my.cnf file,
# groups [mysqld] [mysql_server] and [mysql.server]
if test -x ./bin/my_print_defaults
then
print_defaults="./bin/my_print_defaults"
elif test -x $bindir/my_print_defaults
then
print_defaults="$bindir/my_print_defaults"
elif test -x $bindir/mysql_print_defaults
then
print_defaults="$bindir/mysql_print_defaults"
else
# Try to find basedir in /etc/my.cnf
conf=/etc/my.cnf
print_defaults=
if test -r $conf
then
subpat='^[^=]*basedir[^=]*=\(.*\)$'
dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
for d in $dirs
do
d=`echo $d | sed -e 's/[ ]//g'`
if test -x "$d/bin/my_print_defaults"
then
print_defaults="$d/bin/my_print_defaults"
break
fi
if test -x "$d/bin/mysql_print_defaults"
then
print_defaults="$d/bin/mysql_print_defaults"
break
fi
done
fi
# Hope it's in the PATH ... but I doubt it
test -z "$print_defaults" && print_defaults="my_print_defaults"
fi
#
# Test if someone changed datadir; In this case we should also read the
# default arguments from this directory
#
extra_args=""
if test "$datadir" != "/opt/var"
then
extra_args="-e $datadir/my.cnf"
fi
parse_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`
#
# Set pid file if not given
#
if test -z "$pid_file"
then
pid_file=$datadir/`/bin/hostname`.pid
else
case "$pid_file" in
/* ) ;;
* ) pid_file="$datadir/$pid_file" ;;
esac
fi
# Safeguard (relative paths, core dumps..)
cd $basedir
case "$mode" in
'start')
# Start daemon
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.
echo $echo_n "Starting MySQL"
$bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file $2 $3 >/dev/null 2>&1 &
wait_for_pid created
# Make lock for RedHat / SuSE
if test -w /opt/var/lock/subsys
then
touch /opt/var/lock/subsys/mysql
fi
else
log_failure_msg "Can't execute $bindir/mysqld_safe"
fi
;;
'stop')
# Stop daemon. We use a signal here to avoid having to know the
# root password.
if test -s "$pid_file"
then
mysqld_pid=`cat $pid_file`
echo $echo_n "Shutting down MySQL"
kill $mysqld_pid
# mysqld should remove the pid_file when it exits, so wait for it.
wait_for_pid removed
# delete lock for RedHat / SuSE
if test -f /opt/var/lock/subsys/mysql
then
rm -f /opt/var/lock/subsys/mysql
fi
else
log_failure_msg "MySQL PID file could not be found!"
fi
;;
'restart')
# Stop the service and regardless of whether it was
# running or not, start it again.
$0 stop
$0 start
;;
'reload')
if test -s "$pid_file" ; then
mysqld_pid=`cat $pid_file`
kill -HUP $mysqld_pid && log_success_msg "Reloading service MySQL"
touch $pid_file
else
log_failure_msg "MySQL PID file could not be found!"
fi
;;
*)
# usage
echo "Usage: $0 start|stop|restart|reload"
exit 1
;;
esac
mysql/mysql.ini 0000766 0000000 0000000 00000003520 11330551364 014762 0 ustar admin administrators ;#################################
;
; ABSTRACT: NPKG parameters
;
; HISTORY:
; 2009/09/28 Written by Laurent (Ad'Novea)
;
; This program is distributed in the hope that it will be useful,
; but WITHOUT ANY WARRANTY; without even the implied warranty of
; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
; See the GNU General Public License for more details.
;
;#################################
;
[npkg]
; NPKG Plugin name
Name = MySQL
;
; NPKG Plugin version or software version for application
Version = 4.1.22-3
;
; Date of NPKG development of date of the application release
Date = 2009-10-06
;
; NPKG author /maintainer or application provider
Author = Sun
;
; Hardware platform supported by the current NPKG (use space as list separator)
Models = NMP-1000
;
; Oldest OpenNMP installed version that could be used to run this NPKG
Engine = "0.04.01"
;
; NPKG Category (please keep consistency with already deployed plugins)
Category = Applications
;
; Dependencies from other NPKG. The NPKG dependencies will be installed before the current one in automatic mode (use space as list separator)
Dependencies = Optware
;
; IPKG modules required in the order of installation (use space as list separator)
Ipkg = readline ncurses mysql php-mbstring php-mysql phpmyadmin
;
; Script or program to Start/Stop. it will be linked in the /opt/etc/init.d directory for handling execution priority
Service = mysql.sh
;
; Process priority (above 99 for none system NPKG) . There can be 2 different values: first is for Start and second for Kill if needed (use space as list separator)
Priority = 70
;
; Status of the NPKG. Normally UNKOWN after a first installation. Can be set to TRUE for NPKG that does not need to be Enabled/Disabled
Enable = UNKNOWN
;
; MD5 is managed by the NPKG installation procedure. Does not need to be given here
MD5 =
mysql/images/ 0000777 0000000 0000000 00000000000 11277226077 014372 5 ustar admin administrators mysql/images/img-mysql.png 0000766 0000000 0000000 00000007133 11270362207 017011 0 ustar admin administrators PNG
IHDR @ @ iq tEXtSoftware Adobe ImageReadyqe<