Gary.

How to change your SSH port:

having the default port 22 to something else on your hosting server can be something like preventing the hackers from accessing your server from the front door. Though you should note that this process would not make your server 100% safe from intrusion, but it can definitely keep professional hackers busy with finding other vulnerabilities on the server. However, changing the port of your SSH can add to the security of your server.

Do the step by step guide below.

# Edit she SSH config file:

nano /etc/ssh/sshd_config

Search for the line that has the value: #port 22

Change this and uncomment to something like:

port 46987

Or you can use any port assuming it's not being used by another service.

Once done, Save the configuration file:

Restart the ssh service by:

/etc/init.d/sshd restart

Please note, If you use a firewall open the port your changing to.

Well, The majority of the server runs from /var, So with heavy mysql then yes you will see a gain, If not the CPU then it will be the I/O.

I done this on many servers, Mostly putting it on a different HDD and I seen loads drop by 70% but moving it to /home is just as good.

High CPU from mysql, Full /var but fast /home HDD, Then move your mysql to a new partition for faster response times, Better CPU and lower I/O.

Just follow the guide below for moving the mysql from /var to /home, But please BACKUP ! I will not be held responsible for errors / mistakes.

First stop services that use mysql, such as mysql itself or any httpd applications.



Edit and change the my.cnf:


nano /etc/my.cnf

#Now in the mysqld section add the following:

pid-file = /home/mysql/mysqld.pid
socket = /var/lib/mysql/mysql.sock

datadir = /home/mysql
basedir = /home/mysql


rsync -vrplogDtH /var/lib/mysql/ /home/mysql/
rsync -vrplogDtH /var/lib/mysql/ /home/mysql/

#Set the mysql.sock so that it functions correctly:

ln -s /home/mysql/mysql.sock /var/lib/mysql/mysql.sock
rm -rf /tmp/mysql.sock
ln -s /home/mysql/mysql.sock /tmp/mysql.sock

#Restart the mysql service so it is on the new parition:

killall -9 mysqld

service mysql start

That's it, Reload your website - If it loads then all is good, If not you made a Boo Boo !

I am getting below error:

 apachectl: command not found

How do I fix it?

in ssh run:

updatedb

then run the command

Most main one is to tail the server error logs to see what's happening.

You can do this by SSH with the command:

tail -f /var/log/messages

Think your server is under a SYS attack ? Check the connections per IP:

netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

Block an IP in IP tables:

iptables -A INPUT -s ***.***.***.*** -j DROP

Optimize all tables on the server

mysqlcheck -u root --optimize --all-databases

Optimize and repair all tables on the server:

mysqlcheck -u root --repair --optimize --all-databases

Gary.

Everything is looking fine but hense, You have 8GB and your allowing 32MB per script ? :whistle: I would up that to atleast 96MB and then let that monster processor do the work.

No matter what people post saying my.cnf, http,conf ect you can only configure it to the modules running and what apache, Mysql and enviroment you have / Host.

Edit: fixed the problem, Thanks for the upload.

Worked perfect - Thank you once again for your free help and support :D

What was the exact error? if the query is structured properly you won't see an error, even if nothing is deleted.

If you can give me the exact response from the database server, we can go from there :)

I go to delite and all I get is:

IP.Board Message
You cannot remove this setting group as it still contains active settings. Please remove the settings inside it first.

what you mean database error, it shows nothing.

Yeah I done it like you said - All the others were fine except that one.

Hi there,Whoah, I'm so sorry to say that, but I'm very disappointed with this Mod :(My board is pretty large (1.7 million posts) and :1. This script runs 50 000 topics at a time !! It's insane. I launched it a long time ago, and it is still running.2. What happens for 50000+ topics ? The script should build incremental files, like topics1.xml, topics2.xml, etc.3. It should only run for topics that have not been already inserted in the sitemap.I'm so sorry, but this script is OK for only very small boards.I have to uninstall it. :unsure: Anyway, thanks for your work.

ditto :)


Also - this does not exist: DELETE FROM {prefix}_core_sys_settings_titles WHERE conf_title_keyword='sitemap' LIMIT 1;

Now in Ststem ? Forums ? Sitemap Generator v1.0.3 (5 settings)
You can specify certain settings for your sitemap generator.

All I see is select group ! How can I remove this too.

I un installed this:

Sitemap Generator v1.0.3 (5 settings)
You can specify certain settings for your sitemap generator.

But this still shows in forum settings: How can I remove this as when I do I get:

P.Board Message
You cannot remove this setting group as it still contains active settings. Please remove the settings inside it first.


Somone help me out asap please.

Thank you for the reply - Fixed it now :D :wub: lol

Ant - I have started to have problems since I updated.

When we tune in via media player - The image does not show - Now I opened the link as a txt and the file shows:

<banner href="//www.my-website.com/public/style_images/7sins-pride/radio_images/mediaplayer.jpg">

It should show:

<banner href="http://www.my-website.com/public/style_images/7sins-pride/radio_images/mediaplayer.jpg">

Why is the http: missing - This is causing the image to fail, I also do not know where its calling the links from or I would check this out, But, Ill ask you as you would know the exact problem.

My current version is: 9.1

Update - The problem is, Whjen I make a change on the radio it strips the key from the licence and I have to manually add it again to allow my site to load.

need support on this ASAP

Ant, I have a slight problem.

Im running 9.1 and now I cannot run more than 3 hooks, Its seems like the licence key is being stripped, Its not saving in the database causing an error when all 3 hooks are active.

I guess I need to insert a special key.


I will also PM you and where the site is licensed to.

Thanks charles ! Ill dig out the mods and figure out what I changed :P

yes I edited some php files for a few modifications but is every file affected on the upgrade, Surly not.

you say upload all fiels for the upgrade from 3.0.2 to 3.0.3 ?

If I do this surly I would lose lots of modifications right ?