Tag Info

New answers tagged

2

There should be no need to reinvent this wheel, it's been done plenty of times before. Depending on your OS/Distro then there should be a process supervisor you can leverage already available. Currently systemd and upstart are fairly common.


0

Yes, its possible. It won't cause conflicts at all.


-1

I found the answer. The problem are the spaces in the directory name, it messes up with mysqldump. In order to have a directory with spaces in the name simply wrap the path in double quotes like this: C:\wamp\bin\mysql\mysql5.6.17\bin\mysqldump -umyuser -pmypassword mydbname > "C:\Web Design\backup.sql" Now it works, hope this helps someone with the ...


1

If you're not going to use the interface why not disable it (or not start it) ? You don't say which distro you are using but they should all have a way of not starting an interface when the system boots. For RHEL/CentOS etc you can set ONBOOT=no in the relevant file in /etc/sysconfig/network-scripts For Debian/Ubuntu etc you can set iface InterfaceName ...


1

Default path to MySQL database files in Ubuntu is /var/lib/mysql/. If it's been modified (or installed other than from official Ubuntu package), check for datadir in /etc/mysql/my.cnf or service startup script. When you reinstall your OS with MySQL, simply replace new data directory with the old one (with mysql service stopped, of course). Remember about ...


1

I had the same problem with 32 bit version of MySQL on a windows server 2008 VM 64 bit with 4G Ram. I tried increasing system ram to 6G and still could not allocate over 1G for innoDB. Since I was already on 64 bit OS, I tried the 64 bit installer for MySQL and had no issues at all allocating 2G on my 4G system.


0

There are a few windows tools that can help a lot here. One is a download, the only link I could find in short order is from CNET so I think you can trust it, it is a Microsoft program called PROCMAN (or Process Manager) ProcMan The other tool is the Resource Monitor built into Task Manager in Server 2012, it is much improved over Server 2008 and provides a ...


0

Your problem is most likely related to MySQL. Less so HeidiSQL and least FreeBSD. You give precious little details but we can say the following: Misconceptions: The FreeBSD system "root" and the MySQL "root" users are not related! You do not need to log into the FreeBSD system as "root" to work within the MySQL database as MySQL "root" You do not need to ...


0

I do not think there is a migration tool for the MUC content to migrate data from Mnesia to relational database. If you still need that feature, I suggest you post a feature request on ejabberd issue tracker on Github: https://github.com/processone/ejabberd/issues


0

The post you are referring to are obsolete. To use ejabberd with native Erlang MySQL driver, this is now very easy and quite straightforward. Only two steps are required: Make sure you have an ejabberd with MySQL support enabled. Two way to have that: Download a binary installer or RPM / DEB package. The needed MySQL component is included. Installer and ...


0

We were able to fix our connection problems by forcing the use of a non-Diffie-Hellman SSL cipher. With our mysql 5.5.42 Linux client we had success with specifying the --ssl-cipher=AES256-SHA command line option, as specified in this bug report. Our (Java7) MySQL 5.1.35 jdbc client, however, did not like that cipher, but worked when we specified ...


0

My guess is that HeidiSQL is attempting to connect to port 3306 on the public IP address of the server. Most distros these days have MySQL configured to only listen locally. You could verify this by running a the following command on the remote server: netstat -tapn | egrep "^tcp.*:3306\s+0.0.0.0.*LISTEN.*$" If you get something back like: tcp ...


1

I had missread the troubleshooting article https://cloud.google.com/compute/docs/troubleshooting#communicatewithinternet fixing all the parameters fixed it


0

Your problem is the storage backend. From you graph, it is clear that your SAN it is not capable of high random IOPS values (see both aver. iops and aver. queue depth). To ameliorate the situation, try with the following: increase the innodb buffer pool size, by editing the my.cnf file and adding (or changing) the line innodb_buffer_pool_size = ...


0

Do I have all my bases covered? When speaking of a public facing server, one should never think to be ultimately safe; other than that, I would set a DROP policy for the INPUT chain, and after that allow only what is really required. For example, after a iptables -P INPUT DROP it wouldn't be necessary to specify the iptables -A INPUT -i eth0 -p tcp ...


0

When you have disable innodb, dont' forget to remove all innodb-related tables from Dbs. For example "mysql" database has 5 of them: root@ustimen.co$ mysql mysql -e 'show table status' | grep Unknown | awk '{print $1}' innodb_index_stats innodb_table_stats slave_master_info slave_relay_log_info slave_worker_info


1

Should have looked better into the documentation. According to the exim documentation, exim does not support ssha512(yet?). I took the easy way out and just told exim to use dovecot for authentication purposes, like the dovecot documentation tells you to. I'm sorry to have wasted your time and I hope, someone will benefit from my experience.


1

MySQL manual for Connector/J indicates it's possible. Note that you need to configure your MySQL servers to replicate with each other (master-master replication). You should use at least MySQL version 5.6, as it has greatly improved replication reliability. It is however still possible that your application will try to read a data row only written recently ...


1

As most answer suggests it's not possible to UN-DELETE but there is a hope which assumes you have binary logging enabled and retained for longer period. Longer enough to include all the DMLs for the database. If your database was created recently, changes were made recently you can always use mysqlbinlog utility to get DML SQLs from binary log and recover ...


-1

I suggested you , Check your tables: Do it has triggers? Clear all triggers SET: AUTOCOMMIT=0, UNIQUE_CHECKS=0, FOREIGN_KEY_CHECKS=0 (AND DON'T FORGET TO ROLLBACK THIS CHANGES) USE COMMAND LINE LIKE mysql -u root -pPasss requests < mydb.sql Check your database file size Good Luck


2

I found the problem, so here it is in case it would help anyone: There's a configuration file for saslauthd, mine is located in /etc/sysconfig/saslauthd: # Directory in which to place saslauthd's listening socket, pid file, and so # on. This directory must already exist. SOCKETDIR=/var/run/saslauthd # Mechanism to use when checking passwords. Run ...


1

Your query contains the wrong/incomplete parameter for the query. This query will append the domain to the local part of the login: SELECT password FROM mailbox WHERE username = '%u@%r' Correct the query in your SASL configuration for postfix, e.g. /etc/postfix/sasl/smtpd.conf


0

This MySQL forum post looks like a success story, although a bit old. I remember a similar story of mine, on Linux. Windows platform doesn't matter here, MySQL data files structure is similar. No command line work is really needed. I assume your Ibdata file is not damaged in any way. AFAIK you don't need ib_logfile? files at all, the forum post confirms ...


1

You can try adding the LOW_PRIORITY keyword to your DELETE query and see how that does. For example DELETE LOW_PRIORITY FROM tablenamegoeshere ... Check out https://dev.mysql.com/doc/refman/5.5/en/delete.html for more details.


0

If someone is actually performing an SQL injection attack through your website, they would probably go after your data and not runtime variables. If you have any suspicion that the query is being run from your webserver, you can check the server access logs for signs of an attack. Even in your MySQL logs, you can look for Select and UNION queries against ...


0

Why should this be an SQL injection? All it does is to ask for the state of some runtime variables of the MySQL server and looks a lot like something that MySQL Workbench itself would do to do its work.


-1

For migration purposes I would not use replication. I have done this before via: use rsync to copy /var/lib/mysql/ from the current system to the new one; the current system can continue operation as usual. Do this a day or so before the planned migration. just before the planned migration, do the rsync again now bring the system down (stop the database ...


0

you can get away with the snapshot dump approach: enable log-bin and make a mysqldump --master-data=1 --all-databases at the master - this will save the bin-log positions into the dump. depending on your DB types (only innodb can use the --single-transaction), this will read-lock the DB at max for the duration of the dump. no further action on the master ...


0

Solved myself, edited to: $config['password_query'] = ' UPDATE virtual_users SET password = ENCRYPT(%p, CONCAT(\'$6$\', SUBSTRING(SHA(RAND()), -16))) WHERE email = %u' Thanks for reading.


-3

The answer to the first question really depends on how CPU intensive the software is going to be, but should be able to cope with 100 clients per hour RAID is slowly going obsolete, however unless you are deploying larger scale NAS/SAN with this it will work fine. As for which type of RAID, with 2 disks you are pretty much only able to do 0 and 1, so do 1. ...


0

You can not update this setting at runtime, you need to add it to your my.cnf and restart your server. But also as @erny said, there are some issues that can come up if you are setting the value higher than the OS settings.


3

You don't want to try to connect the tunneled connection to port 3306 of the EC2 instance's public IP address, and that appears to be what you are doing. In EC2, machines have private IP addresses bound to their IP stack, and the AWS network hardware does 1:1 NAT to attach the public IP. It won't NAT you to yourself, hence the timeout. Use -L ...


2

"service mysql start" won't accept mysql-specific options, since that's a command of the init system. You would need to pass the --log-bin to mysqld. But you should prefer specifying that in the config file ;-) add in the [mysqld] stanza of my.cnf log-bin = /path/to/log and maybe: expire-logs-days = 14 max-binlog-size = 500M server-id = 1 and ...


1

No, Varnish is designed for http traffic and is not suitable for load-balancing mysql/mariadb


2

Varnish is a HTTP Cache, so no it cannot act as a frontend for MariaDB/MySQL, unless you were trying to access them via HTTP. I would recommend HAproxy as a frontend / load balancer solution for MariaDB/MySQL pool.


0

Check your EC2 security group if it has port 3306 open for at least your IP. If it doesn't add it and try again. Click on the instance and on Description you will see "Security groups" click on the Security Group name and then Inbound > Edit and there you should have the option to open the ports.


0

This happens because the IP you are connecting from isn't authorized in the console, as stated in the docs: If Google Cloud SQL rejects the connection, for example, because the IP address your client is connecting from is not authorized, the error you receive will be: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial ...


1

Same problem for me, but the source of my problems was the old password format. While mysql can be forced to connect using the old format with "skip-secure-auth", mysql_upgrade has not this option. You need first to update the root password with the new format and then you can upgrade your mysql.


1

If it is the client requiring to disable the secure auth, you should disable it on the client, not on the server. In your example, put it in the [mysql] section, not [mysqld] [mysql] skip-secure-auth


2

GRANT ... TO 'rails'@'localhost' ... REQUIRE SSL For starters requiring SSL for connections to/from localhost is completely senseless. SSL or TLS provide transport security which you don't need for communications that won't leave the actual system, that will not provide any additional security and only extra overhead. In addition the official MySQL ...


0

I tried to startup mysql in "Safe Mode" to create the sock file and pid file, but it fails for some error "bind", I changed the IP address in "bind ip" parameter in my.cnf to localhost started mysql in safe mode. restarted mysql in normal mode, and everything went fine.


1

For an RDS instance in VPC to "publicly" (Internet) accessible, all of the subnets it is attached to must be "public" -- as opposed to "private" -- subnets of the VPC. A public subnet is essentially defined as a subnet that has the Internet Gateway object (igw-xxxxxxxx) as its route to "the Internet," or at least to any Internet destinations you need to ...


0

service mysqld stop Edit /etc/mysql/my.cnf : Under the logging and Replication Locate log_bin. Un comment the log_bin service mysqld start


0

Look for the my.cnf configuration file which may contain the following line: lc-messages-dir = /usr/share/mysql As you said, mysql cannot access to this standard configuration file due to your current permissions. Two possible solutions: Change this parameter to an accessible directory, and pass your configuration file to mysql_install_db $ ...


0

Though it's an old question, but if you still looking for answer - try percona xtrabackup. If you have MyISAM tables, use --rsync option. With it we achieved almost seamless dump (lock took around 5-10 seconds for DB around 1Gb).


0

On master you need to have those lines: server-id = 1 binlog_do_db = database replicate-do-table = name On slave: server-id = 2 binlog_do_db = database


0

Try running this on slave GRANT ALL ON bladiebla.* to root@'%' If it will not work, show output from SHOW GRANTS FOR 'root'@'%';


1

A database server is a database server; regardless of where it's sitting. It's fairly easy to just repoint a line of code to a new database server. As with any technology related investments, you have to consider the following: latency; how much tolerance can your app or your company manage? performance; will the replacement solution provide enough ...


1

To find all socket files on your system run: sudo find / -type s My Mysql server system had the socket open at /var/lib/mysql/mysql.sock Once you find where the socket is being opened, add or edit the line to your /etc/my.cnf file with the path to the socket file: socket=/var/lib/mysql/mysql.sock Sometimes the system startup script that launched the ...


1

We are using a Galera cluster with 5 nodes that have a load balancer in front of them, that is continously checking all the nodes. Our configuration is that we only have one of the nodes serving a write and read target for the connections from the load balancer and the other nodes are hot standby. But of course Galera also supports multi master read and ...



Top 50 recent answers are included