To simulate the problem in an environment that I can read the DB query log, I
joined a different plan in the same web hosting service provider. This plan
is called Managed VPS (let's called it planB as opposed to the shared web
hosting let's call say it planA). Th planA is having the programA that
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html (rtfm ;-)
On Thu, Jan 23, 2020 at 2:12 PM Javier Guerrero García
wrote:
> myname@% and myname@localhost are totally different users. The first
> means "myname connecting from anywhere", while the second means "myname
> only when it c
myname@% and myname@localhost are totally different users. The first means
"myname connecting from anywhere", while the second means "myname only when
it connects locally". Review permissions on the whole thing (tables, views,
user grants, etc...).
https://stackoverflow.com/questions/11634084/are-
Have followed Javier's hints to edit view of staffviewposition by applying
security to the invoker instead of the definer. But still unable to solve
the problem ie unable to fetch view data. see
http://www.bbrclubhk.com/testdb/testdb.html as compared to the one in
another web hosting service provid
You should follow Javier's hints, especially the part "Review the "DEFINER"
part on the "create view" statements in the dump file".
Take a look at the "Definer" section at the docs:
https://mariadb.com/kb/en/create-view/
If that doesn't help, enable the DB query log, something like this:
https://
hi,
The two Service Providers (SPA and SPB) are using different versions of PHP
and MySQL, the details is as follow. One point to note is that the flex app
is called testdb which will retrieve data from a DB called bookclub which
has 2 tables called staff and position and 2 views called staffviewp
If the definer is different and you've set the security to apply to the
*definer* of the view (instead of the *invoker* of the view), of course the
results might be different since the definer might not have enough
permissions to access the tables in the view:
[image: image.png]
Either change the
>but I can't find any view select statements.
Ahh.. forget about it, I just saw that 'staffviewposition' is the view
itself.
--
Sent from: http://apache-flex-users.246.n4.nabble.com/
Hi David,
are you're using the same PHP and MySQL versions on both servers?
In order to ensure that your MySQL view is basically working on the new
server you could test it by running your view statement e.g. by using
PHPMyAdmin.
BTW:
I just took at quick look at your generated PHP file, but I ca
Have checked out php error log at server side (error logging has been
enabled) but it did not generate any error. (I am sure the error logging has
been enabled because I intentionally edit the $databasename wrongly, I can
trigger the php error log stating DB access denied)
So, even I put back ever
> Have used charles webproxy, but it only say
flex.messaging.messages.ErrorMessage for my StaffviewpositionService
Did you check out the php error log at server side?
It could provide some helpful details.
(Of course, error logging has to be enabled)
Olaf
--
Sent from: http://apache-flex-user
11 matches
Mail list logo
