Find Jobs
Hire Freelancers

Resolve error between application and mysql server

₹1500-12500 INR

Closed
Posted about 5 years ago

₹1500-12500 INR

Paid on delivery
Right now we are trying to update product from backend and its giving error SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('ozadmin'@'%') does not exist, query was: UPDATE `catalog_product_entity` SET `attribute_set_id` = ?, `type_id` = ?, `sku` = ?, `has_options` = ?, `required_options` = ?, `created_at` = ?, `updated_at` = ? WHERE (entity_id = '6') We have one application server and one mysql server in azura. All other things working fine but when i try to update products its trying to do operation with the mysql server ssh user not with mysql user. This might be because internal ip use for communication between two servers.
Project ID: 18763114

About the project

16 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₹3,971 INR for this job
User Avatar
Hi, I will fix this error: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('ozadmin'@'%') does not exist, query was: UPDATE `catalog_product_entity` SET `attribute_set_id` = ?, `type_id` = ?, `sku` = ?, `has_options` = ?, `required_options` = ?, `created_at` = ?, `updated_at` = ? WHERE (entity_id = '6') Thank you
₹5,555 INR in 0 day
4.9 (571 reviews)
7.4
7.4
User Avatar
Hello, This is Amal from Skynats Technology, We have gone through your project and would be happy to help with the task of fixing the connectivity issue between application and mysql. We can start the work now get it completed within an hour or two. Check out our freelancer profile ================ https://www.freelancer.com/u/skynatstech About us ======== Skynats is a group of talented system administrators who can help you with any server related task with their vast experience in the area of Linux/ Windows server environment. Kindly do consider our bid so that we can have a detailed discussion through chat on the project. Hope to hear from you soon. Thank you
₹3,000 INR in 1 day
5.0 (402 reviews)
7.0
7.0
User Avatar
Hello, I'm pretty sure that I can help you with your project. If you have questions, please contact me! Regards, Bogdan S
₹2,950 INR in 0 day
5.0 (207 reviews)
6.5
6.5
User Avatar
Update:- It could also be wrong user connection type mention in api I am a Linux admin have 9 years of experience in this field. I worked in webhosting industry and manage datacenter from remote. I give full server management support this issue seems with mysql connect may be need to allow mysql from api etc. I can fix this for you in some time. You can add me on skype:- vinnie6669 to discuss more I also have experience working on AWS cloud. I worked in the following areas. * cPanel/WHM * Plesk * Webmin * Website Panel * Website migrations * Installation and configurations of applications like Wordpress, Joomla, magento, etc * Email server configuration and maintenance * FTP and DNS service configurations * Amazon web services like, EC2, S3, Route 53, VPC, RDS. * Migration Specialist *Postfix Mailserver with spf, dkim and IP rotation. *Nagios Monitoring setup *PCI Compliance *FFMPEG server setup *Imagemagick install. *MySQL , MariaDB database administration *DNS server and nameserver configuration *SSL installation/Lets Encrypt Please give me a chance to work with you. I am sure that you will be 100% satisfied
₹3,333 INR in 3 days
5.0 (122 reviews)
6.2
6.2
User Avatar
I have 8 years of experience in managing complex linux architectures and managing cloud infrastructures. I have worked on many complex projects ( Private cloud setup on AWS, Load balancing clusters, Replication systems and many more). I have versatile experience in setting up and managing server and also optimising them for best usage and fine tuning the security aspects. I have expertise in below fields :- 1 Linux Administration. 2 Windows Administration (Windows 2008 , 2012 & 2016) and Migration. 3 Cloud computing ( AWS, Azure and Google Cloud). 4 Automation ( Ansible,Puppet and Chef). 5 Application's & Web servers ( Apache, nginx, IIS and Tomcat ). 6 Databases ( Mysql, MsSql, MongoDB, postgresql and Apache CouchDB). 7 Security ( Web Security, Server hardening and IPS && IDS configuration) 8 Virtualization( KVM, Xen, OpenVZ & Parallels Virtuozzo). 9 Control Panels ( Cpanel, website panel, zpanel and parallel plesk panel). 10 Shell scripts, python & Perl etc. 11 Mail servers.
₹2,250 INR in 1 day
4.9 (79 reviews)
5.9
5.9
User Avatar
I am MySQL DBA having more than 8 yrs of experience and expertise in database recover,..............
₹3,333 INR in 1 day
4.9 (48 reviews)
5.5
5.5
User Avatar
We Believe in Delivering Perfect Work and Providing Full Satisfaction to Our Client . We also Insure to Deliver the Work in the given Time Frame . we have highly Qualified Professionals in our team
₹1,750 INR in 1 day
4.8 (27 reviews)
4.9
4.9
User Avatar
Hi. Can help You fix properly this issue, which you get with your app, when try to update products. Tnx and Regards.
₹1,500 INR in 1 day
4.7 (50 reviews)
4.8
4.8
User Avatar
Hi Hope you are doing well.I have 7 yrs of experience on web developement with various assignment completed successfully and looking forward for many more like the same. I have great understanding of application architecture and did various assignment in that field as well.
₹1,750 INR in 1 day
5.0 (4 reviews)
2.7
2.7
User Avatar
I have very good experience of PHP and MySQL. Let me know your version of PHP and MySQL Server. Also remember to task backup of existing data before updating.
₹2,250 INR in 3 days
5.0 (2 reviews)
0.7
0.7
User Avatar
Dear Sir / Madam, I have Gone Through your Problem of Mysql & we can Resolve it On Urgent Basis. We have 5+ Year Exp in Mysql & Other Web Technologies. Kindly Revert back ASAP. Regards, Vikram Bodke +91 7588619361 Skype : Vickram678
₹11,110 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Worked on Advance Web Applications Conceptualized and designed Sales force Management application, a staff management and monitoring solution installed on over 1,000 locations in India. Design and development of several software products that received awards and industry recognition. Ability to manage multiple projects simultaneously and under pressure. Ability to manage the PHP team and manage the multiple projects. Expertise on sales force management applications and handle the real time problems. Some projects are - 1) Sterlite Power(Power Sector project) 2) ACME(Sales force management) 3)NetworC(Fleet application. Its Under process ) 4)National Dairy Development Board 5)Cairn India(Task Management)
₹1,750 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in L2-L3 support where I have resolved many issues, so I am sure that I can fix this issue as well.
₹4,444 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We will solve your problem
₹8,888 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a system engineer full time Relevant Skills and Experience I am a system engineer full time
₹7,777 INR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Feb 4, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.