donky is currently certified at Apprentice level.

Name: Richard Tew
Member since: 2001-02-12 22:14:39
Last Login: N/A

FOAF RDF Share This

Homepage: http://www.nameless-sorrows.org

Notes:

There is little to be gained from reading this page. It is more a record of what I am currently working on that is unrelated to my work. If you wish to contact me, you may reach me at abolishmediocrity AT hotmail.com.

Recent blog entries by donky

Syndication: RSS 2.0

Aaaaaaargh. Yet again completely lost ability to log into MySQL - forgot password AGAIN!

Heres a good link on how to go about resetting the password.

For the next time..

1. Kill MySQL.
> ps aux | grep mysql // note the PID
> kill -9 [PID_HERE]
2. Start MySQL bypassing grant tables.
> mysqld -Sg
3. Change MySQL password for user root (below prompt is 
MySQL prompt)
> USE mysql;
> UPDATE user
> SET password = password("NEW_PWD_HERE")
> WHERE user = "root";
> flush privileges;
> exit;
4. Repeat step 1 and step 2.
5. Restart mysqld without -Sg flags to restart using grant 
tables (access
control system).
16 Apr 2001 (updated 16 Apr 2001 at 22:56 UTC) »

Got the session code mostly working. Main problem is clearing out cookies - can't for the life of me seem to get the browser to immediately delete the cookie. Best I can do is getting it cleared out when the browser closes.

Next comes fleshing out the login process. And the use of MySQL.

16 Apr 2001 (updated 16 Apr 2001 at 22:56 UTC) »

Back onto Whelkboard after a short evaluation period of Scoop. Has been decided to make it into something like Scoop - at least to a limited degree. Promised to do some work on it yet again - wonder if I will this time.

Went through the usual process of wondering why Apache was not working. Turned out to be the permissions on the directories - I had recursively set the group and user to the user who was doing the editing. I reset these to "nobody" and it all came right (as compared to munging the all users permissions). I also had to change the config file to reflect the settings on my machine. Also had to change the Apache conf file to reflect the correct document root.

Hopefully this will help me work out what is going wrong the next time.

Started rewrite of whelkboard. Notes:

MySQL:

  1. Setting the password for a database user

    Assigning a password to the user via
    UPDATE USER
    SET PASSWD = PASSWORD('password')
    WHERE USER='username'
    just didn't seem to assign a properly encrypted password. Eventually discovered (when logged in as the root user)
    SET PASSWORD FOR username = PASSWORD('password');
  2. Using MySQLdb

    db.fetchall()
    returns a tuple containing a tuple for each row. e.g.
    ((1L, 'fudge'))
    

Next step is to build in simple user support and then to hook that into cookies. Would like to run all the python CGI in the same runtime so that I can keep a resident shared object but have no idea how to go about it at this stage.

Why are my spaceships not turning?

Learning Icelandic is very hard. Its funny to find that English is such an easy language to learn comparatively.

Not enough time to write something similar to Scoop in Python or work on my MUD...

6 older entries...

 

Others have certified donky as follows:

  • mobius certified donky as Apprentice
  • suso certified donky as Apprentice
  • criswell certified donky as Apprentice

[ Certification disabled because you're not logged in. ]

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!

X
Share this page