Fermé

Fix SQL server blocking user

We have a network of 2 servers: one application server that makes SQL requests to an SQL server. Periodically, for reasons unknown, the SQL server locks out the user that is trying to run SQL queries (takes away all permissions to that user) and causes the application server to be very slow and then lock up. We must run mysql commands like "flush privilages;" (see screen shot) to re-allow the SQL user to access the database. When the problem is happening, the number of "unauthenticated users" goes very high in the "show processlist;" command ([url removed, login to view]). After running flush privilages; and restarting mysqld, the problem goes away ([url removed, login to view]) We use mysql 5.0.77-log Your job is to connect to our system remotely via TeamViewer and ssh and try to find the cause of the problem and suggest a solution, or setup some log so we can see the cause of the problem the next time it happens.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

CentOS Linux

Compétences : Tout va bien, Sécurité Informatique, Linux, MySQL, Tests / QA, Test d'Utilisabilité, Sécurité Web, Tests de Sites Web

en voir plus : sql server web, desktop lock screen, web teamviewer, sql server or, sql server job, SQL Server, sql server c, sql queries, sql commands, security log, locks, linux ssh server, fix slow, c sql server, access database sql web application, connect time server, teamviewer desktop application, linux teamviewer source code, run command linux, fix database access

Concernant l'employeur :
( 92 commentaires ) San Diego, United States

Nº du projet : #3320537

4 freelance font une offre moyenne de $77 pour ce travail

canlevw

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(62 Commentaires)
7.0
bgeorge

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(237 Commentaires)
6.3
amsterdamd

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(99 Commentaires)
5.8
jculkincys

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
3.5