Inviting you to the 4th Quantum & I.T Convention

1 view
Skip to first unread message

Stephen Piana

unread,
Jan 9, 2011, 7:02:35 AM1/9/11
to Kagay-Anon Linux Users' Group (KLUG) Mailing List, ubunt...@googlegroups.com
What: Quantum and Information Technology Convention 2011
When: January 28-30, 2011
Where: Chali Beach Resort, Cugman, Cagayan de Oro City

more info here:
http://ciso-www.xu.edu.ph/qitc/ or http://qitc.xu.edu.ph/


--
Don't Mess With The TeNsAi!!!
Poster2.jpg

hard wyrd

unread,
Jan 9, 2011, 10:44:32 PM1/9/11
to ubunt...@googlegroups.com
"Database Error: Unable to connect to the database:Could not connect to MySQL " at http://qitc.xu.edu.ph/



--
You received this message because you are subscribed to the Google Groups "Cagayan de Oro Ubuntu Linux Users Group" group.
To post to this group, send email to Ubunt...@googlegroups.com.
To unsubscribe from this group, send email to Ubuntu-CDO+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/Ubuntu-CDO?hl=en.



--
-------------------------------------------------------------
"Penguin, penguin, and more penguin !"

www.madforubuntu.com
baudizm.blogsome.com

botp

unread,
Jan 9, 2011, 11:03:31 PM1/9/11
to ubunt...@googlegroups.com
On Mon, Jan 10, 2011 at 11:44 AM, hard wyrd <hard...@gmail.com> wrote:
> "Database Error: Unable to connect to the database:Could not connect to
> MySQL " at http://qitc.xu.edu.ph/
>

what part sa page hdwyrd ga error? di ko man makita

best regards -botp

Stephen Piana

unread,
Jan 10, 2011, 12:25:57 AM1/10/11
to ubunt...@googlegroups.com
yup dakog problema nang http://qitc.xu.edu.ph/ dugay ra kau pa ilin2x ana na problema mao kini na lng gamita inig access http://ciso-www.xu.edu.ph/qitc/

--
You received this message because you are subscribed to the Google Groups "Cagayan de Oro Ubuntu Linux Users Group" group.
To post to this group, send email to Ubunt...@googlegroups.com.
To unsubscribe from this group, send email to Ubuntu-CDO+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/Ubuntu-CDO?hl=en.

botp

unread,
Jan 10, 2011, 12:34:42 AM1/10/11
to ubunt...@googlegroups.com
On Mon, Jan 10, 2011 at 1:25 PM, Stephen Piana <stephe...@gmail.com> wrote:
> yup dakog problema nang http://qitc.xu.edu.ph/ dugay ra kau pa ilin2x ana na
> problema mao kini na lng gamita inig access http://ciso-www.xu.edu.ph/qitc/

my problem is i cannot see the problem ;-)

Stephen Piana

unread,
Jan 10, 2011, 1:03:47 AM1/10/11
to ubunt...@googlegroups.com
sa qitc.xu.edu.ph na link ga Database error dli ka connect sa mysql. :D


--
You received this message because you are subscribed to the Google Groups "Cagayan de Oro Ubuntu Linux Users Group" group.
To post to this group, send email to Ubunt...@googlegroups.com.
To unsubscribe from this group, send email to Ubuntu-CDO+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/Ubuntu-CDO?hl=en.

botp

unread,
Jan 10, 2011, 1:26:07 AM1/10/11
to ubunt...@googlegroups.com
On Mon, Jan 10, 2011 at 2:03 PM, Stephen Piana <stephe...@gmail.com> wrote:
> sa qitc.xu.edu.ph na link ga Database error dli ka connect sa mysql. :D

yes, stephen, the funny thing is that that link works on my pc here...
i've already set my client to no-cache...

best regards -botp

botp

unread,
Jan 10, 2011, 2:29:25 AM1/10/11
to ubunt...@googlegroups.com

now i'm more puzzled. digging thru the dns, it seems that qitc is just
a cname to ciso-www. if the hostname just resolves to the same server,
ip ie, then there should be no problem w regards to qitc if ciso-www
is working, no?

$ irb
+---------------------------------------------------------------------
| hello, botp
| this is the irb conf (find me at /disk2_2/home/botp/.irbrc)
| happy irb/rubying.
| you can now enter ruby commands
| type "quit" anytime to exit irb..
+---------------------------------------------------------------------
puts `dig qitc.xu.edu.ph`.each_line.select {|x| x !~ /^(;|$)/ }

qitc.xu.edu.ph. 591978 IN CNAME ciso-www.xu.edu.ph.
ciso-www.xu.edu.ph. 591978 IN A 202.84.119.212

#=> nil

best regards -botp

Jon Doblados

unread,
Jan 10, 2011, 3:17:16 AM1/10/11
to ubunt...@googlegroups.com
Hello Botp, Tensai, and everyone else. :)

On Mon, Jan 10, 2011 at 3:29 PM, botp <bot...@gmail.com> wrote:
On Mon, Jan 10, 2011 at 2:26 PM, botp <bot...@gmail.com> wrote:
> On Mon, Jan 10, 2011 at 2:03 PM, Stephen Piana <stephe...@gmail.com> wrote:
>> sa qitc.xu.edu.ph na link ga Database error dli ka connect sa mysql. :D
>
> yes, stephen, the funny thing is that that link works on my pc here...
> i've already set my client to no-cache...

now i'm more puzzled. digging thru the dns, it seems that qitc is just
a cname to ciso-www. if the hostname just resolves to the same server,
ip ie, then there should be no problem w regards to qitc if ciso-www
is working, no?

Yes that should be the case. It may be possible that the db connection scripts are using fqdn for the host param and the server does not resolve to internal IP (since it's trying to connect via public IP and ports aren't open from the outside).

Perhaps a change to "localhost" as host param in the scripts would help?

Gadugo jud akong ilong sa ruby dah. Hehe.

Kind regards,

Jon


$ irb
+---------------------------------------------------------------------
| hello, botp
| this is the irb conf (find me at /disk2_2/home/botp/.irbrc)
| happy irb/rubying.
| you can now enter ruby commands
| type "quit" anytime to exit irb..
+---------------------------------------------------------------------
puts `dig qitc.xu.edu.ph`.each_line.select {|x| x !~ /^(;|$)/ }

qitc.xu.edu.ph.         591978  IN      CNAME   ciso-www.xu.edu.ph.
ciso-www.xu.edu.ph.     591978  IN      A       202.84.119.212

#=> nil

best regards -botp

botp

unread,
Jan 12, 2011, 12:27:30 AM1/12/11
to ubunt...@googlegroups.com
On Mon, Jan 10, 2011 at 4:17 PM, Jon Doblados <jon.do...@gmail.com> wrote:
> Yes that should be the case. It may be possible that the db connection
> scripts are using fqdn for the host param and the server does not resolve to
> internal IP (since it's trying to connect via public IP and ports aren't
> open from the outside). Perhaps a change to "localhost" as host param in the scripts would help?

yes, i'd like to help troubleshoot but "unfortunately", i do not get
any error msg that i can tract :-)

> Gadugo jud akong ilong sa ruby dah. Hehe.

warning: ruby session ahead :-))
as much as possible, i'd like to run scripts using ruby. just one way
to hone ruby skill..

>> puts `dig qitc.xu.edu.ph`.each_line.select {|x| x !~ /^(;|$)/ }

puts is just like printf with an autonewline if needed
the meat is just the dig command wc is executed thru the os shell.
the backquotes is similar to *nix's shell that returns the ouput
string after execution.
the dot in ruby is an oop speak. it separates the object and the
message/method, and it's chainable.
each_line makes the dig string output into an enumerator/iterator as per line.
select will select and output only those lines that are not comments
and not empty

kung sa bash pa, i'd do that as

$ dig qitc.xu.edu.ph | egrep -v "^(;|$)"
qitc.xu.edu.ph. 595554 IN CNAME ciso-www.xu.edu.ph.
ciso-www.xu.edu.ph. 595554 IN A 202.84.119.212

sa ruby, there's a more o-o way to do that (apologies for more bleed
if any) ... iow, you can simply do,

puts Resolver("qitc.xu.edu.ph").answer
qitc.xu.edu.ph. 595087 IN CNAME ciso-www.xu.edu.ph.
ciso-www.xu.edu.ph. 595087 IN A 202.84.119.212

that is we only want the answer section of the resolver..

best regards -botp

hard wyrd

unread,
Jan 12, 2011, 2:39:09 AM1/12/11
to ubunt...@googlegroups.com
maypa dungan ta tuon Ruby bro :D hehehehe. Ako refresher kay wala nay gamit gamit :D 

On Mon, Jan 10, 2011 at 4:17 PM, Jon Doblados <jon.do...@gmail.com> wrote:

Jon Doblados

unread,
Jan 12, 2011, 10:25:03 PM1/12/11
to ubunt...@googlegroups.com
On Wed, Jan 12, 2011 at 1:27 PM, botp <bot...@gmail.com> wrote:
On Mon, Jan 10, 2011 at 4:17 PM, Jon Doblados <jon.do...@gmail.com> wrote:
> Yes that should be the case. It may be possible that the db connection
> scripts are using fqdn for the host param and the server does not resolve to
> internal IP (since it's trying to connect via public IP and ports aren't
> open from the outside).  Perhaps a change to "localhost" as host param in the scripts would help?

yes, i'd like to help troubleshoot but "unfortunately", i do not get
any error msg that i can tract  :-)

Maybe tensai can shed more light to this issue.

warning: ruby session ahead :-))
as much as possible, i'd like to run scripts using ruby. just one way
to hone ruby skill..

I'll take your word for this. Kami ni Romar magtuon balik ani kai gamit kaayo. New ways to skin the cat, not just the bashful ones. Thanks for the quick session!

Kind regards,

Jon
Reply all
Reply to author
Forward
0 new messages