error during setup
by perclecom, Friday, March 15, 2013, 20:17 (3844 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 (3844 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 (3844 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 (3844 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 (3844 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 (3843 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 (3844 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 (3843 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 (3843 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