2008-10 mercury upgrade
* [x] plan disk layout * [x] write venus:/BonMotBackup/backup.sh to back up bonmot.ca to casein.bonmot.ca . . . [x] get pkg-get * [x] install gcc * [x] pkg-get mysql5 (also installs Perl DBI and DBD::mysql modules, . . .
2K - last updated 2008-10-25 08:23 UTC by Dan
2010-04 venus packages
* aalib * alternatives * [x] apache2 DAN * arts * aspell * aspellen * audiofile * autoconf * bash * bbkeys . . . DAN * mutt_base * mutt_ncurses * mutt_slang * mysql4rt * [x] mysql5 DAN * mysql5client * mysql5rt . . . php5 * pixman * pkg_get * pm_berkeleydb * pm_dbdmysql * pm_dbi * pm_iomultiplex * pm_netdaemon * pm_netserver . . .
3K - last updated 2010-08-20 13:55 UTC by DanielMacKay
2011-06-03 Drupal Upgrade
Backing up: * back up /local/drupal to /local/drupal.2011-06-03.tar.gz * run mysqldump -uroot -p --databases . . . drupal hpw mainegaynet \ > /local/mysql/backups/2011-06-03.gz 6.19 --> 6.22 * download . . . in * err message: "You need to enable the PDO_MYSQL database driver for PHP 5.2.4 or higher so that . . . the database." On venus: pkgutil -i php5_pdomysql Now, at least drupal works but is complaining . . .
2K - last updated 2011-06-03 15:16 UTC by Dan
2013-06 Move
Principles * we'll preserve services running on Bonmot and move without a major outage * we'll help Moose . . . * [x] Decide if we're going to run our own mysql or share one with Moose: answer: run our own . . . serving home directories * [x] Configure mysql and test binary database move -- DOESN'T SEEM . . . and a few more domains * [x] Install mysql * [x] Install drupal7 * [x] Test & document procedure . . . lock the site so no changes can be made # mysqldump the database to e.g. wayves.ca.sql # scp . . .
3K - last updated 2013-10-24 21:11 UTC by Dan
2016-06 mercury admin
Upgrade notes for mercury.bonmot.ca Date: 22 June 2016 Notes 20:29h Initial update went OK. Looking for . . . Wed, 20 Nov 2013 19:17:41 -0600 mysql-5.5 (5.5.33+dfsg-0+wheezy1) wheezy-security; . . . urgency=high mysql-server-5.5 ships with the upstream mysql_install_db . . . that users might have created after installing mysql-server. During the migration of mysql-5.1 to . . . mysql-5.5 in Debian the patches to drop these permissions . . .
12K - last updated 2016-06-23 10:47 UTC by Dan
2017-01 mercury admin
===Drupal8 Install=== * Create /etc/drupal/8/ ; fix permissions * Download drupal-8.2.5.tar.gz * unpack . . . apt-get update ; apt-get upgrade Failed because mysql would not shut down Shut down by hand & retry . . .
2K - last updated 2017-01-05 20:05 UTC by Dan
2017 mercury move
Copied from [[2013-06 Move]] * New machine: mercnew.bonmot.ca 199.255.223.73 Debian 9.11 * Old mercold . . . --> /mercury_old/ * [x] bind9 * [x] Dan: install mysql * [x] DOUG Change root password * [x] Get apache2 . . . format has changed so had to update: using mysql: ** SET PASSWORD for 'cyclemaint_web'@'localhost' . . . lock the site so no changes can be made # mysqldump the database to e.g. wayves.ca.sql # scp . . . the tarfile into /usr/share/drupal7/sites/ # mysql < /tmp/wayves.ca.sql # change the dns and wait . . .
4K - last updated 2020-02-04 23:30 UTC by Dan
2020 mercury move
==Move Options== ; Pay Up : just give Giles $50/mo. Adv: no work required, Canadian, local ; canadianwebhosting . . . Log::Log4perl CGI : [x] apt-get install libdbd-mysql-perl default-libmysqlclient-dev : [x] cpan install . . . DBD::mysql : [x] RRD. should be "cpan install RRD::Simple . . . the database user # gzip -c -d (the sql file) | mysql -uroot -p (database) # unlock # double check . . .
4K - last updated 2021-11-04 14:37 UTC by Dan
2021-03-19
PHP upgrade due to security concerns <pre> root@mercury:/local/home/daniel/www/Recipes# apt list --upgradable . . . 2:7.4+73+0~20200221.21+debian9~1.gbp29416a] php-mysql/unknown 2:8.0+82+0~20210313.35+debian9~1.gbpa8195f . . . php7.4-mysql/unknown 7.4.16-1+0~20210305.42+debian9~1.gbpbbe65e . . . ... which did a huge batch php-common php-gd php-mysql Then re-apply local mods to /etc/php/7.4/apache2/php.ini . . .
11K - last updated 2021-03-19 11:49 UTC by Dan
2023-01 update
Done on 2023-01-19 Original plan: upgrade mercury from Debian 9 "stretch" to 10, "buster." #nslug denizen . . . 10 needs 8.2. had to reinstall 7.4 and php7.4-mysql and php7.4-xml . . .
3K - last updated 2023-04-24 12:33 UTC by Dan
AsteriskOnSolaris
Asterisk on Solaris This is an interesting trip. There is currently no Asterisk Supported cards that . . . . . .
9K - last updated 2006-06-10 11:01 UTC by 7130
BonMotMove
== Notes / Discussion == * should we have a restricted /etc/hosts.allow on the global container? What . . . stats package * Bring up snips (or nagios) * Get mysql starting up automatically ** right now there . . . xml in /var/svc/manifest/application/database/mysql.xml that doesn't really work ** right now there . . . is a legacy startup in /etc/init.d --> rc*/*mysql ** OR get the original mysql service startup . . . install apache * syslog management up * install mysql5 * install "gd" graphics library * install & . . .
3K - last updated 2010-10-09 18:33 UTC by DanielMacKay
Drupal
=Common Drupal Procedures= * Drupal 10 is in /etc/drupal/10 ===Set Yer Var=== drupal=10 ===Update drupal=== . . . create the database for it: site_db=fruitcake10 mysqladmin -uroot -proot create $site_db mysql -uroot . . .
5K - last updated 2024-09-07 11:23 UTC by Dan
MercuryRebuild
== Packages == |Package name|Dan Comments|Doug Comments| |apache2 | | | |curl| | | |gd|graphics library . . . for mapping| | |jre??| | | |mysql5|for sure| | |Netpbm|Not sure if my mapping software . . . | | |mutt| | | |muttbug| | | |mv| | | |mySQL| | | |mysql_config| | | |nadheader| | | |nasl| . . .
16K - last updated 2023-06-21 13:26 UTC by Dan
MySQL
Data is in /var/lib/mysql Config files: * THIS IS THE REAL ONE: /etc/mysql/conf.d/mysql.cnf * /etc/mysql/my.cnf . . . <-- all this does is include everything in /etc/mysql/conf.d/ * /etc/systemd/system/mariadb.service.d/local.conf . . . chmod u+x that then run it * is in daniel/major-MySQLTuner-perl-5aa880a/ Status: systemctl status mariadb . . . * set the root password. * apt install libdbd-mysql-perl ==2010-03== cswmysql5 startup file, /etc/opt/csw/init.d/cswmysql5: . . . change MYSQL_VAR=/var/opt/csw/mysql5 to MYSQL_VAR=/local/mysql . . .
2K - last updated 2023-02-17 09:14 UTC by Dan
PerlModules
The shell perl -MCPAN -e shell Common commands install Module::Name uninstall Module::Name upgrade To . . . Perl modules we need: * GD * DBI * DBD::mysql * PDF::Create (makes PDF files) * PDF::Labels . . .
1K - last updated 2023-06-21 12:32 UTC by Dan
PerlSql
* configging mysql database: http://dbforums.com/showthread.php?threadid=174934 * mysql documentation . . . http://dev.mysql.com/doc/mysql/en/index.html * installing under . . . Solaris: http://www.idevelopment.info/data/MySQL/DBA_tips/Installing/SOLARIS323_2.shtml * O'Reilly . . . * Perl <--> mySQL tutorials ** Common functions: http://www.perlscriptsjavascripts.com/tutorials/mysql/ . . . of articles: http://www.devshed.com/c/a/MySQL/ ** perl.about.com *** How to connect to a MySQL . . .
2K - last updated 2021-08-10 14:34 UTC by Dan
mysql manifest
<pre> <?xml version='1.0'?> <!DOCTYPE service_bundle SYSTEM '/usr/share/lib/xml/dtd/service_bundle.dtd.1'> . . . name='export'> <service name='network/cswmysql5' type='service' version='0'> <single_instance/> . . . </dependency> <dependent name='cswmysql5_multi-user' restart_on='none' grouping='optional_all'> . . . name='start' type='method' exec='/opt/csw/bin/mysqld_safe' timeout_seconds='18446744073709551615'> . . . name='stop' type='method' exec='/opt/csw/bin/mysqladmin shutdown' timeout_seconds='18446744073709551615'> . . .
2K - last updated 2012-06-19 12:14 UTC by Dan
18 pages found.