Textpattern CMS

#1 2007-03-06 13:42:47

massimo

Member

Registered: 2006-02-02

Posts: 14

db manager installation error

when i try to install db manager plugin, textpattern gives me this warning:
Access denied for user ‘mydatabase’@’%’ to database ‘mydatabase’ insert into txp_plugin set name = ‘rss_admin_db_manager’, status = 0, type = 1, author = ‘Rob Sable’, author_uri = ‘http://www.wilshireone.com/’, version = ‘4.3’, description = ‘Database management system.’, help = ‘

how can i solve this?

#2 2007-03-06 15:26:55

massimo

Member

Registered: 2006-02-02

Posts: 14

Re: db manager installation error

i just realized that i can’t do anything, not only with pluging but with articles too, everything i try to do with the db i receive that error: Access denied for user ‘mymane’@’%’ to database ‘mydatabase’
how can i change that info? what is that ‘%’?

Last edited by massimo (2007-03-06 15:28:06)

#3 2007-03-06 18:07:09

els

Moderator

From: The Netherlands

Registered: 2004-06-06

Posts: 7,458

Re: db manager installation error

From the FAQ:

If you receive an “Access denied” or mysql_connect error during installation, it usually means that one or more of the MySQL parameters (host, database name, user name, password) are incorrect. Double check those values, and consult your hosting company’s technical support resources if problems persist.

#4 2007-03-06 18:35:55

massimo

Member

Registered: 2006-02-02

Posts: 14

Re: db manager installation error

thanks els, anyway my problem is not about an installation, i had a working textpattern installation since months, but today i found this problem.
1 may be because i trunkated the log table in the database, to reduce the size of the db, but on my local installation it worked without problems
2 may be because today i tried to double the storage for my db

ps. els, that values you are talking about are in config.php, right?

Last edited by massimo (2007-03-06 18:37:41)

#5 2007-03-06 19:40:12

els

Moderator

From: The Netherlands

Registered: 2004-06-06

Posts: 7,458

Re: db manager installation error

massimo wrote:

thanks els, anyway my problem is not about an installation, i had a working textpattern installation since months, but today i found this problem.
1 may be because i trunkated the log table in the database, to reduce the size of the db, but on my local installation it worked without problems

You don’t have to trunkate the log table manually. In preferences you have set after how many days the logs should expire. Older entries will be deleted every time you open Admin > Visitor logs. (So if you never go there, yes, the logs table will keep growing…)

2 may be because today i tried to double the storage for my db

Not sure what you mean by this.

ps. els, that values you are talking about are in config.php, right?

Yes, that’s right.

I’ll move this thread to troubleshooting, you’ll probably get some help there.

#6 2007-03-06 21:41:25

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: db manager installation error

…i trunkated the log table…

You don’t have to trunkate the log table manually.

And truncating the log table wouldn’t cause a problem in any case.

#7 2007-03-07 05:42:32

massimo

Member

Registered: 2006-02-02

Posts: 14

Re: db manager installation error

ok, it’s all right now
my host disables for some hours writing permission when changing the database size