mirror of
https://github.com/JLiscom/OpenNote.git
synced 2026-04-25 16:25:49 +03:00
[GH-ISSUE #78] Logon after installation #72
Labels
No labels
bug
enhancement
pull-request
question
wontfix
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/OpenNote-JLiscom#72
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @benbeton on GitHub (Aug 12, 2014).
Original GitHub issue: https://github.com/JLiscom/OpenNote/issues/78
Hi,
I installed OpenNote yesterday the first time, but after configuring there is only the logon page, but I did'n know any username. Same when using the wizard or did the config manually. Tried with SQLite and my preferred mysql. There is no register button.
(I didn't have access to the Apache2 error.log)
any ideas?
@abalage commented on GitHub (Aug 12, 2014):
Make sure the .htaccess rules apply for Apache2. I had a similar problem and I had to apply the .htaccess rules in nginx to make it work.
@benbeton commented on GitHub (Aug 12, 2014):
which .htaccess rules do you mean? I didn't found anything open note specific in the docs
@abalage commented on GitHub (Aug 12, 2014):
I see one in /Service/.htaccess in my document root. It has some rewrite rules.
@benbeton commented on GitHub (Aug 12, 2014):
no .htaccess in my folder or in the git, what does it contain?
@abalage commented on GitHub (Aug 12, 2014):
I have downloaded the lastest release from the site and not installed it from git repo.
Anyway the content of the .htaccess is this.
#########################
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ service.php [QSA,L]
<Files "OpenNote.sqlite">
Order Allow,Deny
Deny from all
#########################
@JLiscom commented on GitHub (Aug 12, 2014):
@benbeton if you are on linux you may need to do a ls -al to see it. Some file explorers hide files with a . prefix.
Also with the current release not having a register button probably means the front end cannot connect to the service. There will be a message in the next release alerting you.
@JLiscom commented on GitHub (Aug 12, 2014):
@benbeton
It should be noted the issue I stated above should no keep you from using the app if it is configured correctly. The issue is just it will not tell you it is not configured correctly.
@benbeton commented on GitHub (Aug 13, 2014):
understood.
I tried to install it on my root server to have access to the apache error log, thats what I get:
File does not exist: /var/www/OpenNote/Service/config, referer: http://IP:ADDR/OpenNote/
I used v14.07
@JLiscom commented on GitHub (Aug 13, 2014):
Do you have multiple aliases in your Apache instance?
Does
/var/www/OpenNote/Service/config.phpexist?@JLiscom commented on GitHub (Sep 8, 2014):
@benbeton Can you provide me with you Apache information?
@benbeton commented on GitHub (Sep 8, 2014):
I tried the new release, but still the same error. But now I can a see a error message on the web interface: "Connection to Service failed"
Apache log says:
[Mon Sep 08 07:18:23 2014] [error] [client ] File does not exist: /var/www/virtual/note/Service/config/, referer: http://TLD/note/
There is no config folder, I tried to rename the config.php to "config" but still the same.
@JLiscom commented on GitHub (Sep 9, 2014):
@benbeton does the error give you what script was running?
@JLiscom commented on GitHub (Sep 9, 2014):
@benbeton Does
/var/www/virtual/note/Servicerepresent where your install on disk is located?@benbeton commented on GitHub (Sep 10, 2014):
@FoxUSA no, I haven't realized it. there are two more dirs in between.
I saw, that can be defined in line 113 the config.php, so I set the right path, but the error is still the same.
Seems that it is searching for the config dir, instead of die config.php file?!
@JLiscom commented on GitHub (Sep 12, 2014):
@benbeton the .htaccess file should map the
Service/configrequest to the service.php file. You should be ale to put in the full path toService/config(same path as to service.php just replace service.php with config) and you should get a result.Make sure you have .htaccess files enabled.
If you provide path I can double check to make sure they make sense.
@benbeton commented on GitHub (Sep 15, 2014):
seems that the documents root is not set correctly, where can I set this best?
maybe the browser can't reach the .htaccess
@JLiscom commented on GitHub (Sep 17, 2014):
@benbeton you have to allow .htaccess to be read by Apache. The stock configuration should work as long as the paths are set to the default(relative to each other)
https://help.ubuntu.com/community/EnablingUseOfApacheHtaccessFiles
@JLiscom commented on GitHub (Sep 26, 2014):
@benbeton Any update?
@benbeton commented on GitHub (Sep 29, 2014):
@FoxUSA unfortunately still no luck, seems that there is something wrong with the web server configuration, tried it from scratch again a few minutes ago.
@JLiscom commented on GitHub (Sep 29, 2014):
@benbeton Try changing https://github.com/FoxUSA/OpenNote/blob/Fox-Working/OpenNote/openNote/openNote.config.js#L24 to match this new commit.(Added
service.phpto url) In future versions I will no longer use a .htaccess file as it does not work in cases like this@benbeton commented on GitHub (Oct 1, 2014):
@FoxUSA that did the trick. Register Button is now available.
But I can't register. After typing in the 4th letter, it displays "error"
And if I click on register, it says "invalid credentials"
nothing in error.log
@JLiscom commented on GitHub (Oct 1, 2014):
@benbeton This probably means the credentials to connect to the DB are incorrect.
@benbeton commented on GitHub (Oct 2, 2014):
@FoxUSA yes, it was a typo in the pw. Now it is working! Thank you for your help!
@1337sup3rh4x0r commented on GitHub (Oct 16, 2014):
Hi there,
I think I am experiencing a similar problem. After installing opennote on nginx I only get a login button but no register button. Also after loading the page I get the error message "Connection to service failed" and the nginx log shows the message
2014/10/16 13:12:39 [error] 21400#0: *11 "/var/www_opennote/Service/service.php/config/index.html" is not found (20: Not a directory), client: 192.168.217.41, server: , request: "GET /Service/service.php/config/ HTTP/1.1", host: "192.168.217.201:444", referrer: "https://192.168.217.201:444/"
@JLiscom commented on GitHub (Oct 16, 2014):
@Killer1337 Please open a ticket it the above solution does not fix your issue.
@gmx99 commented on GitHub (Nov 1, 2014):
Hi,
first of all compliments to this great little peace of software. Unfortunately i can use only your demo.... :-( On my Debian Server with Apache2 and MySql i have the problem of "invalid credentials". Also inserting a user in DB does not help.
I gave the DB User all rights and grants. No matter.
Can't logon with the inserted user nor can register any other user. Can you help me please.
Thank you very much.
gmx99
@JLiscom commented on GitHub (Nov 3, 2014):
@gmx99
Sorry to hear you having trouble.
Did you run install.php or do it manually?
Try using this install guide https://github.com/FoxUSA/OpenNote/blob/master/Doc/Install.md
If you are flexible, try using the docker package. That will get you a quick start.
Also, make sure your using 14.07.02. There have been some fixes that may fix your issue.
@gmx99 commented on GitHub (Nov 3, 2014):
Thank you for your kind reply.
I tried more options (not with docker).
Running install.php i have problems on step 3 (making mysql DB?), no
reaction from the browser (Firefox)
Finally i did it manual, i am using 14.07.02. I was using exactly this
install guide.
Sorry, are there two Config.php's, one in /OpenNote/Service, and one in
/OpenNote/?
Create a MYSQL database named "OpenNote"
Download and extract OpenNote into a folder on your php web-server
called "OpenNote"
Open up the |Service/model/sql| folder and run |notebook.sql| in
your OpenNote database
Change the database connection settings inside of
|Service/Config.php| to match your db settings. These are stored in
the following lines of code in |/OpenNote/Config.php|:
$dbUserName = "notebook";
$dbPassword = "password";
$dbServer = "127.0.0.1";
$dbName = "notebook";
And is the exact command for the third point in manual installation
"mysql> OpenNote < notebook.sql;"?
And sorry, why the database name in the example above is not OpenNote,
but "notebook"?
My owner/group of /OpenNote/ and subdirectories is www-data:www-data. Is
that right?
I think it should be a problem with mysql and/or the database OpenNote.
Thanks a lot for your help and patience!
greets
Am 03.11.2014 um 18:53 schrieb FoxUSA:
@JLiscom commented on GitHub (Nov 3, 2014):
@gmx99 yes. There is a backend and frontend config. The frontend(
/OpenNote/openNote/config you do not have to worry about. The one you want to modify is in/OpenNote/service/Config.php@gmx99 commented on GitHub (Nov 4, 2014):
Sorry i have some other questions about the Manual
https://github.com/FoxUSA/OpenNote/blob/master/Doc/Install.md
Is the exact command for the third point in manual installation "mysql>
OpenNote < notebook.sql;"?
My owner/group of /OpenNote/ and subdirectories is www-data:www-data. Is
that right?
I think it should be a problem with mysql and/or the database OpenNote.
Thanks a lot for your help and patience!
greets
@JLiscom commented on GitHub (Nov 4, 2014):
@gmx99 can you confirm the tables were created in the database? The command I use when setting up environments is
mysql -u root OpenNote < /app/Service/model/sql/notebook.sqlwhere root is the user that has permission to run SQL DDL.@gmx99 commented on GitHub (Nov 5, 2014):
hi,
yes i confirm creation of the tables
folder
note
token
uploads
users
Thanks
Am 04.11.2014 um 17:06 schrieb FoxUSA:
@gmx99 commented on GitHub (Nov 5, 2014):
tried to create a new Database.
No solution: invalid credentials
Thanks
Am 04.11.2014 um 17:06 schrieb FoxUSA:
@gmx99 commented on GitHub (Nov 18, 2014):
Hi, sorry, but no more ideas?
What for information do you need about my config?
Thanks for any help
@JLiscom commented on GitHub (Nov 18, 2014):
@gmx99 More or less out of ideas. I have had some problems in the past if a user was set to be allowed from % instead of localhost in mysql. You may want to make sure you can use the terminal mysql client to connect with the user you are giving opennote to make sure you can run select statements against those tables.
@gmx99 commented on GitHub (Nov 20, 2014):
hi,
yes, my user is allowed from localhost in mysql.
And terminal mysql client connects normally with the user defined in Config.php.
Thank you for any help.
gmx99
@JLiscom commented on GitHub (Nov 20, 2014):
@gmx99 I cant really help you. This is a configuration issue in your environment. I recommend using the docker deployment.
@gmx99 commented on GitHub (Nov 20, 2014):
Hi,
my debian server is on jessie/testing. maybe apache 2.4 is the problem
Can you please send me your apache2 conf and virtualhost conf?
Thanks a lot!
bye
On 11/20/2014 03:59 PM, FoxUSA wrote: