Diskussion:Server/srs15
Zur Navigation springen
Zur Suche springen
Aktualisieren von MySQL 5.5 zu 5.6
salve gemeinde,
ave wolle,
wie ich ja bereits schon schrieb, so läuft bei Server/srs15 mysql56-server (freshports:databases/mysql56-server). auch sah ich ja jetzt, dass bei der "fix verwendeten" mysql55-server (freshports:databases/mysql55-server) wird. :-/
nachfolgendes sind meine (nicht getesteten) gedanken dazu.
- variante 1
- wir bringen die datenbank in die nächste version 5.6.
- alt dump
- alt stoppen
- alt dump zusätzlich
- alt upgrade
- alt vielleicht testweise nochmal starten
- überführen vom dump alt zu neu
- neu stoppen
- neu dump einpflegen
- neu starten
- hoffen
- neu prüfen
- weinen oder jubeln
- erneut machte ich mir gedanken dazu, das ich auf der "alten" instanz war und dort, dass das upgrade ohnehin auch für die software (pakete mit
pkg) vorgesehen wird. - vielleicht auch nochmal dokumentation lesen
- variante 2
- ich setze das nochmal für die datenbank als version 5.5 auf.
- müsste ich dann einfach machen. (eigentlich hätten uns auch vorher auffallen können. aber so würde es auch auf dem alten stand bleiben, was hierbei wahrscheinlich nicht besonders schlimm wäre.)
- lust auf diese variante habe ich weniger. :-/
--Paul 21:35, 5. Aug. 2015 (CEST)
Dokumentation mal zwischendurch
Als Ansatz der Komponenten:
- Redmine
- PostgreSQL
- Apache
- Start
pkg upgrade -y
export LANG=de_DE.UTF-8
export LC_ALL=de_DE.UTF-8
- Redmine
pkg install -y redmine
Message from ruby-2.1.7,1: ==== Some of the standard commands are provided as separate ports for ease of upgrading: devel/ruby-gems: gem - RubyGems package manager devel/rubygem-rake: rake - Ruby Make And some of the standard libraries are provided as separate ports since they require extra dependencies: databases/ruby-gdbm: GDBM module Install them as occasion demands. ==== Message from gcc-4.8.5_2: To ensure binaries built with this toolchain find appropriate versions of the necessary run-time libraries, you may want to link using -Wl,-rpath=/usr/local/lib/gcc48 For ports leveraging USE_GCC, USES=compiler, or USES=fortran this happens transparently. Message from trousers-tddl-0.3.10_7: To run tcsd automatically, add the following line to /etc/rc.conf tcsd_enable="YES" You might want to edit /usr/local/etc/tcsd.conf to reflect your setup. To use TPM, add your_account to '_tss' group like following: # pw groupadd _tss -m your_account Message from dejavu-2.35: Make sure that the freetype module is loaded. If it is not, add the following line to the "Modules" section of your X Windows configuration file: Load "freetype" Add the following line to the "Files" section of X Windows configuration file: FontPath "/usr/local/share/fonts/dejavu/" Note: your X Windows configuration file is typically /etc/X11/XF86Config if you are using XFree86, and /etc/X11/xorg.conf if you are using X.Org. Message from node-4.2.1: Note: If you need npm (Node Package Manager), please install www/npm. Message from ghostscript9-base-9.06_11: Note: in order to use the script "dvipdf", dvips must be installed. This program is provided by another package print/tex-dvipsk. FAPIfontmap and FAPIcidfmap in /usr/local/share/ghostscript/9.06/Resource/Init have to be configured if you want to use FAPI feature. Message from liblqr-1-0.4.1_8: ========================================================================== NOTE: In order to compile examples for liblqr, you will also need pngwriter port (/usr/ports/graphics/pngwriter). Examples are located in /usr/local/share/examples/liblqr-1 ========================================================================== Message from mysql56-client-5.6.27: * * * * * * * * * * * * * * * * * * * * * * * * Please be aware the database client is vulnerable to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM". You may find more information at the following URL: http://www.vuxml.org/freebsd/36bd352d-299b-11e5-86ff-14dae9d210b8.html Although this database client is not listed as "affected", it is vulnerable and will not be receiving a patch. Please take note of this when deploying this software. * * * * * * * * * * * * * * * * * * * * * * * * Message from redmine-2.6.9_1: ============================================================================= Redmine was installed. You now need to setup your Redmine installation so please have a look at the Installation Guide. http://www.redmine.org/wiki/redmine/RedmineInstall If you are upgrading please read the Upgrading Guide before starting the new version. http://www.redmine.org/wiki/redmine/RedmineUpgrade =============================================================================
- Datenbank
pkg install -y postgresql94-server
Message from postgresql94-client-9.4.5:
The PostgreSQL port has a collection of "side orders":
postgresql-docs
For all of the html documentation
p5-Pg
A perl5 API for client access to PostgreSQL databases.
postgresql-tcltk
If you want tcl/tk client support.
postgresql-jdbc
For Java JDBC support.
postgresql-odbc
For client access from unix applications using ODBC as access
method. Not needed to access unix PostgreSQL servers from Win32
using ODBC. See below.
ruby-postgres, py-PyGreSQL
For client access to PostgreSQL databases using the ruby & python
languages.
postgresql-plperl, postgresql-pltcl & postgresql-plruby
For using perl5, tcl & ruby as procedural languages.
postgresql-contrib
Lots of contributed utilities, postgresql functions and
datatypes. There you find pg_standby, pgcrypto and many other cool
things.
etc...
Message from postgresql94-server-9.4.5:
For procedural languages and postgresql functions, please note that
you might have to update them when updating the server.
If you have many tables and many clients running, consider raising
kern.maxfiles using sysctl(8), or reconfigure your kernel
appropriately.
The port is set up to use autovacuum for new databases, but you might
also want to vacuum and perhaps backup your database regularly. There
is a periodic script, /usr/local/etc/periodic/daily/502.pgsql, that
you may find useful. You can use it to backup and perfom vacuum on all
databases nightly. Per default, it perfoms `vacuum analyze'. See the
script for instructions. For autovacuum settings, please review
~pgsql/data/postgresql.conf.
If you plan to access your PostgreSQL server using ODBC, please
consider running the SQL script /usr/local/share/postgresql/odbc.sql
to get the functions required for ODBC compliance.
Please note that if you use the rc script,
/usr/local/etc/rc.d/postgresql, to initialize the database, unicode
(UTF-8) will be used to store character data by default. Set
postgresql_initdb_flags or use login.conf settings described below to
alter this behaviour. See the start rc script for more info.
To set limits, environment stuff like locale and collation and other
things, you can set up a class in /etc/login.conf before initializing
the database. Add something similar to this to /etc/login.conf:
---
postgres:\
:lang=en_US.UTF-8:\
:setenv=LC_COLLATE=C:\
:tc=default:
---
and run `cap_mkdb /etc/login.conf'.
Then add 'postgresql_class="postgres"' to /etc/rc.conf.
======================================================================
To initialize the database, run
/usr/local/etc/rc.d/postgresql initdb
You can then start PostgreSQL by running:
/usr/local/etc/rc.d/postgresql start
For postmaster settings, see ~pgsql/data/postgresql.conf
NB. FreeBSD's PostgreSQL port logs to syslog by default
See ~pgsql/data/postgresql.conf for more info
======================================================================
To run PostgreSQL at startup, add
'postgresql_enable="YES"' to /etc/rc.conf
cat /etc/passwd | grep PostgreSQL
- Webserver
pkg install -y rubygem-passenger
Message from apache24-2.4.17: To run apache www server from startup, add apache24_enable="yes" in your /etc/rc.conf. Extra options can be found in startup script. Your hostname must be resolvable using at least 1 mechanism in /etc/nsswitch.conf typically DNS or /etc/hosts or apache might have issues starting depending on the modules you are using. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! - apache24 default build changed from static MPM to modular MPM - more modules are now enabled per default in the port - icons and error pages moved from WWWDIR to DATADIR If build with modular MPM and no MPM is activated in httpd.conf, then mpm_prefork will be activated as default MPM in etc/apache24/modules.d to keep compatibility with existing php/perl/python modules! Please compare the existing httpd.conf with httpd.conf.sample and merge missing modules/instructions into httpd.conf! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Message from rubygem-passenger-5.0.22: ##################################################################### Please edit your Apache configuration file, and add these lines: LoadModule passenger_module /usr/local/lib/ruby/gems/2.1/gems/passenger-5.0.22/buildout/apache2/mod_passenger.so PassengerRoot /usr/local/lib/ruby/gems/2.1/gems/passenger-5.0.22 PassengerRuby /usr/local/bin/ruby21 After you restart Apache, you are ready to deploy any number of Ruby on Rails applications on Apache, without any further Ruby on Rails-specific configuration! #####################################################################
pkg install -y apache24
pkg install -y ap24-mod_fastcgi
- Weblinks