plainblack.com
Username Password
search
Bookmark and Share

    

Install WRE 0.9.4 on VPS

User sysred
Date 7/2/2015 3:04 am
Views 6516
Rating 0    Rate [
|
]
Previous · Next
User Message
sysred

Hi,

I'm trying to install WRE on a CentOS 6.5 Final x64, which is running on a VPS.

The VPS already has an Apache server installed, and also a mySQL server installed, too.


I've tried , without success, to use the steps described at the first option in:

http://www.webgui.org/community-wiki/mysql-installation-options

I need to know how to point to my existing mySQL at wre.conf without creating a new daemon. I just want to create the tables.

Any help would be appreciated.

Regards

--- (Edited on 7/2/2015 3:04 am [GMT-0500] by sysred) ---



Back to Top
Rate [
|
]
 
 
scottwalters

I think we talked on IRC, and I'm glad you posted here.  Perhaps someone else can help you.  I think this would require significant mucking about by someone who knows what they're doing, so you might consider subcontracting out this piece of setup.  I think there's a Wiki page of consultants around here somewhere.

It's not the wre.cnf you're pointing mysql at but two different mysql.cnfs.  Convincing each to look at their own would be the first trick.  I think it would be way easier to just use one mysqld.

Setting up two Apache instances also is going to require particular configuration.

I think your best bet is to follow the source install instructions:  http://www.webgui.org/wiki/source-install

That tells you how to load the starting wG database into an existing mysql instance and configure wG to connect to it (plug username and password into the webgui .conf file for your site; there's one for each site), and how to configure Apache to point to wG, and so on.

Good luck!

--- (Edited on 7/2/2015 3:30 am [GMT-0500] by scottwalters) ---



Back to Top
Rate [
|
]
 
 
GeraldB

Will putting “unsubscribe” on the subject line get me unsubscribed?

 

-----Original Message-----
From: etcetera@webgui.org [mailto:etcetera@webgui.org] On Behalf Of soporte@syspol.es
Sent:
Thursday, July 02, 2015 4:04 AM
To: foxation@teksavvy.com
Subject: [Etc] Install WRE 0.9.4 on VPS

 

sysred wrote:

Hi,

I'm trying to install WRE on a CentOS 6.5 Final x64, which is running on a VPS.

The VPS already has an Apache server installed, and also a mySQL server installed, too.


I've tried , without success, to use the steps described at the first option in:

http://www.webgui.org/community-wiki/mysql-installation-options

I need to know how to point to my existing mySQL at wre.conf without creating a new daemon. I just want to create the tables.

Any help would be appreciated.

Regards

--- (Edited on 7/2/2015 3:04 am [GMT-0500] by sysred) ---



http://www.webgui.org/etcetera/install-wre-0.9.4-on-vps

--

WebGUI
http://www.webgui.org

--- (Edited on 7/2/2015 10:20 am [GMT-0500] by Visitor) ---



Back to Top
Rate [
|
]
 
 
scottwalters

Nope, that won't get you unsubscribed.

You're probably subscribed to posts in the "etc" forum.  Go here and click the "unsubscribe" button:

http://www.webgui.org/etcetera

If you don't see that there, email me at scott@slowass.net and I'll figure it out and take care of it.

Regards,

-s

--- (Edited on 7/2/2015 3:22 pm [GMT-0500] by scottwalters) ---



Back to Top
Rate [
|
]
 
 
martien

Hi sysred,

actually there is no reason to use different instances for mysql.

It all can be done by using mysql_multi. Configure this in your standard /etc/my.cnf and change the start-up scripts.

A config for my (SuSE) you'll find below.

The main thing is to disable the standard mysqld, add a mysql_multi part and a mysql1, mysql2 ... for the wished servers,

each with another port.

Use 127.0.0.1 instead of "localhost" to connect to your servers.

In my config, the client ist defaulted configured for mysqld1

Martien

#-------------------------------- /etc/my.cnf

[client]
port       = 3306
socket     = /var/run/mysql/mysql.sock
[safe_mysqld]
log-error       = /var/log/mysql/mysqld.log
socket          = /var/run/mysql/mysql.sock
[mysqldump]
socket          = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 300M
query_cache_size = 20M
thread_cache_size = 4
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log
user       = multi_admin
password   = XXXXX
[mysqld1]
port       = 3306
user       = mysql
thread_stack = 256K
datadir    = /data/databases/mysql_wg7
pid-file   = /var/run/mysql/mysql.pid
socket     = /var/run/mysql/mysql.sock
key_buffer = 16M
max_allowed_packet = 1024M
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
collation_server=utf8_bin
character-set-server = utf8
table_cache = 256
table_definition_cache = 16384
query_cache_size = 100000
query_cache_limit=16M
join_buffer_size = 256M
init_connect='set collation_connection=utf8_bin'
slow_query_log_file=/var/log/mysql/log-slow-queries.log
long-query-time=5
log-queries-not-using-indexes
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
[mysqld2]
port       = 3305
datadir    = /data/databases/mysql_wg5
pid-file   = /var/run/mysql/mysql05.pid
socket     = /var/run/mysql/mysql05.sock
max_allowed_packet = 16M
user       = mysql


#-------------------------------- /etc/init.d/mysql
...
case "$1" in
      start)

        # FIXME:
    # We assume a fresh install if the directory $datadir/mysql
    # does not exist and create the privilege database
        # if ! test -d $datadir/mysql; then
        #   echo -n "Creating MySQL privilege database... "
        #   mysql_install_db --user=$mysql_daemon_user --datadir=$datadir || {
        #     rc_failed;  rc_status -v; rc_exit
        #   }
        # fi
    echo -n "Starting service multi MySQL "
        mysqld_multi start

    # Remember status and be verbose
    rc_status -v
    ;;

      stop)
    echo -n "Shutting down service multi MySQL "
        mysqld_multi stop

    # Remember status and be verbose
    rc_status -v
    ;;

...

--- (Edited on 2015-07-11 21:09 [GMT+0200] by martien) ---



Back to Top
Rate [
|
]
 
 
sysred

Hi,

I've installed the WebGui's mySQL on another port. Now both daemons are running ok (multi_mysql was not the better choice for me, after all). Now I'm struggling with Apache (I'll post another thread for that).

Thank you very very much for your support, martien :)

Regards

Hi sysred,

actually there is no reason to use different instances for mysql.

It all can be done by using mysql_multi. Configure this in your standard /etc/my.cnf and change the start-up scripts.

A config for my (SuSE) you'll find below.

The main thing is to disable the standard mysqld, add a mysql_multi part and a mysql1, mysql2 ... for the wished servers,

each with another port.

Use 127.0.0.1 instead of "localhost" to connect to your servers.

In my config, the client ist defaulted configured for mysqld1

Martien

#-------------------------------- /etc/my.cnf

[client]
port       = 3306
socket     = /var/run/mysql/mysql.sock
[safe_mysqld]
log-error       = /var/log/mysql/mysqld.log
socket          = /var/run/mysql/mysql.sock
[mysqldump]
socket          = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 300M
query_cache_size = 20M
thread_cache_size = 4
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log
user       = multi_admin
password   = XXXXX
[mysqld1]
port       = 3306
user       = mysql
thread_stack = 256K
datadir    = /data/databases/mysql_wg7
pid-file   = /var/run/mysql/mysql.pid
socket     = /var/run/mysql/mysql.sock
key_buffer = 16M
max_allowed_packet = 1024M
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
collation_server=utf8_bin
character-set-server = utf8
table_cache = 256
table_definition_cache = 16384
query_cache_size = 100000
query_cache_limit=16M
join_buffer_size = 256M
init_connect='set collation_connection=utf8_bin'
slow_query_log_file=/var/log/mysql/log-slow-queries.log
long-query-time=5
log-queries-not-using-indexes
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
[mysqld2]
port       = 3305
datadir    = /data/databases/mysql_wg5
pid-file   = /var/run/mysql/mysql05.pid
socket     = /var/run/mysql/mysql05.sock
max_allowed_packet = 16M
user       = mysql


#-------------------------------- /etc/init.d/mysql
...
case "$1" in
      start)

        # FIXME:
    # We assume a fresh install if the directory $datadir/mysql
    # does not exist and create the privilege database
        # if ! test -d $datadir/mysql; then
        #   echo -n "Creating MySQL privilege database... "
        #   mysql_install_db --user=$mysql_daemon_user --datadir=$datadir || {
        #     rc_failed;  rc_status -v; rc_exit
        #   }
        # fi
    echo -n "Starting service multi MySQL "
        mysqld_multi start

    # Remember status and be verbose
    rc_status -v
    ;;

      stop)
    echo -n "Shutting down service multi MySQL "
        mysqld_multi stop

    # Remember status and be verbose
    rc_status -v
    ;;

...

--- (Edited on 2015-07-11 21:09 [GMT+0200] by martien) ---

--- (Edited on 7/13/2015 2:34 am [GMT-0500] by sysred) ---



Back to Top
Rate [
|
]
 
 
sysred

At last got my WebGUI running ok! :D

--- (Edited on 7/13/2015 12:12 pm [GMT-0500] by sysred) ---



Back to Top
Rate [
|
]
 
 
scottwalters

Nice work!  I'm happy to hear that you're undeterred.

--- (Edited on 7/13/2015 12:33 pm [GMT-0500] by scottwalters) ---



Back to Top
Rate [
|
]
 
 
    



© 2018 Plain Black Corporation | All Rights Reserved