error during setup

by perclecom, Friday, March 15, 2013, 20:17 (4114 days ago)

i wish to use mysql and have changed the config.ini file from sqlite to mysql

still no luck ,

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


--------------------------------------------------------------------------------

Apache/2.2.22 (Ubuntu) Server at rss.mydomain.com Port 80

error during setup

by MidSpeck, Friday, March 15, 2013, 20:34 (4114 days ago) @ perclecom

Does it seem to work without MySQL?
If so, you may be missing the PHP MySQL drivers.
apt-get install php5-mysql

Or you can look at /var/log/apache2/error.log for more information on why it is giving you an "Internal Server Error"

error during setup

by perclecom, Friday, March 15, 2013, 20:46 (4114 days ago) @ MidSpeck

i have the php-mql, and tail of apache2 log doesnt show anything issues

here is my config.ini

[globals]
db_type=mysql
db_file=data/sqlite/selfoss.db
db_host=localhost
db_database=selfoss
db_username=rss
db_password=password
db_port=3306
logger_level=ERROR
items_perpage=50
items_lifetime=30
base_url=
username=
password=
salt=lkjl1289
public=
rss_title=selfoss feed
rss_max_items=300
rss_mark_as_read=0
~
~
~
~

error during setup

by vince, Friday, March 15, 2013, 23:04 (4114 days ago) @ perclecom

As MidSpeck, you'll need to look in your apache error logs to see what's going on.

error during setup

by perclecom, Saturday, March 16, 2013, 04:20 (4113 days ago) @ vince

This is what i am getting in the logs

/var/www/rss/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration
/var/www/rss/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration
/var/www/rss/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration
/var/www/rss/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration
/var/www/rss/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration

error during setup

by MidSpeck, Saturday, March 16, 2013, 22:08 (4113 days ago) @ perclecom

/var/www/rss/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration

I believe perclecom already got this error figured out, but for those searching and finding this same problem, do

sudo a2enmod rewrite

Then restart Apache.

error during setup

by perclecom, Saturday, March 16, 2013, 04:45 (4113 days ago) @ perclecom

I was file able to get pass the rewrite error in the .htaccess file

now i have a new error


SQLSTATE[28000] [1045] Access denied for user 'rss'@'localhost' (using password: YES)
SQLSTATE[28000] [1045] Access denied for user 'rss'@'localhost' (using password: YES)
SQLSTATE[28000] [1045] Access denied for user 'rss'@'localhost' (using password: YES)
SQLSTATE[28000] [1045] Access denied for user 'rss'@'localhost' (using password: YES)

error during setup

by steved, Wales, UK, Saturday, March 16, 2013, 16:28 (4113 days ago) @ perclecom

SQLSTATE[28000] [1045] Access denied for user 'rss'@'localhost' (using password: YES)

This is a mysql error.

You might have the password wrong in config.ini or simply have not created the mysql DB

You can either use sqlite or create the database using the following commands to mySQL:

(For a DB called "selfoss" user "rss" password "secret")

create database selfoss;
create user 'rss'@'localhost' identified by 'secret';
grant all privileges on selfoss.* to 'rss'@'localhost';
flush privileges;

Note the last command - if you don't do that then you may not have access until mySQL is restarted.

error during setup

by perclecom, Sunday, March 17, 2013, 01:57 (4112 days ago) @ steved

Steved,

you were right

all i needed to do was "flush privileges" and everything is working,


also the other issues was i didn't have the rewrite mod enable in apache2 which was causing errors with the .htaccess file


Thanks alot

RSS Feed of thread
powered by my little forum