I have finally reached the point where I am trying to load up the = hompage for Koha. I followed the instructions for installing Koha on = Debian (sarge). After going to http://myip:8080 it looks like my Koha = is going to load then I get an Internal Server Error. When checking the = apache2/error.log I read: access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411 Any help would be greatly appreciated. Thanks, Derek
I have the very same issue. I'm trying to resolve it now. When I have it fixed I'll forward you my solution. and please if you get it resolved before me please give me your solution!! Thank you, Joe Allen www.viktoriastift.de On 4/20/06, Morgan, John D. <jmorgan@admin.fsu.edu> wrote:
I have finally reached the point where I am trying to load up the = hompage for Koha. I followed the instructions for installing Koha on = Debian (sarge). After going to http://myip:8080 it looks like my Koha = is going to load then I get an Internal Server Error. When checking the = apache2/error.log I read:
access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411
Any help would be greatly appreciated.
Thanks, Derek
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I did not had similar problems but seems a lot like a mysql configuration problem. Can you connect to the database using the mysql shell? Did you properly configured the mysql password for user www-data in koha? Len On Thu, 2006-04-20 at 12:49 +0200, Joe Allen wrote:
I have the very same issue. I'm trying to resolve it now. When I have it fixed I'll forward you my solution. and please if you get it resolved before me please give me your solution!!
Thank you, Joe Allen www.viktoriastift.de
On 4/20/06, Morgan, John D. <jmorgan@admin.fsu.edu> wrote:
I have finally reached the point where I am trying to load up the = hompage for Koha. I followed the instructions for installing Koha on = Debian (sarge). After going to http://myip:8080 it looks like my Koha = is going to load then I get an Internal Server Error. When checking the = apache2/error.log I read:
access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411
Any help would be greatly appreciated.
Thanks, Derek
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Yup I followed the instructions perfectly myself and I am sure Derek did as well. I can connect to MySql as kohaadmin with the password I selected during installation just fine. The problem is the user www-data is NOT given a password for MySql and it is trying to connect without one and is being refused. I have attempted this install on Debian Sarge and Mandriva 2006. Both systems end up with the same error. I have Koha currently installed on Mandriva 2006 with MySql 4.1.12 and Apache 2.0.54. Does anyone have a solution for this? Joe On 4/20/06, Marilen Corciovei <marilen.corciovei@nemesisit.ro> wrote:
I did not had similar problems but seems a lot like a mysql configuration problem. Can you connect to the database using the mysql shell? Did you properly configured the mysql password for user www-data in koha?
Len
On Thu, 2006-04-20 at 12:49 +0200, Joe Allen wrote:
I have the very same issue. I'm trying to resolve it now. When I have it fixed I'll forward you my solution. and please if you get it resolved before me please give me your solution!!
Thank you, Joe Allen www.viktoriastift.de
On 4/20/06, *Morgan, John D.* <jmorgan@admin.fsu.edu> wrote:
I have finally reached the point where I am trying to load up the = hompage for Koha. I followed the instructions for installing Koha on = Debian (sarge). After going to http://myip:8080 it looks like my Koha = is going to load then I get an Internal Server Error. When checking the = apache2/error.log I read:
access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411
Any help would be greatly appreciated.
Thanks, Derek
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
"Joe Allen" <joeallen1974@gmail.com>
[...] The problem is the user www-data is NOT given a password for MySql and it is trying to connect without one and is being refused.
Check the permissions on /etc/koha.conf - the user running the CGI scripts (www-data) can't read it, so it doesn't know the koha username or password. IIRC, you probably want it to be -rw-r----- root www-data (chgrp www-data /etc/koha.conf ; chmod 640 /etc/koha.conf) unless you are running apache suExec or similar. Hope that helps, -- MJ Ray - personal email, see http://mjr.towers.org.uk/email.html Work: http://www.ttllp.co.uk/ irc.oftc.net/slef Jabber/SIP ask
MJ Ray, It appears that your solution was the answer to my problem. It was file permissions. If we ever meet. I will buy you a beer. Cheers, Derek ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of MJ Ray Sent: Thu 4/20/2006 7:14 AM To: joeallen1974@gmail.com; marilen.corciovei@nemesisit.ro; Koha@lists.katipo.co.nz Subject: Re: [Koha] internal error "Joe Allen" <joeallen1974@gmail.com>
[...] The problem is the user www-data is NOT given a password for MySql and it is trying to connect without one and is being refused.
Check the permissions on /etc/koha.conf - the user running the CGI scripts (www-data) can't read it, so it doesn't know the koha username or password. IIRC, you probably want it to be -rw-r----- root www-data (chgrp www-data /etc/koha.conf ; chmod 640 /etc/koha.conf) unless you are running apache suExec or similar. Hope that helps, -- MJ Ray - personal email, see http://mjr.towers.org.uk/email.html Work: http://www.ttllp.co.uk/ irc.oftc.net/slef Jabber/SIP ask _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I'm not sure if "www-data" user should connect to database. Maybe you accidently switch those usernames during installation (kohaadmin and www-data)? -- alen Joe Allen wrote:
Yup I followed the instructions perfectly myself and I am sure Derek did as well. I can connect to MySql as kohaadmin with the password I selected during installation just fine. The problem is the user www-data is NOT given a password for MySql and it is trying to connect without one and is being refused.
I have attempted this install on Debian Sarge and Mandriva 2006. Both systems end up with the same error. I have Koha currently installed on Mandriva 2006 with MySql 4.1.12 and Apache 2.0.54.
Hi! You should check (change) your database setup and credentials in "koha.conf" and then try to connect from the command line with: # mysql -u username -p database_name regards -- alen Morgan, John D. wrote:
access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411
Marilen Corciovei wrote:
I did not had similar problems but seems a lot like a mysql configuration problem. Can you connect to the database using the mysql shell? Did you properly configured the mysql password for user www-data in koha?
Len
On Thu, 2006-04-20 at 12:49 +0200, Joe Allen wrote:
I have the very same issue. I'm trying to resolve it now. When I have it fixed I'll forward you my solution. and please if you get it resolved before me please give me your solution!!
Thank you, Joe Allen www.viktoriastift.de <http://www.viktoriastift.de>
On 4/20/06, *Morgan, John D.* <jmorgan@admin.fsu.edu <mailto:jmorgan@admin.fsu.edu>> wrote:
I have finally reached the point where I am trying to load up the = hompage for Koha. I followed the instructions for installing Koha on = Debian (sarge). After going to http://myip:8080 it looks like my Koha = is going to load then I get an Internal Server Error. When checking the = apache2/error.log I read:
access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411
Any help would be greatly appreciated.
Thanks, Derek
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------------------------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
If it does not work try looking here: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html For adding/modifying users. On Thu, 2006-04-20 at 13:11 +0200, alen vodopijevec wrote:
Hi!
You should check (change) your database setup and credentials in "koha.conf" and then try to connect from the command line with: # mysql -u username -p database_name
regards
database=Koha hostname=localhost user=kohaadmin pass=********** intranetdir=/usr/local/koha/intranet opacdir=/usr/local/koha/opac kohalogdir=/usr/local/koha/log kohaversion=2.2.5 httpduser=apache intrahtdocs=/usr/local/koha/intranet/htdocs/intranet-tmpl opachtdocs=/usr/local/koha/opac/htdocs/opac-tmpl It's not the Koha database user that's the problem. kohaadmin is the default MySql user and it connects just fine. On 4/20/06, Marilen Corciovei <marilen.corciovei@nemesisit.ro> wrote:
If it does not work try looking here: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
For adding/modifying users.
On Thu, 2006-04-20 at 13:11 +0200, alen vodopijevec wrote:
Hi!
You should check (change) your database setup and credentials in "koha.conf" and then try to connect from the command line with: # mysql -u username -p database_name
regards
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Yes, probably the permissions are wrong. In addition you can check other permissions under koha installation directory. For mysql connect you should add -p switch to prompt for password -- alen Joe Allen wrote:
database=Koha hostname=localhost user=kohaadmin pass=********** intranetdir=/usr/local/koha/intranet opacdir=/usr/local/koha/opac kohalogdir=/usr/local/koha/log kohaversion=2.2.5 httpduser=apache intrahtdocs=/usr/local/koha/intranet/htdocs/intranet-tmpl opachtdocs=/usr/local/koha/opac/htdocs/opac-tmpl
It's not the Koha database user that's the problem. kohaadmin is the default MySql user and it connects just fine. On 4/20/06, *Marilen Corciovei* < marilen.corciovei@nemesisit.ro <mailto:marilen.corciovei@nemesisit.ro>> wrote:
If it does not work try looking here: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
For adding/modifying users.
On Thu, 2006-04-20 at 13:11 +0200, alen vodopijevec wrote:
Hi!
You should check (change) your database setup and credentials in "koha.conf" and then try to connect from the command line with:
# mysql -u username -p database_name
regards
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
This link was very helpful in resetting the root password http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html now i can at least connect into mysql as root. Thanks, Derek ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of alen vodopijevec Sent: Thu 4/20/2006 7:45 AM To: Koha@lists.katipo.co.nz Subject: Re: [Koha] internal error Yes, probably the permissions are wrong. In addition you can check other permissions under koha installation directory. For mysql connect you should add -p switch to prompt for password -- alen Joe Allen wrote:
database=Koha hostname=localhost user=kohaadmin pass=********** intranetdir=/usr/local/koha/intranet opacdir=/usr/local/koha/opac kohalogdir=/usr/local/koha/log kohaversion=2.2.5 httpduser=apache intrahtdocs=/usr/local/koha/intranet/htdocs/intranet-tmpl opachtdocs=/usr/local/koha/opac/htdocs/opac-tmpl
It's not the Koha database user that's the problem. kohaadmin is the default MySql user and it connects just fine. On 4/20/06, *Marilen Corciovei* < marilen.corciovei@nemesisit.ro <mailto:marilen.corciovei@nemesisit.ro>> wrote:
If it does not work try looking here: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
For adding/modifying users.
On Thu, 2006-04-20 at 13:11 +0200, alen vodopijevec wrote:
Hi!
You should check (change) your database setup and credentials in "koha.conf" and then try to connect from the command line with:
# mysql -u username -p database_name
regards
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hello, I think I have the myself permissions figured out. I got in to the mysql> as root, but now when I do SHOW DATABASES or TABLES is doesn't list any. I think I may have wiped out my Koha tables, or DB that were created during the install. Is there a to reinstall Koha? Thanks, Derek
Hello, It has be a long couple of days of being a new learner for mysql, apache and koha. I discovered my own error of not putting a semi-colon at the end of mysql commands. Wheeww... the tables are still there :-) Here is a good ref for mysql: http://www.aboutdebian.com/database.htm ________________________________ From: koha-bounces@lists.katipo.co.nz on behalf of Morgan, John D. Sent: Thu 4/20/2006 8:15 AM To: Koha@lists.katipo.co.nz Subject: [Koha] reinstal of koha (atleast mysql part of it) Hello, I think I have the myself permissions figured out. I got in to the mysql> as root, but now when I do SHOW DATABASES or TABLES is doesn't list any. I think I may have wiped out my Koha tables, or DB that were created during the install. Is there a to reinstall Koha? Thanks, Derek _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hello, Thanks for all of the good response thus far. I am thinking also it is a mysql security issue. When I try: mysql -u root mysql I get Error 1045 Access denied...'root'@'localhost' (using password: No). I am trying to read through the mysql docs to figure it out. I will keep you posted. Thanks, Derek ________________________________ From: Marilen Corciovei [mailto:marilen.corciovei@nemesisit.ro] Sent: Thu 4/20/2006 6:54 AM To: Joe Allen Cc: Morgan, John D.; Koha@lists.katipo.co.nz Subject: Re: [Koha] internal error I did not had similar problems but seems a lot like a mysql configuration problem. Can you connect to the database using the mysql shell? Did you properly configured the mysql password for user www-data in koha? Len On Thu, 2006-04-20 at 12:49 +0200, Joe Allen wrote: I have the very same issue. I'm trying to resolve it now. When I have it fixed I'll forward you my solution. and please if you get it resolved before me please give me your solution!! Thank you, Joe Allen www.viktoriastift.de On 4/20/06, Morgan, John D. <jmorgan@admin.fsu.edu> wrote: I have finally reached the point where I am trying to load up the = hompage for Koha. I followed the instructions for installing Koha on = Debian (sarge). After going to http://myip:8080 it looks like my Koha = is going to load then I get an Internal Server Error. When checking the = apache2/error.log I read: access denied for user 'www-data'@'localhost' (using password: NO) at = /user/local/koha/intranet/modules/c4/context.pm line 411 Any help would be greatly appreciated. Thanks, Derek _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (5)
-
alen vodopijevec -
Joe Allen -
Marilen Corciovei -
MJ Ray -
Morgan, John D.