mysql too many connections

By , August 31, 2010 7:31 PM

mysql too many connections

go to my.ini

max_connections=500

Please note that an instruction of the form
set-variable=max_connections=500
should be placed in the [mysqld] section. Otherwise MySQL will ignore it.

Adding a Mysql user with privileges

By , August 14, 2010 9:17 PM

CREATE USER ‘monty’@’%’ IDENTIFIED BY ‘some_pass’;
GRANT ALL PRIVILEGES ON *.* TO ‘monty’@’%’
WITH GRANT OPTION;

TRIXBOX on your NETWORK, Trixbox and Samba

By , August 14, 2010 7:57 PM

[global]
log file = /var/log/samba/log.%m
load printers = no
smb passwd file = /etc/samba/smbpasswd
browseable = no
server string = trixbox PBX
path = /
workgroup = workgroup
os level = 2000
username map = /etc/samba/smbusers
preferred master = no
max log size = 50

[share]
browseable = yes
writeable = yes
write list = root
comment = server
valid users = root
path = /
public = yes

Static IP-where to change it, at Asterisk or at TrixBox?

By , August 14, 2010 7:46 PM

system-config-network

How to Install Openfire on Trixbox

By , August 14, 2010 7:34 PM

make a DB in mysql
login to mysql
mysql -u root -p
then
CREATE DATABASE `openfire`;
CREATE USER ‘openfire’@’localhost’ IDENTIFIED BY ‘password’;
GRANT USAGE ON *.* TO ‘openfire’@’localhost’ IDENTIFIED BY ‘password’ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON `openfire`.* TO ‘openfire’@’localhost’;
FLUSH PRIVILEGES;
quit

Thomas Challenger Thomas Challenger