Forum archive
Can't get Redmine v18.0 to run
Hello Jeremy! Long time no talk to. Hope you're doing well. Myself, I've been up to my neck in alligators for as long as I can remember now. :0 I just tried to install v18 of …
Forum archive tag
mysql
95 matching pages
Forum archive
Upgrading Nextcloud
Good Day - Hope the Christmas holidays are treating everyone well. Nextcloud has starting yelling at me that my version is EOL and its time to upgrade. I have been putting it off …
Forum archive
tklbam-backup database documentation incomplete
Hi, I've done a Turnkey/Core install and then put MySQL on it. The MySQL database isn't being backed up through tklbam-backup even though it's configured to run database backups. …
Forum archive
Corrupt MySQL database
On my Turnkey-Lamp-14.1 with Wordpress the MySQL database became corrupt. As a result MySQL service is failing to start - this of course is why we keep backups, so I proceeded to …
Forum archive
mysql connection to my local LAN
hey I'm sorry guys, but I've been flailing on this, and I just can't figure it out. All I want to do is spin up a wordpress VM (on my local LAN) and then connect to mySQL from a …
Forum archive
Observium crashes every night : DB Error 2002: Connection refused
Hello, It is owesome, I added a lot of devices but unfortunatly it crashes every night and show the error DB Error 2002: Connection refused when I go the observium web page. The …
Forum archive
Connection issues to Webmin and Adminer PR_CONNECT_RESET_ERROR
Evening. New to turnkey linux as a lxc container in ProxMox v6. I fired up the MySQL container and everything worked as expected, then all of a sudden I started getting …
Forum archive
Lost ability to access MySQL/MariaDB remotely using GUI tool
Now that v16 is on the horizon I finally got off my butt and migrated my v14 LAMP machine to v15. All went fine except for one minor issue, I can't connect to the database server …
Forum archive
Turnkey Wordpress MySQL Problems
Hey everybody, I use the Turnkey Wordpress appliance on a Server running Proxmox and everything has been running perfectly, but since yesterday, it stopped working and I am not …
Forum archive
Can not open a Port in the Turnkey LAMP Container
Hello I have a little Problem with my LAMP installation. I want to open the MYSQL port 3306 to work from outside the server. I started webmin and went to network -> firewall. …
Forum archive
MySQL Backup - emails
Hello, Having an issue with emails being sent after a MySQL backup has taken place on the WordPress containers. I've tried multiple different email addresses and different …
Forum archive
Could not connect to the database. Please refer to suitecrm.log for details.
Hello I instsalled SuiteCRM on Amazon server EC2 And It works well until today morning. But when i log in again, I could't login. It apear below message instead of log-in screen …
Forum archive
MySql Fails to Start in LAMP Turnkey
I have been running a Turnkey LAMP appliance on Virtualbox on Win 7 for several months for web development. However today for some reason the MySql instance failed to start. The …
Forum archive
WP turnkey linux appliance - SQL administrator login failed : Incorrect administration username or password
Hi guys, I was wondering if you could help as I am quite a beginner with those things! I have the latest WordPress and turnkey linux instal and my My SQL admin password stopped …
Forum archive
Finding MySQL Config Files
Hi I have installed Turnkey MySQL - Relational Database Management System, Where can I find the MySQL CNF File as I need to increase the Max Allowed Packet Size and modify the …
Forum archive
How to upgrade MySQL 5.5.52 on wheezy
Hi All, how can I simply upgrade to MySQL 5.5.52 on wheezy avoiding the Exploit (CVE-2016-6663)?? Thanks for your help! Replies (1) Should already have it! Reply 1 2016-09-20 …
Forum archive
SugarCRM Adminer connection
Hey guys, I've been trying to connect to the Turnkey SugarCRM from the Adminer module on my fusionPBX for the most part of the day with no success. I get the following error: …
Forum archive
Upgrading to MySQL 5.7 (for v14 LAMP based appliance)
Note: this was originally a support question but as often happens, I solved my own problem. I was able to successfully upgrade to MySQL 5.7 and for other's who may be interested, …
Forum archive
Access denied for user 'root'@'localhost' (using password: YES)
Trying: mysqladmin -u root -p flush-hosts I enter the correct root password and get the following: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: …
Forum archive
Can't remote login to MySQL DB
Just fired up the LAMP Stack - Web Stack (MySQL) provided by TurnKey Linux instance and can't connect to the MySQL database from my ofice using MySQLWorkbench. I want it open to …
Forum archive
MySQL server SSL Handshake exception
Hi, I have recently begun coding an application on Android Studio, I followed a number of tutorials for creating login and registration pages. I set up the TKL mysql server and …
Forum archive
MediaWiki loosing MySQL connection
I am having a bizzar (and new) issue with my wiki server. It runs fine for a period of time (less than 24 hours) and then begins loosing its connection to the MySQL system. The …
Forum archive
mysql crash ERROR 2013 (HY000)
hey guys, Everytime i want to restore my redmine database with my old servers data i get: ERROR 2013 (HY000) Lost connection to MySQL server during query this error comes only …
Forum archive
MYSql Not Starting Up
So I am trying to set up MySQL on a raspberry pi model B running the latest version of Rasbian Wheezy, a Debian variant. I am running it headless, and installing MySQL throung …
Forum archive
tklbam-backup stalling during MySQL portion
(I originally posted this on ServerFault but thought I'd post it here as well. Here's the original: …
Forum archive
How to secure RedMine??
How can I prevent my TurnKey instance being hacked? What measures should I take? I have received an email from AWS telling me that my instance has been used for DoS attacks, and …
Forum archive
TKLBAM and MySQL
I have a MySQL server which backs up daily via TKLBAM. I am using a lot of InnoDB tables, but had not set the "innodb_file_per_table" value to true until well after my ibdata1 …
Forum archive
Will changing the name of the MySQL root user in cause an issue in TKL?
If I change the name of the root mysql user in TKL will it break any functionality? Thanks Replies (2) Note, I'm running TKL 14, the Reply 1 2015-11-18 Note, I'm running TKL …
Forum archive
Basic configuration for multiple server LAMP stack
I am pretty new to the scenario of LAMP. I am trying to create a multiple server lamp stack i.e. 3 linux servers with one of A,M,P (Linux+ Apache, Linux + Mysql, Linux + php) I …
Forum archive
tklbam-backup mysql error
I recently restored a backup on a new machine. Everything went almost perfectly (some problems in Apache, because the new machine had a new non compatible version, but got over it …
Forum archive
Broke MySQL Connection :(
Greetings, I was attempting to resolve my "OTRS Scheduler" issue within my other post (here) and as I was browsing around Webmin, I went into MySQL and changed the IP Address from …
Forum archive
Connecting to remote mysql server
I have installed on my local machine MsSQLWorkbench. With a URL, usrsername and password I can connect to a remote mysql server. I have installed phpmyadmin on a Amazon Machine …
Forum archive
Micro MySQL displays "Installing security updates"
Hi - It looks like there is an error of some sort since the TKLH interface has been displaying the message "Installing security updates" since I started a MySQL Micro server on …
Forum archive
Issues connecting to mySql from python script
Hi, I am having issues connecting to mysql from a python script. LAMP setup successful. Logged on and created necessary databases and enabled access. I receive the following error …
Forum archive
TKL LAMP - I broke my phpMyAdmin connection
Hi all, I think I messed up. I am running LAMP and SPToolkit on an HP Prolient DL380 G5 and everything was working fine until I upgraded Debian from Wheezy to Jessie. In …
Forum archive
turnkey-lxc-13.0-wheezy-i386-ovf.zip and mysql?
I deployed turnkey-lxc-13.0-wheezy-i386-ovf.zip into VMware. The appliance boots up ok, but MySql seems to be missing. There are no references to it anywhere. Its not running as a …
Forum archive
Unable to connect to the Database: Could not connect to MySQL.
Hope someone can help me with this. Spent a lot of time reading different posts. I am running a Proxmox VE 3.3 and KVM's work fine. Now trying Containers based on turnkey …
Forum archive
MySql not started after restore
Hello I'm trying to migrate an inhouse instance of Turnkey SUGARCRM to Gigatux VPS hosting, by restoring my latest backup from the new image. However once restored it fails …
Forum archive
Site Down - TKLBAM restore not functioning?
Greetings: I've searched both the forum and documentation for a resolution to the following issue. I'm trying my best to rectify this on my own, but now I don't know what steps I …
Forum archive
FTP Server Installation - Chrooted users - Mysql accounts - Quotas - Web Interface
Hi all, The goal of this post is to describe all the steps leading to a successfull FTP Server Installation with the following features : - FTP Server compatible with Debian 7 or …
Forum archive
Replacement for Turnkey
I really hate to post this, and I'm not sure I'll get any constructive answers, but I'm getting to the end of my rope... After installing Turnkey, and migrating all my websites to …
Forum archive
DISREGARD FIXED - New mysql instance not accepting PEM and refusing sys log password
fixed. Forgot to use root and not ec2-user! Losing my mind here. I've done this in the past with zero problems. Need to get this DB setup asap. I am able to connect to the web …
Forum archive
Connect to MySQL from my desktop
I apologise in advance if I should be able to solve this myself but ... I have just installed RedMine into the Amazon Cloud - dbasics.tklapp.com. I can access it in my browser as …
Forum archive
Turnkey Moodle Upgrade Process - Frustrating
Howdy all, First post here. Brace yourself for a multi-week PIA story. I'll try to be brief where I can. Been using Turnkey on a few projects in the past and currently our …
Forum archive
Accessing the MySQL appliance from the internet
HI all. I am trying to access my mySql VM from the internet. I can get to it from my internal network and I know it have access to the internet as it downloaded all its pathces …
Forum archive
Zpanel Hosting appliance/VPS
Hi, Would be great to see Zpanel www.zpanelcp.com a sleek free/open source hosting solution with clean LAMP stack based on Apache 2/ MySQL/ Postfix/ Dovecot and supporting …
Forum archive
TKLDEV and starting mysqld
Hi folks. Enthusiastic about TKLDEV and reliving fond memories. Trying to port Ampache patch for TKLpatch to TKLDEV and do now what we should have done then, being a bit wiser and …
Forum archive
Upgrading from MySQL 5.1 to 5.5 or 5.7?
Would it be possible to update from MySQL 5.1 currently installed in TKL to MySQL 5.5 or 5.7 using repo? I've seen a lot of upgrade methods on the internet but I'm not going to …
Forum archive
Webmin stopped working after restart of server
I have a Web2Py app deployed through the TKL hub. I'm trying to migrate from sqlight to mysql. I have been using webmin with no problem. The system was not recognizing my mysql …
Forum archive
Install script for Apache and MySQL?
The Web2Py defaults are Rocket Server and SQL Light. I want to change them to use the TKL defaults Apachie and MySQL. Can someone point me to install scripts or docs for TKL with …
Forum archive
TKLBAM does not back up ALL MySQL databases!!!!!
I am livid right now. After having some issues with a virtual machine running 30+ WordPress installations on a TKL LAMP installation, I concluded my only option was to restore a …
Forum archive
Mysql triggers lost after restore
Hello, Seems like triggers are lost when restoring a backup. Just created a new server (mysql) and tried restoring from a backup. After a workaround …
Forum archive
Error '[Errno 2]
Hello guys Something just messed up my database. Trying to restore a mysql tkl machine to a couple of hours ago and I am getting alot of errors in the process. Never had this kind …
Forum archive
tklbam-restore cannot restore databases, mysql connection error
Dear All, I'm having a problem restoring a redmine-12.1-squeeze-amd64 appliance from the hub to a fresh local VM install - works fine with 11.3 x86 appliances, but no luck with …
Forum archive
Database connection Error
While trying to clone the server we are getting the ""Database connection Error"" where the live website is working fine. root@wordpress www/wordpress# mysql -u wordpress -p Enter …
Forum archive
LAMP & wordpress
Hi guys, I'm running a LAMP stack on Amazon in a micro instance. All files is installed and LAMP is running great. I'm trying to install Wordpress and I just can't get it to run. …
Forum archive
TKLCore Patch
I think that it is perfectly possible that one can install a minimal system with debootstrap, install tklpatch on it, and then apply a patch that builds TKLCore. Is there such a …
Forum archive
TKLPatch for B-Translator
I have installed a server with B-Translator at https://l10n.org.al, and it took me a long time to configure it properly with NGINX + MySQL + php5-fpm + apc + memcached + Drupal7, …
Forum archive
tklbam-backup crash and incomplete?
I'd like to start of by saying TKL is awesome!! the TKLBAM has worked flawlessly during all of my tests, but now I think I may have broken it. :o) I just tried a backup of a test …
Forum archive
Ugh. MySQL stopped, have no idea what to do
Hey guys, Hoping someone here has some ideas, as I've searched and tried several things and have come up short. Someone told me a website I run was down and went to check it out. …
Forum archive
Change default MySQL database location
Hello, I am using the Fileserver, TurnKey Linux 12.0 / Debian 6.0.5 Squeeze version. I have installed mysql-server on this appliance which runs happily. Due to space constraints …
Forum archive
SMS form Mysql through PHP website
Hi! I want to create a PHP site with added SMS functionality (dating services site). I was suggested a gateway to use as the engine (google: ozekisms.com/index.php?owpn=422). I …
Forum archive
How to upgrade php and mysql on turnkey
Hi all, I'm new with Linux, I have to upgrade Joomla installed on a Turnkey. When I upgraded Joomla, a backup component asked me to upgrade php to version 5.3 or later.. I'm using …
Forum archive
remote access of mysql web2py-apliance
As my first post I wanna thank you all for the excellent job. How to adjust the remote access of mysql web2py-apliance? in web2py, I create an application with the relevant …
Forum archive
Cannot connect to phpMyAdmin in Turnkey MySQL appliance
I have created a Tunkey MySQL instance on Amazon ec2 from the AWS marketplace. MySQL is running ok, I can connect to Webin on port 12321 and the shell on port 12320 but I cannot …
Forum archive
redmine mysql password
I'm trying to set up SVN and redmine integration under TKL 11.3 redmine, as described in http://www.redmine.org/projects/redmine/wiki/Repositories_access_control... Where I get …
Forum archive
Postfix virtual mail permission denied
I have just setup postfix and I can get it to send email to my gmail account via telnet, however when I try to send mail to a local account it fails to create the local mailbox. I …
Forum archive
TKL Linux Mysql - Mysqltuner.pl
Hello guy, I love turnkey, been using it on AWS and locally for Websites, CRM, Intranet. Under AWS, Under XenServer, and baremetal. I've run into a problem with TurnKey Mysql. I …
Forum archive
INNODB broken in MySQL Magento (any thoughts?)
Magento just lost the ability to open the primary database. I am getting this error when I try to access the database from both Webmin and Navicat. I expect PHPMYADMIN is the …
Forum archive
Mysql 5.5
Will Mysql 5.5 be supported in the upcoming Turnkey 12.0? How can I update turnkey 11.3 mysql 5.1 to mysql 5.5. Before I use Mysql 5.5 for my apps and development and when I …
Forum archive
Percona, MariaDB and TokuDB appliance
I was wondering if TKL team can or would consider providing a MySQL-based appliance based on Percona Server with XtraDB (http://www.percona.com/software/percona-server/) XtraDB is …
Forum archive
Mysql database not restoring to cloud
When i restore a back up from my cloud for some reason it does not back up half of my mysql database. below is a print screen only like 6 tables where backed, the back up before …
Forum archive
[solved]Problems stopping MySQL within TKLPatching process
Hi all, I'm updating my SimpleInvoices patch ATM and have stuck a strange problem. In the conf script, when finishing up the patching process I stop the MySQL service (as per you …
Forum archive
Clarification needed for TKLBAM-RESTORE --limits usage needed
I need an example of how to "include" and how to "exclude" a Database from a TKLBAM-RESTORE cycle. (what is the exclude command?) I can't get " --limit=-(mysql:database) " to take …
Forum archive
Help! Port fowarding!
I've created a TurnKey Hub server with the LAMP stack image (and it's been working perfectly). However, I would like to open port 3306 on the server (the MySQL port) so that I can …
Forum archive
LAMP - MYSQL - Dreamweaver - mysql database 'manager' blocked'
I am running a LAMP server.. It runs fine, including PHP connecting to my database. i wrote some 'custom' code and the php code can connect to the database fine and display the …
Forum archive
Security and Configuration
I want to throw out the line as to what folks are doing with Security and Optimization on MySQL and TKL sites in general. I have had a few sites get really hammered by spiders and …
Forum archive
MYSQL Setting update from WEBMIN not taking (Magento 11.2)
Just tried 3 times to set/reset: query_cache_size: from 16777216 to 268435456 query_cache_limit: from 1048576 to 16777216 Whenever I restart MYSQL the Original settings return. I …
Forum archive
root mysql password on startup
i have problems with mysql password on the turnkey linux images. AMI: turnkey-wordpress-11.2-lucid-x86.ebs (ami-97b077fe) here is the prompt. mysql -u root -p Enter password: …
Forum archive
MySQL Backup and Restore Fail
Hi I'm still restoring my server and have got to the MySQL databases for MediaWiki and Moodle. On the old appliance, I set up a scheduled backup for MySQL from the MySQL server …
Forum archive
TKLBAM and volatile, TKLBAM and mysql db
Hi Liraz and All, Thanks for the excellent software! I am reading through your volatile script trying to set up my drupal work environment. In that script you use rsync to …
Forum archive
Having connectivity issues with MySQL
Hi all, I am having issues with MySQL connections. It seems that after a period of time I cannot connect to my SQL server running on Proxmox behind a router directly connected to …
Forum archive
How to create MySQL DB in TKLPatch
I'm just finalising my SimpleInvoices TKLPatch. It works, just need to test the bundled patch on a clean ISO. That is where my problem has occurred. Based on Core with a patch …
Forum archive
Networking issues with MySQL Appliance
Hi all, Having some strange issues with networking and cannot get any info from logs. I might turn up the log level to see what happens but basically mysql appliance runs fine 90% …
Forum archive
MySql is not operational after LAMP Stack tklbam-restore
I've successfully installed a LAMP appliance on VMWare, but when backing up and restoring, the Mysql is not operational on either EC2 restores or a restore to a blank Turnkey LAMP …
Forum archive
Appliance Tomcat Stand Alone: How to change to MySQL Engine type INNODB by default
I faced something like these after modifying my.cnf: 110330 18:00:44 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks …
Forum archive
How to SSH into MySQL from Apache Tomcat appliance
Hello, I need to edit something on my.cnf file which is in the MySQL root directory. How do I do that? I've installed Tomcat Apache. Rgds. John Replies (2) I'd guess in /etc …
Forum archive
TKLBAM Restore and MySql views
Lamp Stack - MySQL - TKLBAM Hi there, I'd like to start with an apology. I'm sorry for being late to the party! I've only just discovered TurnKey, and I am so excited and …
Forum archive
Security? - Python and an SQL update using exec.? Is it safe?
For the Psiphon patch (/forum/general/20110215/psiphon-25-tklpatch) I've been working on, I planned to finish it off by something that I thought was far outside my reach: In the …
Forum archive
Psiphon 2.5 TKLPatch
Original Post I've been working for a few weeks on a TKLPatch for Psiphon. From their website: Psiphon is content delivery technology that makes it possible for: Individuals to …
Forum archive
Upgrading Redmine
I am running release 2009.10-2 of the redmaine appliance on VmWare ESX, I would like to upgrade to the latest Turnkey 11 release but I'm not certain of the best method. What is …
Forum archive
URL in Turnkey MySql
Hello all, I've installed turnkey mysql and i was able to configure everything right. I uploaded the website through sftp connection and restored the database. However i can't …
Forum archive
MySQL fail to shutdown when patching turnkey-tomcat
Guys, I'm patching the turnkey-tomca t-11.0 appliance to create an icescrum patch. In the patch, I: 1. Start mysql 2. Create the database as usual. 3. Stop mysql. When stopping …
Forum archive
TKLBAM gives an error | Bigger than max_allowed_packet
When restoring a server using TKLBAM the following error is displayed when TKLBAM startes to restore a database: mysql got a packet bigger than max_allowed_packet Any guidance …
Forum archive
Why is InnoDB disabled? (SOLVED)
after installing Drupal 6 appliance i do have problem to enable InnoDB in MySQL. can some one help me please? Thx Replies (28) demanded answers Reply 1 2009-01-12 no problem to …