hydrazi
Posts: 12
|
| Posted: 01/20/2011, 6:28 AM |
|
Howdy,
Login just refreshes itself, as if I did not try to login. If I go to a page that is restricted, URL shows NotLogged.
I am pretty new to coding, self taught. I am using CodeCharge to build an interface to a MySQL web-based db. I have a local and a remote copy of the db and they are the same.
I ran the application builder and all seemed to go well. I used a table with no "reserved" names to provide Userid, Username, Password, and GroupNumber for authentication.
I have published it locally and online, same results.
The login page recognizes when Username or Password are blank, but not when they are wrong. I set a Return Page, but it just keeps showing NotLogged in the URL.
Any help would be greatly appreciated.
_________________
Matt Rand |
 |
 |
datadoit
|
| Posted: 01/20/2011, 6:49 AM |
|
Matt, start by checking PHP's register_globals. It should be 'off'.
|
|
|
|
hydrazi
Posts: 12
|
| Posted: 01/20/2011, 7:08 AM |
|
register_globals is OFF on local server and web server.
_________________
Matt Rand |
|
|
|
datadoit
|
| Posted: 01/20/2011, 7:18 AM |
|
Okay, go double check your Project Settings and your Connection. Make
certain those are correct, and you can successfully test connect. Using
MySQL ODBC 5.1 driver, set up your local design connection, and then
your remote connection. Recognize those are two different connections
that need to be set in order to deploy (either locally or remotely) and run.
|
|
|
|
hydrazi
Posts: 12
|
| Posted: 01/20/2011, 7:25 AM |
|
Ok, I checked Connection1 and Connection 2. Both are correct and are testing good. All of the pages not restricted connect and work perfect.
_________________
Matt Rand |
|
|
|
hydrazi
Posts: 12
|
| Posted: 01/20/2011, 7:34 AM |
|
I really appreciate your help. This determines if I am going to purchase the software for my own business or not.
Also, my user table looks like this:
UsID: id field: INT(10)
Userlogname: username field: varchar(20)
Pass: password field: varhar(20)
Groupnumber: security group field: INT(10)
_________________
Matt Rand |
|
|
|
datadoit
|
| Posted: 01/20/2011, 7:53 AM |
|
"Connection1 and Connection2" concerns me.
You should only need one defined connection. With that single
connection, you're really setting two things:
1. Your local design connection. This is the connection that is made
locally using the MySQL ODBC 5.1 driver. This is so that when designing
your application, you can select tables, fields, etc., or use the Visual
Query Builder.
2. Your remote connection (the remote tab in connection properties).
That is the connection to the remote database where the world will use
your application. If you're designing on your local machine, and you
want to publish to a local web server such as WAMP or XAMPP, and then
run your application from your local machine for testing
(http://localhost/yourapplication.com). However, it could also be used
or defined for your production machine, particularly if your production
machine also has the database residing on the same machine. In that
case, you can always use 'localhost' as the server. Localhost will work
on your local machine for testing, and it will also work on the
production machine in that scenario.
The only time you'll need more than one connection defined in CodeCharge
is when you literally need to use two different databases.
Check on the above and report back. If this doesn't work, we'll do a
remote session and I'll walk you through it.
|
|
|
|
hydrazi
Posts: 12
|
| Posted: 01/20/2011, 7:58 AM |
|
Ok, I removed Connection 2 and have set everything for Connection1. It was already set for that, so not much change. Same problem exists and all of the unprotected pages work just fine. I am using the online (web) database for local and remote now too. Same issue, no new ones.
_________________
Matt Rand |
|
|
|
datadoit
|
| Posted: 01/20/2011, 8:22 AM |
|
Sent you a PM with connect instructions.
|
|
|
|
damian
Posts: 838
|
| Posted: 01/21/2011, 9:46 PM |
|
reboot your web server...
check session folder.
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
hydrazi
Posts: 12
|
| Posted: 02/02/2011, 1:12 PM |
|
Weird but it had something to do with having MySql installed on the machine. I removed it and now it all works.
_________________
Matt Rand |
|
|
|
|
