little help please if possible (pwAdmin)
I wonder if we could get a little help please.
Our PWAdmin for the 1.4.4. is acting up a little and not sure what is wrong.
We can see accounts on the index page, so the admin is connecting to the data base to read that, we can start maps etc no problems there, however when we try to add a new user account or add cubi to an account it reports "cannot connect to MySql database".
We've checked pwadminconfig.jsp and all seems fine there concerning the database connection settings.
SO the problem seems to be that admin can read from the database but not add to it.
To make matters more confusing we are able to create a new user account using the registration page in var/www which has exactly the same connection settings as admin.
Anyone have any idea what is going on?
Thank you in advance if anyone replies with help.
Re: little help please if possible (pwAdmin)
You have 1 installation of MySQL, your /var/www is connecting to the working/right mysql socket, your pwAdmin is connecting to the wrong socket. That's my guess atleast and it's probably the right reason. To fix, point your pwadmin's mysql socket to the right one.
Re: little help please if possible (pwAdmin)
maybe you have updated the mysql database and use the wrong connector... like mysqlconnector5.0 jar with 5.1 mysql server... update the mysql jar in pwAdmin or jetty lib folder with the most recent official version.
MySQL :: Download Connector/J
Re: little help please if possible (pwAdmin)
Thank you for your replies we will give these a go.