mirror of
https://github.com/JLiscom/OpenNote.git
synced 2026-04-27 09:15:49 +03:00
[GH-ISSUE #116] can't register after installation #102
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#102
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 @jniggemann on GitHub (Jan 19, 2015).
Original GitHub issue: https://github.com/JLiscom/OpenNote/issues/116
Hi, this looks exactly like the piece of software I was looking for.
I just installed OpenNote on RedHat with MySQL, but I can't register.
There's nothing in the error log, and the table 'users' is also empty, the error message 'Invalid credentials' is displayed.
Did I miss something?
@JLiscom commented on GitHub (Jan 19, 2015):
If you press f12 in your browser can you see what error is being thrown?
Normally this means the front end cannot communicate with the API.
@arktyk commented on GitHub (Feb 15, 2015):
@jniggemann Did you ever resolve this issue? I believe I might be having the same one, but was unsure and filed a separate bug, #119, if you were able to solve the problem, I would appreciate it if you could let me know how you did so. Thank you.
@jniggemann commented on GitHub (Feb 15, 2015):
@arktyk I never resolved this and worse, I can't debug this as there's nothing logged to the browsers console... I'd so like to try OpenNote, but I can't get it to run on any of the machines I tested with (RedHat, Bodhi, Debian).
@jniggemann commented on GitHub (Feb 15, 2015):
FWIW, this issue and #119 both seem to be duplicates of #115 ...
@TheOtterslider commented on GitHub (Mar 27, 2015):
I just downloaded and installed today. I think I'm having the same issue.
@JLiscom commented on GitHub (Mar 27, 2015):
@TheOtterslider Can you see if an error is being thrown.
What version of php are you using on what version of mysql
Do you have the case in-sensative option turned on?
@TheOtterslider commented on GitHub (Mar 30, 2015):
Error shown in the interface - invalid credentials (slides in from the lower right). Nothing else appears when I hit f12
Apache/2.2.15
PHP/5.6.6
Mysql 5.1.73
Nothing else shown in Apache error logs
@JLiscom commented on GitHub (Mar 30, 2015):
@TheOtterslider Do you have the case in-sensative option turned on?
https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
What operating system?
@TheOtterslider commented on GitHub (Mar 30, 2015):
Cent OS 6.6
I installed the default version/config from yum. How can I determine if the option for case sensitivity is set? I can't find anything online that says something like "run this command" or "check this file" I'm not a mysql admin so any pointers in that direction would be really helpful.
Edit to add: this isn't a new install of centos or mysql. I've had it running for a good 6 months and have 3 other things hosted using mysql.
@JLiscom commented on GitHub (Mar 30, 2015):
@TheOtterslider
Run
on your server
@TheOtterslider commented on GitHub (Apr 6, 2015):
mysql> SELECT @@GLOBAL.lower_case_table_names;
+---------------------------------+
| @@GLOBAL.lower_case_table_names |
+---------------------------------+
| 0 |
@JLiscom commented on GitHub (Apr 13, 2015):
@TheOtterslider
ya you have case sensative table names. Set that to a 1. It shouldn't break any of your existing apps.
@jniggemann commented on GitHub (May 10, 2015):
Why is this issue closed when there's no solution?
I still can't register and login on a fresh install when using sqlite (using Firefox, that is).
Further, the current download still has the issue I reported in #120...
@TheOtterslider commented on GitHub (May 20, 2015):
Just an update...I updated GLOBAL.lower_case_table_names to 1, bounced mysqld, verified the change, and am still having problems registering.
@JLiscom commented on GitHub (May 22, 2015):
@jniggemann @TheOtterslider,
In the next version mysql is optional.
@TheOtterslider try dropping the DB and rerun the install
@TheOtterslider commented on GitHub (May 22, 2015):
@hmrodrigues commented on GitHub (May 22, 2015):
I'm having the same problem, I can't register on my local instance but on the demo I can.
I'm using sqlite
My system:
Apache 2.4.12
PHP 5.6.9
Firefox 38.0.1
Chromium 43.0.2357.65
@JLiscom commented on GitHub (May 23, 2015):
@TheOtterslider Next version uses couchdb and pouchdb to enable offline access and data sync. At the moment, mysql is only used if you want to upload fles.
@JLiscom commented on GitHub (May 23, 2015):
@Hugao Are you on windows?
@hmrodrigues commented on GitHub (May 24, 2015):
@FoxUSA I'm on Arch Linux
@JLiscom commented on GitHub (May 24, 2015):
@Hugao have you pulled this fix
github.com/FoxUSA/OpenNote@c8916ea54a.Also when registering does it create a user in the mysql users table?
@hmrodrigues commented on GitHub (May 25, 2015):
@FoxUSA I'm using sqlite, and no user is created
The issue also happens on chromium
@JLiscom commented on GitHub (May 26, 2015):
@Hugao can you make sure the config.php points to the correct sqllite database
@hmrodrigues commented on GitHub (May 28, 2015):
@FoxUSA it points to the correct path, I double checked
@JLiscom commented on GitHub (May 28, 2015):
@Hugao You may want to download a copy of my working branch. I dont have a lot of documentation yet but the code is feature complete.
Basically you can use it at just an html5 app with manual backup and restore. Or you can install a CouchDB server and sync with it.
To install it, download from my working branch and run grunt build (Should auto do a npm install and bower install)
Only issues I am having is with file upload(Still requires a php based api).
As well as issues with offline apps using self signed ssl keys.
@b3nm0n commented on GitHub (May 29, 2015):
I have this same problem. Nothing I do changes this error. Ran Firebug and got the following:
POST http://localhost/OpenNote/Service/service.php/user/maint&maint 500 Internal Server Error 17ms
Looking further, I get
angular.min.js (line 78)
I am not a coder, I am a Sys Admin with some xtra skills. This is a local install on Fedora 21, fully updated..
@JLiscom commented on GitHub (Jun 1, 2015):
@b3nm0n In a browser window go to
http://localhost/OpenNote/Service/service.php/user/maint&maintwhat does the body say?@b3nm0n commented on GitHub (Jun 1, 2015):
I get the following:
Invalid username
However the username is in the database, it is spelt correctly, etc. I have tried to create a new user and get the same result.
Please let me know if it is something that I am doing wrong, or if this is something that is otherwise.
@JLiscom commented on GitHub (Jun 22, 2015):
See new version
@abalage commented on GitHub (Jun 26, 2015):
It does not look good. After upgrading to new version I cannot even see the login form.
On "#/settings/legacy/" I can register a user as many times I want (checked in mysql table users). I could import my legacy stuff but it is accessible to everyone.
@JLiscom commented on GitHub (Jul 1, 2015):
@abalage No its not. This is a html5 app. Its now cached locally on your browser. In chrome you can have multiple profiles which can hide your notes. To have your notebook visible you must first login and pull your notes down from a couchdb server. The old api's have been set to read only to allow you to convert them. You still need a username and password to retrieve your notes.
@abalage commented on GitHub (Jul 6, 2015):
I think I am missing something. I still have my notes in mysql table 'notes'.
What is it good for to leave them up to my browser's cache? I would like to access them from any other location.
In upgrade guide I see this.
In install guide.
Will I have a login form again if I follow the CouchDB install guides?
@JLiscom commented on GitHub (Jul 8, 2015):
@abalage Correct. Mysql is no longer supported**** and is going away. CouchDB makes it easier to allow offline note sync.
The notes are still in the mysql table notes because you have to migrate them.
**** Still used for file uploads at this time.