Go to advanced search

by sim_tcr
Wed Apr 24, 2013 6:26 am
Forum: General discussion
Topic: Use raspberry over internet.
Replies: 3
Views: 980

Re: Use raspberry over internet.

Noip install and configuration.

http://raspisimon.no-ip.org/noip.php
by sim_tcr
Fri Apr 19, 2013 7:50 am
Forum: General discussion
Topic: How to reduce display quality of VNC for faster access?
Replies: 5
Views: 4728

Re: How to reduce display quality of VNC for faster access?

thank you all.

Code: Select all

vncserver -geometry 800x600 -depth 8:1
made some difference.
by sim_tcr
Tue Apr 16, 2013 12:31 pm
Forum: General discussion
Topic: How to reduce display quality of VNC for faster access?
Replies: 5
Views: 4728

How to reduce display quality of VNC for faster access?

Hello, I have two pi's and on the remote pi I have tightvncserver installed. I use my second pi to access first pi's desktop over internet via vnc. It appears to very very slow. I was wondering if there are any ways to reduce the display quality to make the the vnc work faster over internet. On the ...
by sim_tcr
Sun Apr 14, 2013 4:28 pm
Forum: General discussion
Topic: 12V 7.2Ah lead acid battery charging question.
Replies: 17
Views: 11425

Re: 12V 7.2Ah lead acid battery charging question.

One point that no one else has mentioned... OP said the output of his DC-DC voltage regulator is set to 5.4v. That's a bit too high to be a good idea. The Pi is supposed to get 5v+/- 0.25v. Now, you may be seeing a drop to 5.25v if you're using a low quality USB lead, but you can't rely on that. Th...
by sim_tcr
Sun Apr 14, 2013 4:24 am
Forum: General discussion
Topic: 12V 7.2Ah lead acid battery charging question.
Replies: 17
Views: 11425

Re: 12V 7.2Ah lead acid battery charging question.

First two days I left the pi running and battery charging at the sametime. Next day, I switched the main off and left the pi running. After 2 days pi died. When checked battery voltage, it was below 5 volts. I tried charging the battery back using the UPS. Its been more than 3 weeks now, still charg...
by sim_tcr
Tue Apr 09, 2013 10:09 am
Forum: General discussion
Topic: What is the ideal Raspberry Pi CPU temperature range?
Replies: 55
Views: 148538

What is the ideal Raspberry Pi CPU temperature range?

Hello, I live in Bangalore, India. Where the current temperature is 33c. And my Pi runs at 60c. (it runs 24/7). Temperature may vary 1 or 2 degree above/below 60c occasionally. Is this a safe temperature to operate? Sometimes after 6 or 7 days pi automatically reboots. I don't know if its because of...
by sim_tcr
Sat Apr 06, 2013 4:34 am
Forum: General discussion
Topic: 3TB GPT NTFS formatted drive share
Replies: 15
Views: 17661

Re: 3TB GPT NTFS formatted drive share

try using ntfs-3g program.

Code: Select all

sudo apt-get install ntfs-3g

Code: Select all

mkdir /mnt/3tb

Code: Select all

sudo ntfs-3g /dev/sda1 /mnt/3tb
by sim_tcr
Fri Apr 05, 2013 5:19 pm
Forum: General discussion
Topic: How to add mp3 and mp4 player to right click menu on Raspbia
Replies: 0
Views: 685

How to add mp3 and mp4 player to right click menu on Raspbia

I am running raspbian wheezy.

How do I configure right click menu to show mp3 and mp4 player when I right click on a mp3 and mp4 file?

Or in other words, I want to play the mp3 and mp4 files on double click.

THanks,
Simon Mandy
by sim_tcr
Sat Mar 30, 2013 8:25 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Here is what I did, INSERT INTO date SELECT date, COUNT(*) as Counter FROM info GROUP BY date order by date asc; But there is a problem, each time we run it, records will get duplicated. So I run first below and then above, DELETE FROM date; I scheduled it as cron to run every 5 minutes mysql --host...
by sim_tcr
Sat Mar 30, 2013 4:09 am
Forum: General discussion
Topic: Raspberry Pi automatically rebooted after 10 days.
Replies: 0
Views: 425

Raspberry Pi automatically rebooted after 10 days.

My webserver pi got rebooted automatically after 10 days. Os is wheezy. I live in India and my average CPU Temp is 60'C. And CPU Load is 15%. Here are the entries I found from syslog at the time of reboot. Mar 29 09:17:17 raspisimon kernel: imklog 5.8.11, log source = /proc/kmsg started. Mar 29 09:1...
by sim_tcr
Wed Mar 27, 2013 3:42 pm
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Replace the echo with an insert statement This is a very off the top of my head example, will need tweaking - it's been a while lol. while ($row = mysql_fetch_object($result)) { mysql_query('insert into newtable (date, hits) values ("'.$row->date.'","'.$row->Counter.'"'); } I tried below. No error,...
by sim_tcr
Wed Mar 27, 2013 2:54 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Do you want to insert each row from the old table into the new table as a row ? Or do you want the insert all the output from the first table into the second table as one row ? I want new table as below, Date Hits 2013/03/13 35 2013/03/14 22 2013/03/15 25 2013/03/16 18 2013/03/17 27 2013/03/18 23 2...
by sim_tcr
Tue Mar 26, 2013 4:49 pm
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Now that we have the data http://192.168.1.40/virtual_counter/view_new.php . I would like to insert this data in to another table named 'date' where I have two columns named 'date' and count' (it is for another purpose - to produce a google chart) I would like to set it as, run 'SELECT date, COUNT(*...
by sim_tcr
Tue Mar 26, 2013 3:11 pm
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Why don't you just a program called "webalizer" It does all that for you Let me know when you want graphs - I can show you that. http://vk4tec.no-ip.org/adsb_station/ - Andrew - Hello Andrew, I have set up Date vs hits per day here, http://raspisimon.no-ip.org/virtual_counter/view_new.php Now, I wo...
by sim_tcr
Tue Mar 26, 2013 1:11 pm
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Almost there. Formatting is not correct. Output on webpage comes as below, 2013/03/13352013/03/14222013/03/15252013/03/16182013/03/17272013/03/18232013/03/19412013/03/20272013/03/21232013/03/22232013/03/23182013/03/24372013/03/25392013/03/2634 Code used is below, <?php $result = mysql_query("SELECT...
by sim_tcr
Tue Mar 26, 2013 1:01 pm
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Almost there. Formatting is not correct. Output on webpage comes as below, 2013/03/13352013/03/14222013/03/15252013/03/16182013/03/17272013/03/18232013/03/19412013/03/20272013/03/21232013/03/22232013/03/23182013/03/24372013/03/25392013/03/2634 Code used is below, <?php $result = mysql_query("SELECT ...
by sim_tcr
Tue Mar 26, 2013 8:57 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Use Malakai's solution - while ($row = mysql_fetch_object($result)) { echo $row->date; echo $row->count; } ?> Just needed to update the array keys that it echoes out. There is a slight problem in that. malakai provided that code thinking that, there a column named 'count' in the table. But I don't ...
by sim_tcr
Tue Mar 26, 2013 2:37 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

Seems to me you could just do: select date, count(*) from table group by date order by date asc Then you could use the code that malakai provided above. Above query is perfect, out put is perfect, SELECT date, COUNT(*) FROM info GROUP BY date ORDER BY date ASC Out put is as below, 2013/03/21 5 2013...
by sim_tcr
Mon Mar 25, 2013 11:46 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

malakai wrote:From what I get those are correct but you want the dates as well.

If your Table has 3 fields COUNT, DATE, IP
My table does not have COUNT, just DATE and IP. That's why I had to use
SELECT COUNT(*) to produce the count.
So how would I do it?
by sim_tcr
Mon Mar 25, 2013 11:04 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Re: Display hits per day php-mysql question.

<?php mysql_connect("hostname", "user", "password"); mysql_select_db("mydb"); $result = mysql_query("select * from mytable"); while ($row = mysql_fetch_object($result)) { echo $row->user_id; echo $row->fullname; } mysql_free_result($result); ?> http://www.php.net/manual/en/function.mysql-fetch-obje...
by sim_tcr
Mon Mar 25, 2013 9:27 am
Forum: General discussion
Topic: Display hits per day php-mysql question.
Replies: 22
Views: 4021

Display hits per day php-mysql question.

Hello, I have a web page counter setup using php and mysql. It record the ip address and date visited on a table named 'info' under the heads 'ip_address' and 'date'. I would like to display the total hits on a day in below format in my web page, Date ----------- Hits 2013/03/21----- * 2013/03/22---...
by sim_tcr
Mon Mar 25, 2013 3:46 am
Forum: General discussion
Topic: Website am for showcasing raspberry pi projects
Replies: 3
Views: 955

Re: Website am for showcasing raspberry pi projects

I have demonstrated few in my website http://raspisimon.no-ip.org

The look and feel of the website is going to be changed in few days. Keep watching.
by sim_tcr
Fri Mar 22, 2013 4:37 am
Forum: General discussion
Topic: apache2-html5 video (mp4) support question
Replies: 1
Views: 1050

apache2-html5 video (mp4) support question

Hello, I am trying to embed and mp4 video using html5 and apache2. Below is the code. Video does not play when i launch it from IE10 or Chrome or Firefox. Is there any thing else to be configured in apache2? Errors I see in Firefox is "No Video with supported format and MIME type found". <!DOCTYPE H...

Go to advanced search