Re: [web2py] Re: plugin wiki issues
It's been working up to this point...not sure why it won't work now...
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
and it just worked on my test db server with the exact same config..
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
nix that last comment...didn't have the plugin loaded. did not work
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
even tried it as rootno dice.
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
if I recreate the database from scratch, then re-import my data, it works
fine.
On Tuesday, May 8, 2012 4:33:54 PM UTC-4, Larry Wapnitsky wrote:
even tried it as rootno dice.
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to those
that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db = DAL('mysql://
user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights
to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has
some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
:-)
On Tuesday, 8 May 2012 21:37:52 UTC+1, Larry Wapnitsky wrote:
if I recreate the database from scratch, then re-import my data, it works
fine.
On Tuesday, May 8, 2012 4:33:54 PM UTC-4, Larry Wapnitsky wrote:
even tried it as rootno dice.
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to those
that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db = DAL('mysql://
user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights
to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has
some better advice to get this working.
Regards, D
