Learning with Texts: a free, open-source alternative to LingQ (for any language) | Page 2 | Resources for non-spoken aspects of the language | Forum

Learning with Texts: a free, open-source alternative to LingQ (for any language) | Page 2 | Resources for non-spoken aspects of the language | Forum

Benny
A A A

Please consider registering
guest

Log In Register

Register | Lost password?
Advanced Search

— Forum Scope —

  

— Match —

   

— Forum Options —

    

Minimum search word length is 3 characters - maximum search word length is 84 characters

Topic RSS Related Topics
Learning with Texts: a free, open-source alternative to LingQ (for any language)
August 8, 2011
20:25
Chrystal G.
Las Vegas, NV USA

Member
Forum Posts: 192
$0
Member Since:
July 19, 2011
Offline
21

OMG Benny, that would be awesome! I'd have to learn a new language to even understand those installation steps...haha! If you guys can work something out, I'd absolutely give it a whirl! (like I need an excuse to hang around the website) this sounds like an interesting program, but I gave up trying to decipher that set up goop.

Native: English Learning: German (active), Polish (active, secondary)
August 8, 2011
21:05
LWT_Project

Member
Forum Posts: 85
$0
Member Since:
August 3, 2011
Offline

Benny said:

@lwt … If you could work with me on this, let me know! I'd happily manage users or outsource to have others help me manage them, as long as the basic technical interface is operational. The community here would have the technical know-how to help people get used to the system.

This could remove the complicated installation step and have it work on mobile interfaces for everyone, if you think adding in a password protected sign-up form per user could be a simple step.

Let me know if this is technically feasible. ….

Hi Benny, as I wrote in earlier posts:

1. IMHO, the system must be designed completely different if it should run with multiple users (problems of text caching, performance, etc.).

2. I am sorry but due to several reasons I am not able to implement or to help implementing such a multi user / external web server solution. As the software is in the Public Domain, everybody on the planet may do with it what she/he likes to do with this software, even a commercial product. 

I hope you understand this.

J. Pierre / LWT Project

I DON'T POST HERE ANYMORE. -- If you have problems with Benny's version of LWT: Search or ask here. -- If you have problems with the Original version of LWT: Go to the LWT help forum. -- Thank you.
August 8, 2011
21:15
Benny
worldwide book tour (Ireland until May 22)

moderator
Forum Posts: 485
$9080
Member Since:
June 1, 2009
Offline
23

OK fair enough J. Pierre wink Thanks for putting all the work into creating this btw!

If anyone else (edoreld?) reading this thinks they could help me with this, let me know! I could put you in touch with my web designer who would create the interface etc., but you'd have to have the know-how to implement most of the interface in a multi-user format.

But if it really is too much work, then we'll leave it as is. When I present it on the blog in a post or guest post I'll have to use my usual Irish charms to try to convince people to go through the (actually very simple) 5 minute installation procedure, as it will be off-putting for non-technical users who just want one-click installation.

It's a pity I can't host it in some way, or provide the tools to let people host it on my server, as I'd really like to promote a system that works easily on tablets / on the go, and not everyone will be in the position to set something up on a server themselves.

Speaks: English Spanish Italian Portuguese German Irish French Esperanto Mandarin (Taiwan) Nederlands American Sign Language
August 8, 2011
21:54
edoreld

Member
Forum Posts: 18
$0
Member Since:
July 5, 2011
Offline

I got the passion, but unfortunately I haven't got the necessary skills yet. I'm studying PHP & MySql currently along with my languages, so eventually I'll be able to modify LWT at my leisure ^_^. However, it might take a few months… as Jean Pierre said, the project is open-source, so everyone can work on it.

 

I hope from the bottom of my heart that you can bring your idea to realization, whether is from me in the future or from someone else who's got the skills already. I just love working with LWT, and want as many people as possible to know about it!

Language blog: The Fine Apps Knows:       Learning:  
August 8, 2011
23:40
Marcoru

Member
Forum Posts: 16
$0
Member Since:
July 5, 2011
Offline
25

Hey, I've just found the thread! Great to hear there is an alternative to LingQ ! Although I also just recently - maybe a weak ago - registered on LingQ I already feel it's not the platform I want to use. There a several reasons for this.....

(but enough about that).

 

I've just successfully started LWT an my Mac using Mamp Pro! As I'm learning Russian my next task will be to add Russian as a language. I'll get back with my experiences soon ... 

Native  (TOEFL 2008 – score 95)  (ТРКИ 2010 – B2) Current Mission:  (REACHING C1 LEVEL BY THE END OF OCTOBER)  (START ALL OVER AGAIN)
August 8, 2011
23:58
edoreld

Member
Forum Posts: 18
$0
Member Since:
July 5, 2011
Offline
26

Welcome to LWT!

 

Make sure the check the documentation (especially the "Language setup"), for useful information on how to setup Russian :).

Language blog: The Fine Apps Knows:       Learning:  
August 9, 2011
00:27
Marcoru

Member
Forum Posts: 16
$0
Member Since:
July 5, 2011
Offline
27

edoreld said:

Welcome to LWT!

 

Make sure the check the documentation (especially the "Language setup"), for useful information on how to setup Russian :).

Hi, thank you ! It's just amazing ! I've set up Russian and the first text as well already working on it. I'll never even look at LingQ again. More of my experiences to come the other day. 

Native  (TOEFL 2008 – score 95)  (ТРКИ 2010 – B2) Current Mission:  (REACHING C1 LEVEL BY THE END OF OCTOBER)  (START ALL OVER AGAIN)
August 9, 2011
04:51
duckshirt
Koblenz, DE

Member
Forum Posts: 90
$0
Member Since:
June 28, 2011
Offline

edoreld said:

I got the passion, but unfortunately I haven't got the necessary skills yet. I'm studying PHP & MySql currently along with my languages, so eventually I'll be able to modify LWT at my leisure ^_^. However, it might take a few months… as Jean Pierre said, the project is open-source, so everyone can work on it.

 

I hope from the bottom of my heart that you can bring your idea to realization, whether is from me in the future or from someone else who's got the skills already. I just love working with LWT, and want as many people as possible to know about it!

If you have any PHP/MySQL questions I can certainly help…cool

 

I've been playing with this myself tonight to try and get multiple users to work on one installation of the software.  It's fairly straightforward, if you're wondering; so far my strategy has been:

1.  Find every single SQL call to the database and add on a prefix to the table name, i.e. "select * from langs" becomes "select * from " . $tablePrefix . "langs"

2.  Define $tablePrefix in a script included from every other script based on which user it's serving (so if user 'ed' is using it, $tablePrefix is 'ed_', thus ed has his own 'ed_langs', 'ed_texts', etc… tables)

3.  Modify the dbinstall.sql script so that it runs automatically (from a PHP script) and adds a tablePrefix; ideally it executes only when a new user is created

4.  Create some kind of registration and login page to save / authenticate user accounts

I'm mid-way through step 3 on here, but I'm still new to the software and I never used LingQ so I won't know for sure if everything is working the way it's supposed to in the end.

I can see why LWT says it's not "optimized" for this performance-wise but it's not a big deal, and there are a couple more security things to fix (some "unsanitized" SQL calls), but it looks doable at least…

Native: English Conversational: Spanish Dutch Basic (on hold): French

Currently learning: German (mission thread) My German Video Blog!

August 9, 2011
11:38
edoreld

Member
Forum Posts: 18
$0
Member Since:
July 5, 2011
Offline
29

Even at my level I can see how those steps make a lot of sense! Keep us posted on your progress! :)

Language blog: The Fine Apps Knows:       Learning:  
August 9, 2011
20:34
Benny
worldwide book tour (Ireland until May 22)

moderator
Forum Posts: 485
$9080
Member Since:
June 1, 2009
Offline
30

Yes, definitely keep us up to date! Unfortunately I never learned PHP (just some C++ in college), so I don't follow so well, but if you think this is something I can implement on Fi3M when you have something functional yourself I'd love to put you in touch with my web designer if you'd like to contribute to making it run here :)

One option for saving the registration step is to merge it with Wordpress on this site, and let people use their login and password details for the forum, but if that's too complicated we could make it a separate set-up with separate database of users.

Thanks for putting the time into this!! laugh

Speaks: English Spanish Italian Portuguese German Irish French Esperanto Mandarin (Taiwan) Nederlands American Sign Language
August 9, 2011
23:51
duckshirt
Koblenz, DE

Member
Forum Posts: 90
$0
Member Since:
June 28, 2011
Offline

I have a question about your server (if you don't know your web designer probably does) – do you have complete access to MySQL to create unlimited MySQL databases and users from MySQL itself?  One way to check that out is to log into phpMyAdmin (I am fairly certain DreamHost has a link to it or something wherever you log into it there) and see if there's a "permissions" tab on the main screen, and/or go to the "SQL" tab and type "CREATE DATABASE sometest;" and see if it lets you.

 

It's very common for WebHosts to limit the number of databases you can create, and to make it so you can only do so from their own site.  For example, on my small personal site, I can only create new databases from a special form on the hosting provider's site, but on my own computer (with XAMPP) I can do all of this from within phpMyAdmin.  I assume this is because when you're on a shared server they can't give you access to the root account, but I know you recently got a dedicated server now so there is hope.

 

The reason I asked is because it would be much simpler to do it this way than I originally thought – every user could have their own small database and MySQL user, which would be handled automatically by the whole login/registration process.  This way it would require hardly any modification to the LWT source code – just change the database it's using and everything else is the same, which would be handy for when LWT updates.

 

Using the same forum usernames is also a good idea… I can look into how those are stored in SimplePress and stuff.  So yeah I'd be happy work on it; whatever I figure out I can send over to others to test it first and make sure everything still works correctly.

Native: English Conversational: Spanish Dutch Basic (on hold): French

Currently learning: German (mission thread) My German Video Blog!

August 10, 2011
02:27
Benny
worldwide book tour (Ireland until May 22)

moderator
Forum Posts: 485
$9080
Member Since:
June 1, 2009
Offline
32

Simplepress is directly connected to Wordpress, so all Fi3M forum users are actually registered Wordpress users of my website that are restricted to not be able to post on the blog or log into my Wordpress dashboard.

Here's a screenshot of my php screen. I could ask my host (my web designer wouldn't know) about the unlimited databases issue, although that sounds dreadfully complicated for assigning permissions and setting it up each time? Perhaps you have a quick way around it though :)

I especially like the idea of being able to upgrade it seemlessly!

As you can see here, I didn't find a permissions tab... I did see an option back in my dashboard for adding new databases, which would obviously restrict things too much.

This wiki: http://wiki.dreamhost.com/MySQL may provide details of how Dreamhost work and if we can get around this. If I know what to ask them, I can get in touch with support to see what my options are!

 

Update: I tried your second proposal and tried to create a database in the SQL tab and it returned "#1044 - Access denied for user 'irishpolyglot'@'64.90.32.0/255.255.224.0' to database 'sometest'" :( I hope this isn't too big a brick wall!

Speaks: English Spanish Italian Portuguese German Irish French Esperanto Mandarin (Taiwan) Nederlands American Sign Language
August 12, 2011
22:39
Michel1020

Member
Forum Posts: 10
$0
Member Since:
August 12, 2011
Offline

Hi every one,

 

I put one version of LWT (1.0.0) online so that you can test it without any installation.

 

This online version is not for learning because anybody could delete or modified your data there.

If you want you can get the same kind of site with a private login and password and use it to learn. 

 

The procedure to have your own online lwt is as follow

 

1 open an account with a free web hosting that also run php and mysql.

2 send your login password etc to my email

3 I make the site for you and for free.

4 you change your password

5 you are ready.

 

If interested mp me here or on how to learn any language

 

By the way I could also visite you to install it on your computer (windows only)

for free if you are living in Brussels or for a small price paying my possible travel charges.

 

http://trabulo.net16.net

login=test password=test

August 13, 2011
01:04
Benny
worldwide book tour (Ireland until May 22)

moderator
Forum Posts: 485
$9080
Member Since:
June 1, 2009
Offline
34

@Michel Thanks, but you'd have to recommend sites with php&mysql that are free. Have any ideas? Also, the email option is a delayed reaction, that I'll try to make with an automated system, but if I can't do it it's great to see you are volunteering to help!

@duckshirt I contacted Dreamhost to ask about making an unlimited set-up. They replied to say

"This definitely will not be possible using our existing system, but if you'd like, you can setup your own custom MySQL on your machine (which would not be linked to the panel, would not have backups  made by us and would not be supported by us in anyway, and then set that up however you'd like."

Any ideas how I'd set this up on the machine to run separately?

Speaks: English Spanish Italian Portuguese German Irish French Esperanto Mandarin (Taiwan) Nederlands American Sign Language
August 13, 2011
06:22
duckshirt
Koblenz, DE

Member
Forum Posts: 90
$0
Member Since:
June 28, 2011
Offline

Benny said:

@duckshirt I contacted Dreamhost to ask about making an unlimited set-up. They replied to say

"This definitely will not be possible using our existing system, but if you'd like, you can setup your own custom MySQL on your machine (which would not be linked to the panel, would not have backups  made by us and would not be supported by us in anyway, and then set that up however you'd like."

Any ideas how I'd set this up on the machine to run separately?

Well, this won't be necessary since I have a work-around in place, but setting up your own custom MySQL would involve just installing MySQL itself on your server – I've never done this myself but I think you would just download MySQL for Linux (it's open source of course), upload it to the server, and then do the install steps from the command line remotely (do they give you SSH access to the server?).  Since you're a Linux user you may be plenty familiar with that already…cool

After that you would also want to set up a separate PhpMyAdmin, on some protected directory on your site, which you could use to create/control the databases on that server from the Web.  Setting up that would probably be similar to setting up WordPress, I think – just uploading the files and modifying one of them to give it your MySQL info.

Anyways, like I said, I'll still do this by my original strategy with just one database – The advantage of doing it this way would be that there would be almost no modification to the LWT software, only additional files, so when he updates his software there will be nothing to change (although my modifications are not that complex).  It would also be guaranteed very secure, because even if there are some security holes in the software, the worst that could possibly happen is the user would mess up his own database.

I've been looking at how to log in with WordPress, then I'll just have to modify the dbinstall.sql thing, so hopefully I'll have something ready to test soon.  I'll be on a road-trip with my family this week, though, so I might not be on a lot… EDIT: Figured the WordPress user thing out, that was actually quite simple!

Native: English Conversational: Spanish Dutch Basic (on hold): French

Currently learning: German (mission thread) My German Video Blog!

August 13, 2011
13:46
Benny
worldwide book tour (Ireland until May 22)

moderator
Forum Posts: 485
$9080
Member Since:
June 1, 2009
Offline
36

No worries - whenever you're online with time to look at it will be fine! If we have something functional some time in September it would be great, and I'll announce it on the blog with bells and whistles, after a test period just with forum users. (And use it myself to read and practise my next language, which of course is not covered by LingQ's tiny amount of languages)

Glad to see you've got a lot of ideas though and able to integrate it with Wordpress users! That really would be perfect, as people will only need to log in once, and I can even look into adding other features in future all with the same log-in.

If we can do it with one database that would be great! Test away and let me know when you have something functional that I can apply myself - I'll be sure to give you full credit for configuring it when I apply it on the site.

Enjoy the road trip!! :)

Speaks: English Spanish Italian Portuguese German Irish French Esperanto Mandarin (Taiwan) Nederlands American Sign Language
August 13, 2011
13:59
anno
Middle East

moderator
Forum Posts: 205
$0
Member Since:
July 17, 2011
Offline
37

I definitely would love to test anything! I can't wait till it's ready to be used.smile

Speaks:    Learning  Hebrew Learning Blog   ||   Korean Learning Blog
"The key to success is making a million mistakes. . now let's make as many as fast as we can!" Note: Please contact with email -- hangugeohakseng[at]gmail[dot]com -- not with PMs. Thank you!^^
August 13, 2011
18:09
Michel1020

Member
Forum Posts: 10
$0
Member Since:
August 12, 2011
Offline
38

Benny if you want a free web host - search the web.

I prefer one without forced ads because these ads could trouble the display of LWT.

 

http://trabulo.net16.net is on http://www.000webhost.com/  there are others.

August 14, 2011
13:20
LWT_Project

Member
Forum Posts: 85
$0
Member Since:
August 3, 2011
Offline
39

Added a new section in the LWT info/help:

How to install LWT at a (free) Webhoster

 

cool

I DON'T POST HERE ANYMORE. -- If you have problems with Benny's version of LWT: Search or ask here. -- If you have problems with the Original version of LWT: Go to the LWT help forum. -- Thank you.
August 14, 2011
17:36
Benny
worldwide book tour (Ireland until May 22)

moderator
Forum Posts: 485
$9080
Member Since:
June 1, 2009
Offline
40

Cool, thanks again for the addition on the tutorial! I'll be talking with duckshirt about installing it here with the goal of removing as many steps as possible to the set-up process (ideally actually having no set-up at all and integrating it with the forum login and simply going to fi3m.com/lwt or something along those lines). Hopefully it's technically feasible.

But in the mean time, anyone else curious should use it - install on your computer (as shown in the video) or on a free server (as explained just above). I'm curious to see people's feedback before I start getting deep into using it myself in a few weeks.

The reason I'd personally make it online rather than a local installation is to access it on the go from my Android smartphone or iPad, as well as. I look forward to using it! But I'll be waiting to use it on fi3m myself if I can!

Keep up the good work everyone! smile

Speaks: English Spanish Italian Portuguese German Irish French Esperanto Mandarin (Taiwan) Nederlands American Sign Language
Forum Timezone: America/New_York

Most Users Ever Online: wp_m8bqz1_sferrorlog

Currently Online: 123SpanishTutor
56 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Stephanie S: 742

Kevinpost: 499

Randybvain: 450

this_just_in: 328

Alasdair: 304

sipes23: 260

Member Stats:

Guest Posters: 9

Members: 62863

Moderators: 2

Admins: 5

Forum Stats:

Groups: 5

Forums: 16

Topics: 4905

Posts: 24828

Newest Members: ichissaque, samanco, princenathan20, Rafik, mmrandall, LordOfApocalypse

Moderators: Lingo: 663, anno: 205

Administrators: Benny: 485, balint: 0, tweaky: 0, AlexW: 0, The Duke: 0