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
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
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:
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
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
>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
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
> 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:
Have a simple flex app, say FlexApp to retrieve two tables and a view from
MySQL DB in webhosting service provider, say A and B. Currently, FlexApp
runs in service provider A with no problem at all. The FlexApp can be seen
in http://www.bbrchk.com/testdb/testdb.html Because we need to move to a
11 matches
Mail list logo