[ZendTo] Re: Unable to write to DB

[Der PCFreak]

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
> 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/cacdfa39/attachment.html