Mysql / PHPMyAdmin

Mysql

MySQL is (as of July 2013) the world’s second most widely used open-source relational database management system (RDBMS). It is named after co-founder Michael Widenius’s daughter, My. The SQL phrase stands for Structured Query Language.

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other ‘AMP’ stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL.

PHPMyAdmin

Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-end to MySQL in 1998, inspired by MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time.

By that time, phpMyAdmin had already become one of the most popular PHP applications and MySQL administration tools, with a large community of users and contributors. In order to coordinate the growing number of patches, a group of three developers registered The phpMyAdmin Project at SourceForge and took over the development in 2001. SourceForge hosts the software download.

All accounts that include MySQL databases also include PhpMyAdmin within the PhpMyAdmin protected web directory. Both details for your database and PhpMyAdmin will be included within your registration confirmation email.

Hosting FTP Information

File Transfer Protocol (FTP) is a standard network protocol used to transfer files from one host to another host over a TCP-based network, such as the Internet.

FTP is built on a client-server architecture and uses separate control and data connections between the client and the server. FTP users may authenticate themselves using a clear-text sign-in protocol, normally in the form of a username and password.

The first FTP client applications were command-line applications developed before operating systems had graphical user interfaces, and are still shipped with most Windows, Unix, and Linux operating systems. Dozens of FTP clients and automation utilities have since been developed for desktops, servers, mobile devices, and hardware, and FTP has been incorporated into hundreds of productivity applications, such as Web page editors.

These are some of the most popular FTP clients which have all been tested against our servers.

FileZilla

FileZilla is a cross platform client (Windows, Linux, *BSD, Mac OS X, and more) that offers tons of features, such as support for FTP, FTP over SSL/TLS (FTPS), and SSH File Transfer Protocol (SFTP). It supports resume and files over 4GB. It has a site manager and transfer queue, a powerful filtering system, an easy to use networking configuring wizard, and much more. Filezilla is GPL and works seamlessly with FileZill Server.

gFTP

gFTP hasn’t been in development for a while, but still stands as a solid FTP solution for the Linux desktop. gFTP features FTP, FTPS (control connection only), HTTP, HTTPS, SSH, and FSP protocols. It also features FTP and HTTP proxy server support, and bookmarks tools. It supports FXP file transfer, UNIX, EPLF, Novell, MacOS, VMS, MVS, and NT (DOS) style directory listings. Though the development of gFTP seems to have stopped (latest stable release in 2008), the software still works on the latest releases of nearly every distribution (tested on Ubuntu 12.10 to make sure).

Free FTP

Free FTP is all about simplicity. From the interface to the features, with Free FTP you will be transferring files quickly and easily. Features include multiple server profiles, the ability to transfer files in binary, ASCII, or auto mode. Free FTP includes drag and drop support and an easy to use and unique bookmarks tool. Free FTP works with Windows XP, Vista, 7, and 8. With the bookmarks tool you can not only save server information but local information – so transferring files from a specific directory to a specific server is as simple as selecting a bookmark and then dragging and dropping the files to be transferred.

BareFTP

BareFTP is another Linux client that makes use of the Mono framework on the GNOME desktop environment. BareFTP focuses on simplicity and supports transfers with the following protocols: FTP, FTP over SSL/TLS (FTPS), and SSH File Transfer Protocol (SFTP). Any level of user would be immediately at home with the BareFTP interface. Unlike gFTP, BareFTP is still in development (though the developer has been on a temporary hiatus due to other projects). Because of the issues with Mono, BareFTP is being ported into a strict Python port.

EU Cookie Directive

On 26 May 2011 the European Commission made the controversial ‘Cookies Directive’ law. It applies to the UK and all european countries. It mandates that the use of cookies on european businesses’ websites must be disclosed and explicit consent for their use be obtained from your users.

SPST CMS can use cookies when tracking code has been enabled (Google Analatics , SiteSearch or PIWIK) customers also have the ability to run self maintained cookie based tracking.

What are cookies

Cookies are a standard method of registering user preferences when people use websites, to ensure a better and more personalised experience. These preferences are stored in a file on your computer’s hard disk drive. For example, a cookie would contain your preferred country of residence so we do not have to ask you this question each time you visit.

Our CMS may use both persistent and session cookies. Persistent cookies are cookies that stay on your computer permanently until you “manually” delete them. Session cookies delete themselves automatically when you leave a website and go to another one or shut down your browser. fcconsultancy has relationships with carefully selected and monitored suppliers to assist in the delivery of a high quality website. Some of these suppliers may also set cookies during your visit in order to meet contractual obligations with us. These cookies do not store any personal details relating to you or your credit cards.

More Information

Data Protection and Free Information (ICO)

Cookies Directive JS (Open Source)

Download ICO white paper (Policy Guide Lines PDF)

Centos – Update System using YUM

Using YUM you can update all software on your CENTOS system, to perform the update run the following commend,

su -c ‘yum update’

Enter the root password when prompted.

You can schedule the system to perform an update each day using a pre-provided script enter the following command to activate,

su -c ‘/sbin/chkconfig –level 345 yum on; /sbin/service yum start’

Enter the root password when prompted.

Linux syslog server setup

This syslog configuration took place using Ubuntu server hosted on ESXI platform.

Edit the rsyslog.conf file to allow the submission of system logs from clients.Use your favourite editor to make the following changes to the rsyslog.conf file.

sudo vim /etc/rsyslog.conf

Uncomment the following lines:
$ModLoad imudp
$UDPServerRun 514
At the bottom of the file include the following entry:
$template TmplAuth,
“/var/log/%HOSTNAME%/%PROGRAMNAME%.log”

Change permissions of the /var/log directory. Change the permissions of the /var/log directory to allow syslog the ability create/change sub-directories and files.

cd /var && sudo chown syslog:syslog log

Restart the rsyslog serviceSave the changes made to the rsyslog.conf file and restart the rsyslog service.

sudo service rsyslog restart

Configure client to send logs to your newly configured Syslog server. For ESS-RAD01 you will need to edit the rsyslog.conf file or syslog.conf file and add the following line.

Ubuntu

sudo vim /etc/rsyslog.conf
*.* @10.0.0.1
 
CentOS/Fedora/RHEL:
sudo vim /etc/syslog.conf
*.* @10.0.0.1
 
FreeBSD/BSD variants:
sudo vim /etc/syslog.conf
Uncomment the following line:
*.* @10.0.0.1

Restart the rsyslog/syslog service on newly configured

Ubuntu

sudo service rsyslog restart
 
CentOS/Fedora/RHEL:
sudo /etc/init.d/syslog restart
 
FreeBSD/BSD variants:
sudo /etc/rc.d/syslog restart

Verify logs are being sent to your syslog serverOn your Syslog server check the “/var/log” directory to see if client log directories have been created.

cd /var/log && ls

 

A reboot from a previous installation is pending.

Server 2008 R2 Ent , during the installation of Exchange 2010 errors on the readiness check.

“A Reboot from a previous installation is pending”

After several reboots the message does not clear. To clear this error you need to remove the “PendingFileRenameOperations” from the registry.

 
HKLM\SYSTEM\CurrentControlSet\Control\SessionManager\PendingFileRenameOperations

ISCSI Shares disapear after server reboot

Whilst building a Veeam server and configuring the backup repository to point to a share on another server, i noticed the backups always failed after the server hosting the shares (And the iscsi drive) rebooted.

It appeared as though the shares are removed during the reboot, after a quick google i found the following Microsoft kb its due to the server service starting before the “Iscsi initiator” service has started , meaning that the drive is not ready when the server applies the shares.

Follow the KB through to ensure the “Server Service” has the “iscsi initiator” as a dependent service or simply complete the following.

Run command prompt as administrator and type

>sc config LanManServer depend= Samss/Srv/MSiSCSI

cmdiscsi

 

Linux / UNIX Recursively Search

Search through a number of files on the command line using grep.

cd /path/to/dir
grep -r “word” .
grep -r “string” .

Ignore case distinctions:

grep -ri “word” .

To display print only the filenames with GNU grep, enter:

grep -r -l “foo” .
You can also specify directory name:
grep -r -l “foo” /path/to/dir/*.c

find command is recommend because of speed and ability to deal with filenames that contain spaces.

cd /path/to/dir
find . -type f -exec grep -l “word” {} +
find . -type f -exec grep -l “seting” {} +
find . -type f -exec grep -l “foo” {} +

Older UNIX version should use xargs to speed up things:

find /path/to/dir -type f | xargs grep -l “foo”

It is good idea to pass -print0 option to find command that it can deal with filenames that contain spaces or other metacharacters:

find /path/to/dir -type f -print0 | xargs -0 grep -l “foo”

 

 

SPST Core – User / Admin Login

Help Document

Product : SPST V5

Revision : 2.1

Login to SPST site admin.

Short video tutorial. Logging into the SPST CMS web system. 

To login to your SPST CMS panel you can

  • Modify your URL directly
  • Click the footer link
  • If present, login to a side module login panel

Modify your URL directly

  • ?p=login
  • login.htm

Example

  • demo.fcconsultancy.co.uk/index.php?p=login
  • demo.fcconsultancy.co.uk/login.htm

Click the footer link

All SPST CMS sites have a footer link, this link redirect to the login page.

footerlogin_529

 

Login Page

login_679

 

Enter your username and password to login.

Once logged into your site you can manage your username and password via EUsers. If you have forgotten or misplaced your username or password please contact support@fcconsultancy.co.uk.