Hi,
There was thread a couple of weeks back about the fact that bacula uses
a slightly different algorithm to the "standard" base64 one.
Would that apply in this case and would it account for the confusing
output received by Mark?
Just a thought - could be completely off the mark.
Troy.
James Harper wrote:
James Harper wrote:
Do you want to deal with it in the query (harder), or in the code
that
processes the query (easier)? Are you asking what Base64 is, or do
you
know already and would just like some help doing something useful
with
it from within the SQL language?
My hope was to write a custom query to put in the query.sql file so I
could run it from bconsole, but if I have to I guess I could script
something independently to deal with the conversion.
The way to do that might depend on the backend... hmmm... something to
think about.
I've tried a number of online decoders (including the one you suggest)
and none of them returns anything that makes sense when I give it a
value like BEHwQV. As you say, I am expecting a big integer, but I
get
back nonsense or an error message. That is what made me question
whether I was going about it completely wrong. At this point I am
stuck
on the conversion.
It does give you a big integer if that's how you want to interpret it,
when I type in 'BEHwQV' in the 'BASE64' window and then click 'Decode',
I get ' 04 41 f0 41' in the hex window. I might have my endian-ness
around the wrong way here, but if I shuffle that around to '41f04104',
and convert it to decimal, I get 1106264324. This should be somewhere
early 2005 if interpreted as number of seconds since Jan 1 1970.
James
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=k&kid0709&bid&3057&dat1642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
