POLALA.COM
welcome to my space
X
Welcome to:polala.com
Web Design | Video Games | RVs | Religion | Management | Supplements and Vitamins | Software | Basketball | Related articles
Search:  
NAVIGATION - HOME

new in vb need help with mysql

Published by: mike 2009-01-07

  • Just started with VB , I am currently using UBB in my site.

    I have dedicated server (Coblat RQ3) I need to know is MYsql normally installed in my server or not , I found folder in server root called "pgsql" .

    I am not sure is this Mysql folder or not .

    How to install Mysql in the server, please help with hint in installing VB. in my server.

    Regards


  • I run install.php then I got the following :

    You are not running PHP - Please contact your system administrator.

    regard


  • Originally posted by Chris Schreiber
    Originally posted by dany
    MYsql normally installed in my server or not , I found folder in server root called "pgsql" .

    This is actually PostgreSQL, which isn't supported. Follow Eva's instructions for installing PHP and MySQL (Thanks for posting those Eva). i am not sure about that .. what i posted above has proven to work on raq3s before mine and on mine ...

    RaQ4's already come with PHP4 but not MySQL ... so installing MySQL is your concern for that i think...

    bear in mine PHP 4.04pl1 which i have on my new red hat linux server for my vB doesn't have a Zend optimser ready for it yet :(


  • unfortunately.. it's 4:15 am here so i am off to bed soon ...

    have you tried the cobalt mailing list on their support site http://www.cobalt.com ?


  • U gotta be kidding... Now that Sun Microsystems has taken them over, you need another computer just find anything in their support sections... Unbelievable...


  • i have a raq3 as well (not for my vB) but mysql and php4 is not installed by default, you'll have to install it yourself.. after installing myself with help of a few people i made my own how to article for future reference.

    installs PHP4.03pl1 (4.06) with Zend optimser and MySQL 3.22.32 (3.23.46)

    If you need to install latest mysql 3.23.46 you need to download and replace the below four mysql 3.22.x rpms with these

    http://web.tryc.on.ca/mysql/Downloads/MySQL-3.23/MySQL-3.23.46-1.i386.rpm

    http://web.tryc.on.ca/mysql/Downloads/MySQL-3.23/MySQL-client-3.23.46-1.i386.rpm

    http://web.tryc.on.ca/mysql/Downloads/MySQL-3.23/MySQL-devel-3.23.46-1.i386.rpm

    http://web.tryc.on.ca/mysql/Downloads/MySQL-3.23/MySQL-shared-3.23.46-1.i386.rpm


    This guide is to install MySQL 3.22.32 and PHP 4.03pl1 (4.06)on a Raq3 server:

    You first need to login to telnet and switch to root via the command

    # su-

    MySQL installation:
    issue each of these commands and let the server process them

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/MySQL-3.22.32-1.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/MySQL-client-3.22.32-1.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/MySQL-devel-3.22.32-1.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/MySQL-shared-3.22.32-1.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/contrib/i386/perl-DBI-1.14-1.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/contrib/i386/perl-Msql-Mysql-modules-1.2214-1.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/freetype-1.2-7.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/freetype-devel-1.2-7.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/freetype-utils-1.2-7.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/gd-1.3-5.i386.rpm

    rpm -Uvh ftp://ftp.cobaltnet.com/pub/experimental/raq3/gd-devel-1.3-5.i386.rpm

    PHP 4.06 installation:
    Download and put into your RaQ3 server's admin directory the PHP4.03pl1 source code from
    http://www.php.net/do_download.php?download_file=php-4.0.6.tar.gz&source_site=www.php.net

    Still in telnet as root change to the directory which has the PHP 4.03pl1 source code

    tar zxvf php4.0.6.tar.gz
    cd php-4.0.6
    ./configure --with-mysql --with-apxs
    make
    make install

    cd /etc/httpd/conf
    pico srm.conf
    ## add to srm.conf:
    DirectoryIndex index.html index.htm index.shtml home.html home.htm index.php

    AddType application/x-httpd-php .phtml
    AddType application/x-httpd-php .php3
    AddType application/x-httpd-php .php
    AddType application/x-httpd-php-source .phps
    ## save file

    pico httpd.conf
    ## change the php4 LoadModule, thats allready added to httpd.conf:
    LoadModule php4_module /usr/lib/apache/libphp4.so
    ## save file

    Zend Optimiser installation:
    Still in telnet as root - Download Zend Optimiser for Linux and upload
    to the same directory as PHP4.03pl files and issue the following commands

    ####### Zend optimizer installation
    mkdir /usr/local/Zend
    mkdir /usr/local/Zend/lib
    cp ZendOptimizer.so /usr/local/Zend/lib

    pico -w /usr/local/lib/php.ini
    ####### CHANGE ###########
    engine = Off
    register_globals = On
    register_argc_argv = On
    magic_quotes_gpc = On
    ####### ADD ###########
    zend_optimizer.optimization_level=15
    zend_extension="/usr/local/Zend/lib/ZendOptimizer.so"
    #######################

    ####### ADD before NameVirtualHost 123.123.123.123 (include the ### PHP
    stuff)

    ExtendedStatus On

    order allow,deny
    allow from all
    require user admin
    Authname ServerStatus
    Authtype Basic
    SetHandler server-status

    #################################PHP SAFE MODE############################

    php_admin_flag engine On
    php_admin_value doc_root /home/sites/home
    php_admin_value safe_mode_exec_dir .:/home/sites/home
    php_admin_value open_basedir .:/tmp:/home/sites/home
    php_admin_value include_path .:/home/sites/home

    ###############################END PHP SAFE MODE###########################
    php_admin_flag engine On

    ## save file and restart Apache by issuing

    /etc/rc.d/init.d/httpd stop
    /etc/rc.d/init.d/httpd start

    To test to see if it works, save a file named phpinfo.php and place in it



    Then upload and view in browser.

    Note: with 'php_admin_flag engine On' after the END PHP SAFE MODE part you will enable PHP for every virtual site and the main server site as well.

    SECURITY RISK:
    This is a security risk if you are hosting other webmasters/virtual sites since this allows any of your virtual sites/webmasters to read any public readable files on the system, write anywhere, etc - equivalent to giving telnet access to your server.

    So to be safe, you use PHP SAFE MODE - instead, replace 'php_admin_flag engine On' (with below) just before your first

    NameVirtualHost 123.123.123.123

    replace with the below


    php_admin_flag engine On
    php_admin_value doc_root /home/sites/site1
    php_admin_value safe_mode_exec_dir .:/home/sites/site1
    php_admin_value open_basedir .:/tmp:/home/sites/site1
    php_admin_value include_path .:/home/sites/site1



    php_admin_flag engine On
    php_admin_value doc_root /home/sites/site2
    php_admin_value safe_mode_exec_dir .:/home/sites/site2
    php_admin_value open_basedir .:/tmp:/home/sites/site2
    php_admin_value include_path .:/home/sites/site2


    and so on for each virtual site you want to enable PHP for. For me i have 30 sites on my raq3 from site1 to site30, so i have 30 entries like


    php_admin_flag engine On
    php_admin_value doc_root /home/sites/site1
    php_admin_value safe_mode_exec_dir .:/home/sites/site1
    php_admin_value open_basedir .:/tmp:/home/sites/site1
    php_admin_value include_path .:/home/sites/site1


    where you change the site1, site2, site3 ... site30 to enable PHP. Makes offering PHP safe :)


  • Originally posted by dany
    MYsql normally installed in my server or not , I found folder in server root called "pgsql" .

    This is actually PostgreSQL, which isn't supported. Follow Eva's instructions for installing PHP and MySQL (Thanks for posting those Eva).


  • Eva... Thanks for your quick reply from way down under...

    Not knowing anything about the functions of what I just bought, from what I am able gather, the RAQ4i is able to support PHP but doesn't have it installed...

    A friend of mine is attempting to install mySQL into the server but it appears that he's running into a few glitches...

    If your going to be on line for a bit, I'll see if I can get him to come over here and you guy'z can confer directly...

    Ed The Cannuck


  • Eva or anybody in the know... Newbie here...

    I've just purchased a RaQ 4i and am trying to have it configured to suite vB2 (when it's released), with the latest versions of PHP and mySQL...

    Will the technique and links as posted above be applicable to the RAQ4i...

    [Edited by edpak on 01-18-2001 at 12:47 PM]





  • Where's The Advantage In Windows Genuine Advantage?
    Stocks Bounce After S&P Joins Bear Market

  • are we usa more of a adaptocracy then democracy economic socialism is going on here 039 s proof
  • ps3 online game help
  • quick hel 10 points wtf why is spore dodgy
  • have you ever been deceived misled or made false promises how do you get over negativity in life
  • best way of sneak out night
  • why do i keep having nightmares like this
  • should i leave this married korean man
  • how to learn fast hard guitar solos
  • cartoons with english subtitles
  • where can i find tasteful advice on changing my wife 039 s diaper she 039 s bed ridden and paralyzed on right
  • is the word proletariat singular or plural
  • what is a hyperlink
  • best way of sneaking out night
  • is it safe to mod games
  • doxycycline takers
  • question about the playstation 3 please answer if you have one
  • depressed filled within me
  • really serious having problems with my little brother
  • why was i so outspoken to my in laws am i in the wrong
  • how long does a man go through a mid life crisis for
  • what does the term 039 lip service 039 mean
  • how different do you think things would be if gore had become president in 2000
  • medicinal marijuana completely legalize or keep it illegal
  • a big usa of 52 states is unmanageable shouln 039 t it be divided into 4 or 5 smaller countries
  • is there any word for less high
  • oil gargling can anyone tell me what it 039 s about can it help sinusitis
  • anyone here played burnout paradise on ps3
  • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about new in vb need help with mysql , Please add it free.

    About us -Site map -Advertisement -Jion us -Contact usExchange linksSponsor us
    Copyright© 2008 polala.com All Rights Reserved
    Site made&Support support@polala.com    E-mail: web@polala.com