Sorry for the delay Mike, I'll try and find some time work on this
more this weekend. Until then, read below ...
On 3/27/07, Mike Martin <[EMAIL PROTECTED]> wrote:
> Does this message appear in the browser? Are there any other error
> messages in log files, perhaps in the webserver logs or mysql logs?
Message appears in the browser. The webserver log shows nothing out
of the ordinary. I can't figure out how to check the mysql log ...
(kind of embarrassing)
It's in /var/log, or at least it is for me. I may have set that up
myself though, so if there's nothing named mysql in /var/log then
don't worry about it.
> When did this message appear? It looks like it is a fresh install of
> torrentflux, have you ever been able to log in?
It is a fresh install of etch with practically nothing else installed
except torrentflux. I was originally able to log on. I succesfully
used it for about a day. And then nothing. That was many
purge/reinstall cycles ago while I tried to correct the problem.
> Which version of mysql server are you using? Is it on the same machine
> or do you connect to it over the network? Do the torrentflux database
> and tables look reasonable (should be 7 tables)? How many entries are
> there in the tf_users table?
I'm using the etch mysql-server-5.0 package installed on the local
machine specifically for use by torrentflux. The database seems find.
"show tables" produces a list of 7 tables. "Select * from tf_users"
results in an empty set. As does a "Select *" from all the other
tables! -- hmmm -- that's problably NOT right.
Actually, that probably is right. On first install, when the users
table is empty, torrentflux gives "superadmin" privileges to the first
user to login and adds them to the table. It seems like the database
is fine, you just can't connect to it properly. My current thinking is
this:
1. The users table is empty, and torrentflux is prompting you to login
(you do get a prompt, don't you? and then the error when you fill it
in and submit?)
2. Torrentflux can connect to the database and see that the users table is empty
3. Seeing that its empty, torrentflux tries to insert you into the database
4. Insertion fails, giving the error
This leads me to believe (if all I have said is true), that the
database privileges were not created properly for the torrentflux
user. So, he can read the database, but not write to it. To confirm,
try logging in to the mysql server as the torrentflux user (you can
find the password to use in /etc/torrentflux/config-db.php) by doing
'mysql -u torrentflux -p torrentflux' and then enter the password at
the prompt. Now try to read the tf_users table 'select * from
tf_users;', and then try to insert into it 'insert into tf_users
(user_id) VALUES ('mike');'. If that works, you can delete it with
'delete from tf_users;', and I'll try and come up with something else.
Cameron
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
