Fix CentOS MySQL ERROR:

$10-30 USD

Completato

Pubblicato

circa 7 anni fa

$10-30 USD

Pagato al completamento

after a server hang and reboot, mysql no longer works. upon starting we get some permission error. Need to be worked on ASAP. 170404 8:08:42 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 170404 8:08:42 [Note] mysqld (mysqld 5.5.54-cll) starting as process 6901 ... 170404 8:08:42 [Warning] Can't create test file /var/lib/mysql/s97-74-237-211.lower-test 170404 8:08:42 [Warning] Can't create test file /var/lib/mysql/s97-74-237-211.lower-test 170404 8:08:42 [Note] Plugin 'FEDERATED' is disabled. 170404 8:08:42 InnoDB: The InnoDB memory heap is disabled 170404 8:08:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170404 8:08:42 InnoDB: Compressed tables use zlib 1.2.3 170404 8:08:42 InnoDB: Using Linux native AIO 170404 8:08:42 InnoDB: Initializing buffer pool, size = 128.0M 170404 8:08:42 InnoDB: Completed initialization of buffer pool 170404 8:08:42 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation.

Linux

Rif. progetto: 13616627

Info sul progetto

17 proposte

Progetto a distanza

Attivo 7 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato a:

@tlchung

I am a skilled server admin, i can help you on the db issue. please send me login details. let discuss more via private message, thanks.

$25 USD in 1 giorno

5,0

(57 valutazioni)

5,4

17 freelance hanno fatto un'offerta media di $34 USD

@dkokmadis

Hello from Greece, Do you have ssh access to the server? Regards, Dimitris

$30 USD in 1 giorno

5,0

(248 valutazioni)

6,4

@Rasil

Hello. Seems previously your mysql was run as root. You have to check permissions at /var/lib/mysql/ And could solve this by changing the ownership of the folder to mysql from group root (sudo chown -R mysql:root folder.

$30 USD in 1 giorno

4,9

(73 valutazioni)

5,5

@yasithab

Hello mate, A senior systems engineer with 8+ years of industry experiences. Let me check this now. Look forward to hearing from you. Thanks!

$35 USD in 1 giorno

5,0

(50 valutazioni)

5,4

@bms8197

Bid Summary As you can see on my profile, I have plenty experience related to linux servers and all kind of services running on linux I am pretty sure that I can help you with your issue.

$25 USD in 1 giorno

4,9

(50 valutazioni)

5,4

@Netfreehost

I have 15 years of experience in Linux server administration and PHP Programming. Message me, let's discuss the project.

$25 USD in 1 giorno

5,0

(101 valutazioni)

5,3

@iglobalvn

Hi sir, I have read your requirement carefully. I am interested to work for this project and i will provide within or before 30 minutes . If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my ability that can do your project enough. Especially, this is my experienced and successful work before Of course, I know you could be in doubt about my real ability. It would be important for me to prove my ability through real project. I hope this project would be the first step in long term partnership with you. I await your favorable reply with interest. I feel confident my execution of this order will be to your complete satisfaction. I ready to start right now . Please feel free to ask any questions and we would be happy to assist you. Regards,

$30 USD in 1 giorno

4,8

(11 valutazioni)

4,9

@redssr

I will require the root ssh access of the server to debug and solve the error. About myself, 6+ yrs of relevant exp in Linux with followings 1) OS: Redhat,CentOS,Fedora Debian and Ubuntu with Server Management, User management Bash scripting to take daily backups for database and code 2) APPLICATIONS:: a) LAMP Platform MemCache, Opcache b) SVN server c) Redmine 2.x, 3.x installation on CentOS 6 d) Webservers: Apache Nginix e) Load Balancing Ngnix, HAproxy 3) DATABASE:: MySQL/MariaDB/Percona installation, replication, galera cluster percona cluster,performance tuning and troubleshooting 4) MONITORING TOOLS:: a) Nagios with email and way2sms gateway notifications b) Zabbix 2.4 with Email and ez-texting notifications. 5) CLOUD: a) AWS:- EC2 with autoscaling, VPC, RDS, Elasticache, S3, CloudFront, Route53 and SES b) DigitalOcean: 6) OTHER TECHNOLOGIES:: Email marketing, DNS (power DNS setup with replication), LTSP, Redis, XenServer, KVM, DHCP ISPConfig3, Webmin/virtualmin, CWP, ERPNext

$25 USD in 1 giorno

5,0

(34 valutazioni)

4,3

@sachinkumar19

A proposal has not yet been provided

$50 USD in 1 giorno

5,0

(13 valutazioni)

3,6

@tolismx3

Hello, i bid with small fee because i want to help.. I will not charge you more . This is true and this is my final offer. Please contact with me to fix your issues immediately and NOW. Best Regards.

$30 USD in 0 giorno

5,0

(2 valutazioni)

2,8

@gafhus

I would make sure path exists and has the right ownership and permissions. I would require an ssh root access for this task. I would start on it right away Best

$30 USD in 1 giorno

5,0

(1 valutazione)

2,8

@drl3x

Hi, Do you running on centos ? Do you have selinux enabled ? This sounds as selinux problem and/or ibdata corruption. You have to check permission on your mysql datastore (maybe /var/lib/mysql) and check it selinux running. If are you running selinux you may try this restorecon -R /var/lib/mysql/ Let me know if you need further help. Regards

$20 USD in 1 giorno