[ZendTo] Re: Unable to write to DB

[Brian Novogradac]

When I do that I get no results

Still same error upon attempting dropoff

I even downgraded to mysql 5.6 same issue.



From: zendto-bounces at zend.to [mailto:zendto-bounces at zend.to] On Behalf Of Der PCFreak
Sent: February-19-16 8:10 AM
To: zendto at zend.to
Subject: [ZendTo] Re: Unable to write to DB

Hi,

you should try if you could connect to the DB from bash first like this:

#!/bin/bash
sqlu="zendto"
sqld="zendto"
sqlp="zendto"

echo select * from dropoff | mysql -B -E --user=$sqlu --password=$sqlp $sqld;


and see if you get results. (Change the credentials to your needs)

P.S.
Could it be, that you used a 'special' character when adding the access rights for the zendto db user that needs to be escaped and maybe your password is now different than you think it is?

Kind regards

PCFreak

On 18.02.2016 15:50, Brian Novogradac wrote:
Hello everyone,

I need some assistance hope someone can help  Ive just set up the system on a centos with mysql 5.7.11.  authenticating via AD, that works fine but when I go to do a dropoff I get the following error:

Upload Error

Unable to add a dropoff record to the database, please notify the administrator.


In the preferences file I have the correct info for DB user id using MySQL.  Cant find anything in logs that would tell me otherwise unless im missing something.

Any help be appreciated

Brian Novogradac





_______________________________________________

ZendTo mailing list

ZendTo at zend.to<mailto:ZendTo at zend.to>

http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20160219/d4bcfc35/attachment.html