Tag Info

New answers tagged

0

The risk depends somewhat on how you run PHP and the file-system permissions that are supported then. As for the password being in clear text, as far as I know there's no way yet to avoid having the clear text password somewhere. From MySQL 5.6 you have the MySQl config editor which allows you to encrypt MySQL login credentials so they're no longer ...


1

The issue is you don't allow new connections to be established to MySQL and you inverted sport and dport : Chain INPUT (policy DROP) ... ACCEPT tcp -- 10.99.0.12 anywhere tcp dpt:mysql state NEW,ESTABLISHED ACCEPT tcp -- localhost anywhere tcp dpt:mysql state NEW,ESTABLISHED ... Chain OUTPUT (policy DROP) ... ACCEPT tcp -- anywhere ...


0

It's been a while since this question was asked, but in case it's helpful to anyone coming across it, one approach would be to try turning on the general query log to see all queries that are being executed (see http://dev.mysql.com/doc/refman/5.5/en/query-log.html) and see if any look familiar. If you don't recognize the queries, you could try doing a ...


1

pt-upgrade can execute queries on two servers and compare results. It's one of the steps to do before major version migration


0

You said you were running a MySQL script. But it sounds like this is a PHP script that runs the batch process. In either case, is it possible that you are creating an enormous single transaction? If you are using one of MySQL's transactional engines (InnoDB is the default on new versions of PHP), a transaction will be started at the beginning of the script. ...


0

Do you mean 4 slaves from one master? If so, that's a pretty common configuration for read scaling. INSERT, UPDATE, MERGEm, and DELETE on the master. Then SELECT from any of the saves to spread out the read load. Most versions of MySQL will support this. I'm not sure where the stand-alone server gets its data. Is it the master? Is it another slave. If the ...


0

Chances are your memory is still there. top doesn't report memory usage minus the buffer cache the OS uses for file cache. Type the following for true free memory free -m Look at the -/+ buffers/cache: line for the true free memory in megs. Linux will use all memory for filesystem cache along with most OSes. It does that so it doesn't have to do slow ...


1

I was able to resolve this myself. The key issue is that I built courier-authlibbinaries on my dev box but my production box had mysql-5.5.* and my dev box had mysql-5.6.*. Obviously, the difference between lib files caused the authmysql to crash when invoked... Hope this will be helpful to someone...


0

I have no idea how to figure out what's going on. Is Apache or MySQL not tuned properly? Maybe someone is attacking the server with repeated hits (how would I know?). I installed htop but even if I saw that Apache or MySQL was eating up a ton of resources, how would I figure out why? First, I would not panic about an attack happening. The ...


0

First install these plugins: super cache (htaccess mode), wpbase, widget cache. Wordpress is known for having these issues. IF that doesn't help, it might be a memory leak on one of your themes (especially if mobile view is enabled). Post your access and error logs. I strongly recommend working with nginx instead of apache.


0

Since MariaDB Galera cluster versions 5.5.40 and 10.0.14 you can use the query cache. Earlier versions do NOT support the query cache. See https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/buffers-caches-and-threads/query-cache/#limitations


0

According to https://launchpad.net/ubuntu/precise/amd64/mysql-server, that particular version has been superseded by mysql-5.5 5.5.29-0ubuntu0.12.04.1 (which in turn has a long chain up to 5.5.40-0ubuntu0.12.04.1). I'm guessing that most mirrors remove superseded versions to save space. With a little searching around, you can probably find a mirror (maybe ...


0

Installing the MySQL "linux generic" binary (pre-compiled, not "source") distribution from the tarballs is painfully straightforward... you extract the tarball, cd into the directory, and start it, and multiple versions coexist on the same machine, in different directories, with no conflict... On Ubuntu, the only noteworthy dependency is libaio1, which you ...


1

You get what you pay for. That server is likely loaded to the brim with other users all making use of the hosting, so there's not much you can do but try another provider or host yourself.


-1

============================== ***Solved : createt link and solved , chmod 777 libmysqlclient.so.16 ls -s libmysqlclient.so.16 libmysqlclient.so.16***emphasized text** root@herrysys herry]# service mysqld start /usr/bin/mysqladmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory Cannot ...


0

lib*.so is a shared library & Linux needs to know where to it. In this case MySQLadmin is looking for libmysqlclient.so.16. locate has found the library in two different directories. 1. /home/local/CORPORATE/hardik/libmysqlclient.so.16 2. /usr/lib/mysql/libmysqlclient.so.16 Check /etc/ld.so.conf & see if these directories are listed there. There is ...


1

it is round robin so the first query will go to my1TbTemp and the next will go to my5TbTemp. If the first is full it will then move to the my1TbTemp for the query.


0

do not follow the 1st answer it's a very bad issue. If you read the line correctly you will see there is NO problem cause not corrupt table or anything else can be found "Checking for corrupt, not cleanly closed and upgrade needing tables" so everything is ok.


0

I would investigate if table_open_cache limit isn't the bottleneck reason. Perhaps the threads are simply blocking, causing long execution time and high CPU. Also, enabling the query cache can possibly help, like switching query_cache_type to ON and setting the query_cache_size to 1G. If that helps, you could also try to play with it's amount, because ...


0

You're missing the MySQL client libary, not the MySQL library itself. The error is complaining about: libmysqlclient.so.16 Try installing the mysql-libs package. If you've already installed it, try reinstalling. libmysqlclient.so.16 appears to be part of it. Where did you get the MySQL packages from that failed to install? You might have to clean out some ...


0

By looking at the benchmarks of this article (MySQL Performance Blog), you should really avoid MySQL’s native SSL capability.


1

Be careful with your optimization targets, as already mentioned: When you optimize your queries for repeated runs, you will get optimal results for queries which are run several times in short succession (but you might use query cache for that). By repeating the queries, you "warm up" OS disk caches, so disk seeks are not accounted into your timing any ...


1

The operating system uses unused memory as cache. Why is this a problem? Edit To get times spent with the different part of a query operation, you can set on profiling with set profiling=1; and show the profile with show profiles and show profile for query <n> after running a query.


0

The cause of problem was stupid. I double checked the MySQL binary log, and found that insert statements were suspicious. The column in question has got values like 0x3134...30 as time stamp values, which seems to be a string value rather than intended integer. And following this clue, I found that the parameter binding calls in PHP side was using a wrong ...


0

Using PHPMyAdmin all variables are already listed if you click "home" > "MySQL system variables". You can use the find feature of your browser to search for the "hostname" and the "port" variables or scroll to them. It's listed in alphabetical order. No mucking about with queries if you are a non technical person.


0

If you want to know from within MySQL you can check the status variable Rsa_public_key as it only exists in builds with OpenSSL: SHOW STATUS LIKE 'Rsa_public_key'; (See the relevant documentation: http://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html#statvar_Rsa_public_key) PS: Currently, the MySQL Community Edition binaries built by MySQL ...


2

This doesn't require a specific privilege, as a transaction just groups a number of database operations into one to maintain consistency. All you need is to have the privileges to do all operations within the transaction. Please take the time to actually read the MySQL documentation.


0

In the end, what I had to run was: chmod 0777 /var/lib/mysql/ib_logfile0 chmod 0777 /var/lib/mysql/ib_logfile1 chown -R mysql:root /var/lib/mysql Then service mysqld start worked.


1

Check for permissions on mysql folder. PID should automatically get created when you start the mysql service. What does the mysql error log say ?


0

Not sure of how distro-specific this is, but I have just incorporated a security limit increase by using /etc/security/limits.d/20-somefile.conf in Ubuntu. Rather than having to modify an existing file, I have an ERB template in my cookbook, set default attributes in an attributes file and then don't have to worry about using ruby blocks with ...


0

If you move your datadir, you not only need to give the new datadir permissions, but you need to insure all parent directories have permission. I moved my datadir to a hard drive, mounted in Ubuntu as: /media/*user*/Data/ and my datadir was Databases. I had to set permissions to 771 to each of the media, user and Data directories: sudo chmod 771 *DIR* ...


1

For anyone else looking it was easier than I expected with postfix: First check for mysql support with: postconf -m Then: edit main.cf with appropriate defaults (set myhostname,mydomain, mydestination check inet_interfaces isn't bound to just localhost) then add the following to the bottom of main.cf: virtual_alias_maps = ...


2

I would setup MySQL to log to syslog and configure nowadzys versatiles syslog daemon (eg rsyslogd) to trigger an email when it matcha mysql log message that matches the appropriate pattern.


0

MyISAM was the default storage engine for the MySQL relational database management system versions prior to 5.5 http://en.wikipedia.org/wiki/MyISAM Wheezy deprecates the use of MyISAM with MySQL 5.5. Simply add: default-storage-engine=myisam ..under the [mysqld] section in the file /etc/mysql/my.cnf I recently ran into this when doing an upgrade from ...


1

With exim you can use router like this: db_fwd: driver = redirect data = ${lookup mysql{SELECT `destination` \ FROM `forwarding` \ WHERE `uniqueID`='${quote_mysql:$local_part}'}} allow_fail allow_defer Table forwarding contains such rows: ID uniqueID destination 1 ...


1

You can't. MySQL is unable to differentiate between a CLI session and a connection from a library, or at least has no permission model to act upon that difference. Generally, you have to make the permissions as specific as possible. A connection that should be allowed from a specific webserver should be restricted to that server alone. This reduces the ...


1

You generally deal with that in 1 of two ways or both if you want. You set the grant location to only allow the user connect from an ip, ip range, or hostname from where you want the user to connect to So for example GRANT SELECT, INSERT ON mydb.* TO 'someuser'@'127.0.0.0.1'; To grant select and insert from localhost only. Or say your web servers are on ...


0

Users in standard mysql auth are made up of a username and host portion (username@host) and protected by a password. That's it. If you want to use standard MySQL user authentication, you can't achieve this exactly. There are ways of doing operating system authentication within MySQL, but this is well documented. e.g. PAM authentication: ...


0

I've figured this out, you need to update the schema version stored in the database itself, you can do this manually by running this SQL against the database. UPDATE my_aspnet_schemaversion SET version = 10 Replace 10 with whatever version is appropriate for the connector you've downloaded.


0

It turns out that it has nothing to do with the gcc version or optimization failures. Instead, it's an incomplete compile/link of the exim binary. There is a flag (-rdynamic) for gcc to tell the linker to export the symbols to be visible to dynamically loaded modules. This flag must be passed to gcc when building the mysql.so and when building the Exim ...


1

Is not very efficient compared with installing Ubuntu server in minimal for VM mode, but will run, specially for that workload. The good news is that as it was sized for a desktop, you can uninstall all the unneeded packages (starting with all X related ones) and use all that freed memory for mysql.


0

You can use a configuration management tool like Puppet to manage your Apache configurations. The module https://forge.puppetlabs.com/puppetlabs/apache allows you to abstract your configurations and get assurance that configurations in all managed servers match the intended configuration. Similarly, you can use a module like ...


1

In your GRANT you specified a database name of costo_jmat. But your import has a database name of jqcm_import. Fix that.


1

I finally found the solution. Postfix is configured to look in the database that the user exists to deliver the email, so Dovecot shouldn't have to do it when receiving an email from Postfix to deliver. That's how it is supposed to work, and the reason why we define a static user_db. It missed one parameter so that Dovecot wouldn't check if the user exists, ...


0

You can easily upgrade your server’s MySQL version with WHM’s “MySQL Upgrade” interface, which is located at: Home >> Software >> MySQL Upgrade.


1

I highly recommend using a tool for this and not mysqldump In the past I have used https://github.com/philipsoutham/py-mysql2pgsql with great success


1

Since you are using direct routing the virtual IP will need to be configured on both servers at the same time. You can accomplish this by having a second vrrp instance which configures the VIP (10.116.219.12) on the loopback interface of the secondary server. When the connection is forwarded from the load balancer to the secondary server it will respond ...


0

This was due to upgrading postfix and using old config files.


0

Enable slow query logging in my.cnf to find where your bottleneck queries are and assume taking a look if max_used_connections is greater than max_connections. SHOW GLOBAL VARIABLES LIKE 'max_connections'; SHOW GLOBAL STATUS LIKE 'max_used_connections';



Top 50 recent answers are included