Tag: MySQL

LAMPP

by admin on Apr.30, 2012, under News

LAMP is a popular open source web platform commonly used to run dynamic web sites and servers. It includes Linux, Apache, MySQL, and PHP/Python/Perl and is considered by many the platform of choice for development and deployment of high performance web applications which require a solid and reliable foundation.

This appliance includes all the standard features in TurnKey Core, and on top of that:
SSL support out of the box.
PHP, Python and Perl support for Apache2 and MySQL.
PHPMyAdmin administration frontend for MySQL (listening on port 12322 – uses SSL).
Postfix MTA (bound to localhost) to allow sending of email from web applications (e.g., password recovery)
Webmin modules for configuring Apache2, PHP, MySQL and Postfix.

A separate LAPP stack appliance features PostgreSQL instead of MySQL.

this program also available on our VPS images.

Leave a Comment :, , , , , , , more...

Stable All Revisions

by admin on Apr.15, 2012, under News

Exim Maildir updated to 4.69-15:
Bug 4057: Fix zcat path for exigrep
Enable Dovecot Authentication
Install libperl.so into correct multiarch shlib directory
Update libdkim to 1.0.16
Continue build when invocation of cPanel patch scripts fail
Update sendmail binary to complain when not setgid mailnull
Updated libspf2 to 1.2.9
Updated libdomainkeys to 0.69
Removed redundant call to restartsrv in post install scriptlet

Pure-FTPd updated to 1.0.21-7:
Applied patch to allow setting cipher suite

Courier-IMAP updated to 4.4.1
Courier-Authlib updated to 0.61.0
MySQL 5 updated to 5.0.67

Leave a Comment :, , , , , , , , , , more...

cPanel Tutorial

by admin on Apr.04, 2012, under News

cPanel is a web based control panel tool, which will help you manage your hosting account through a web interface instead of a console. With cPanel you are able to accomplish your tasks faster and even non-professionals can easily and painlessly operate their website via cPanel.

The cPanel tutorial is part of the rich collection of web hosting tutorials, which IGN/IndoVPS experts have prepared for everyone. Find out how to start your website, how to promote it, how to deal with cPanel, webmail and FTP.

cPanel offers a rich set of features, ranging from adding an email address to managing sub-domain names. This tutorial will focus on the tasks involved with putting together and maintaining a web site.

CPanel Tutorial includes detailed instructions about:

  • How to set the Preferences in your cPanel;
  • How to manage Mail accounts and services with cPanel;
  • How to use the tools in the Files section: File manager and FTP manager;
  • How to use the tools in the Security section: Pass protected directories, IP Deny manager, and HotLink protection;
  • How to manage Domains via cPanel: Parked domains and Addon domains;
  • How to use the Logs tools for checking statistical data;
  • How to manage Databases via cPanel: there is a special MySQL tutorial, for managing MySQL databases;
  • How to manage Databases via cPanel: there is a special PostgreSQL tutorial, for managing PostgreSQL databases;
  • How to use the tools in the Software/Services section;
  • How to use the Advanced tools, such as Cron Jobs;
  • How to make Website backup via CPanel;
  • How to check the cPanel ports.

IGN/IndoVPS has long experience in providing web space for CPanel managed sites. Our web hosting service is an excellent choice for any website since it offers the richest set of features, cPanel-expertized support team and lots of FREE PHP tools like blogs, galleries, CMS, shopping carts, etc.

Incoming search terms:

cpanel how to
Leave a Comment :, , , , , , , , , , more...

I want apache 2.0, php 5 and mysql 5

by admin on Mar.23, 2012, under DirectAdmin

DirectAdmin essentially will work with any version of the software you want (within reason). You can use these newer versions of the software should you with to have them.
*** For Apache 2.2 and php 5.x, we have a new custombuild script available:
http://files.directadmin.com/services/custombuild/1.1. It will install both apache 2.2 and php 5 automatically for you. It also contains code for installing mysql 5. The custombuild script is consider the more recent way to install apache 2, php 5 and mysql 5. The rest of the guide will still work, but it’s more time consuming.


To convert apache 1.3 to apache 2.0, use this guide:
directadmin.com/features.php?id=441

For php 5, use this guide (after you are running the apache version you want to have):
help.directadmin.com/item.php?id=135

Regarding MySQL 5.0, you must first decide if you are eligible for the version change. If you are running MySQL 4.1.x or higher, then there won’t be any issues. If you are running MySQL 4.0.x or lower, then you have to take note of the following:
There passwords and table format changes between 4.0 and 4.1. Updating tables to the 4.1 format is not too difficult after the update is done:

mysql_fix_privilege_tables –user=da_admin –password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2`

**However**, the password format cannot be converted to the new password format in 4.1. You have 2 choices:
1) After updating, go through all MySQL accounts and resave their passwords. You will need to know their plaintext password to do this. This is ideal so that you are using the latest formats and do not need to worry about compatibility issues with future releases.
2) Retain the old password formats and tell the new version of mysql to use those old formats by adding:

[mysqld]
old_passwords

into your /etc/my.cnf file, then restart mysqld. You will need to create this file.
This 2nd option is good to save time, but if you ever need to transfer the accounts to a new server already running MySQL 4.1 or higher, you will need to resave all mysqld password for that transferred account. The MySQL server should have all passwords in the same format.. either the new one, or the old one. If there are already account in the new format, you need to resave the passwords to it.
Related guide: directadmin.com/features.php?id=466
Once you’ve decided if the update is for you, use these guides to do it:
FreeBSD/Debian:
help.directadmin.com/item.php?id=106
You will need to get the binaries for your particular OS version. If you cannot file them on files.directadmin.com/services, then go to dev.mysql.com and download the binaries for your system. We do not have any special compile options, and we use all stock binaries from dev.mysql.com whenever possible. **Note** that the guide there contains freebsd binaries. Debian binaries would have to be downloaded if you use Debian. The same instructions apply.
Redhat/Fedora/CentOS (anything with rpms):
Conversion with rpms is quite easy (note the above notices about moving from 4.0 to 4.1 or higher still apply).
Download the 4 MySQL rpms that you want to use, either from files.directadmin.com or from dev.mysql.com. You’ll need the server, client, shared and devel rpms. You must not have any mismatched versions. We recommend generic i386 rpms. If you have 64-bit system, then you’ll need binaries specific to your system (dev.mysql.com has everything you’ll need)
Use wget to download all 4 rpms, then use "rpm -Uvh file.rpm" to update/install them, for example:

mkdir mysql
cd mysql
wget http://files.directadmin.com/services/all/mysql/MySQL-client-5.0.37-0.i386.rpm
wget http://files.directadmin.com/services/all/mysql/MySQL-devel-5.0.37-0.i386.rpm
wget http://files.directadmin.com/services/all/mysql/MySQL-server-5.0.37-0.i386.rpm
wget http://files.directadmin.com/services/all/mysql/MySQL-shared-5.0.37-0.i386.rpm
rpm -Uvh MySQL-*-5.0.37-0.i386.rpm
/sbin/service mysqld restart

Again, keep in mind any changes you may need to do to your database to make this version work.
If you have a clean DirectAdmin install without any databases on it yet and you wish to install the new version, it would likely be easier to use this guide to move cleanly to the version you want: help.directadmin.com/item.php?id=96. It will install all data and passwords after deleting the previous data (hence, youll need a new install first because any databases are going to be lost). For the guide, you’d replace the 4.0 rpms used in the example and simply download the 5.0.x version mentioned above.
It’s also recommended you do a full php recompile to load in MySQL’s current version of the client libraries. Hence, if you are going to be updating php anyway, do MySQL first.

Incoming search terms:

update mysql directadmin
Leave a Comment :, , , more...

mod_ssl: Init: Failed to generate temporary 512 bit RSA private key

by admin on Nov.10, 2011, under DirectAdmin

This error appears to show up sometimes when using MySQL 5 with –with-mysql=/usr.
There have been reports that changing it to –with-mysqli=/usr/bin/mysql_config will fix this, but when I tried it, the mysql client api in php was set to mysql 3, so it wasn’t quite working. The solution I used was to have them both in the configure.php:

–with-mysql=/usr \
–with-mysqli=/usr/bin/mysql_config \

Then recompile php:

./build clean
./build php n

Then I edited the /etc/httpd/conf/httpd.conf and changed:

SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
#SSLRandomSeed startup file:/dev/random 512
#SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random 512
#SSLRandomSeed connect file:/dev/urandom 512

To

#SSLRandomSeed startup builtin
#SSLRandomSeed connect builtin
#SSLRandomSeed startup file:/dev/random 512
SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random 512
SSLRandomSeed connect file:/dev/urandom 512

Quite possibly, only the changes to the httpd.conf are actually required, but adding the extra functionality of mysqli probably won’t hurt any.
I also upgraded MySQL to 5.0.41 (this case, it was a 64-bit server):
http://files.directadmin.com/services/all/mysql/64-bit/

Incoming search terms:

512 bit,error] init: failed to generate temporary 512 bit rsa private key
Leave a Comment :, , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Kontak

Budhi Indah A 31
Cimindi Cimahi 40514
West Java
Indonesia

Phone/SMS :
Info/Bantuan : 62-8158-6270622
Billing/konfirmasi : 62-8888-763551

Self Advertise


My site is worth $7548.2.
How much is yours worth?