Fedora Core experience

Vista got suddenly pretty resource consuming, considering that i need to work with some programs that are resource consuming also(coldfusion, eclipse etc). I tried Windows 2k3 web edition, but some features and programs do not work the same as on XP/Vista, so i decied to go free. At first i tried Ubuntu(i had a great experience with it onto my Dell Inspiron 1501), but it seems like the support for Acer 5520G is not so good. So i searched, and searched and found out that fedora core recognize almost all hw elementss on the Acer(execpt graphics). So I installed fedora core 10 and all is fine now, just that i had some issues while installing the graphics drivers(Nvidia 8600M), for the fact that it requires that the X should not be running during the install.

Now it comes the part that i liked the most. I recently got an Mobile Broadband connection from Orange RO, that on vista and xp it was installing “Orange Business” (this is a stupid tool, that took control over all my wireless networks[mobile and wi-fi]). The modem i have is Huawei E270, that was recognized by Fedora without installing any additional drivers. Wait… there is one more cool thing: it autodetected my connections settings and here i am…oops… another thing that i forgot: 3G working great, this can not be true or at least it has to have some bugs(as Murphy would say), but from what i observed until now there is no down part. So if you you need Mobile Broadband onto linux i can assure you that Huawey E270 and Fedora core 10 make a great team.

Microsoft related

Recently I have received my MAPS(Microsoft Action Pack Subscription) that contains lot of M$ software and, of course, the necesary licenses for using that software. Considering it’s only $350/year, i consider it a great deal. For this money i got 10 licences for each of the following:

  • Windows Vista
  • Microsoft Office 2007
  • CAL’s for the server based products

And also got license for a bunch of server products.

Since 2 weeks ago i’m Microsof Certified Professional and i must say that the exam 70-290 has questions that any windows sysadmin should know to answer as long as it got some experience with IIS, AD and other windows features. Also the exam has a few questions about designing a network of computers and also (as expected) licensing questions.

I look forward for the next exam that most probably will be on Active Directory.

Plone “love” story

A few days ago i had to change the server of eestec to vmware ESX. All good and ok, i made the necessary backups, installed ESX, installed Windows into a VM. The issue apperead when i tried to restore the plone instance to the new installed Windows server. After restoring the content as described onto the Plone site it didn’t wanted to start as supposed to. I reinstalled plone a few times and finally, today, i managed to make it work. The funny part is that i don’t know exactly why this time worked and i hope it will not need a reinstall in the near future.

I hate Plone and i consider it probably the most bizare cms software i have encountered until now. Hopefully in 3-4 months we will port the entire site into a mysql/php based custom made CMS that will integrate with the rest of the sites.

P.S. If you need to restore plone i advise you to have a full backup of Data folder. Install the same version of plone on the new machine. Copy the content of  Products folder (from the backup) over the clean install(but don’t overwrite anything!!!!). After that replace the entire var directory with the one from the backup and start plone. Hope this will work in your case… in mine … it worked.

eeStec Home Page

Sovata mode

Hello people,

Va scriu din Sovata, un oras de mos dupa cum ziceau cativa cunoscuti de-ai mei. Glumind, am descoperit insa ca o data ce am ajung la Brasov am intrat in alta lume. Am fost placut impresionat de ospitalitatea celor la care am stat (“Pensiunea Speranta”, nu ma feresc sa le fac publicitate). Conditiile pentru o vila pe care am eu si colegii mei am gasit-o in ultimele zile ale anului 2008(cand mai toate erau ocupate din vara).
As an all totul a fost bine si frumos pana acum, insa drumul a fost obositor, 8 ore de mers din bucuresti pana la sovata.

Microsoft Inovation Center – Part 2

Saptamana trecuta(parca) am fost iar la MIC, la niste seminarii origanizate pentru a invata PowerShell, win 2k8. Din cate am auzit cursul/seminarul se tine de cateva saptamani, insa eu am auzit de el de-abia acum de la o colega. Intrun mesaj anterior am avut cateva vorbe de ocara la adresa acelui eveniment. Acum, cu bucurie in suflet sunt nevoit sa imi retrag cuvintele. Cosmin Dumitrescu, acelasi trainer ca si data trecuta, a avut parte de un “public” cu pareri mai pertinente de aceasta data(desi colega cu care am fost era total pe langa, dar sa lasam blondele in pace=)) ). Prezentarea s-a bazat in principiu pe utilizare GPO in Windows 2008, improvementuri fata de 2003 si inca 2-3 elemente de AD.

Ce pot sa spun… Felicitari Microsoft pentru inbunatarile aduse cu Windows 2008, dar atentie la securitate… Joi am primit un buletin de securitate in care se recomanda folosirea unui update de ultima ora, aparut in afara releasurile programate. De ce? O gaura de securitate in versiunile 5.5,6,7,8 beta ale IE-ului. Mai in gluma mai in serios pe grupurile de discutii se spunea astfel: “Do not install that update, install Firefox”(Nu instalati acel update, instalati Firefox).

Si uite cum am deviat de la un eveniment MS, la o discutie foarte “inflamabila”.

SimpleSQL (MySQL admin interface)

Titlul spune tot. E o interfata de administrare de baze de date dezolvatat de mine in cateva ore fiindca aveam nevoie sa studiez o baza de date si phpmyadmin era prea mare si se incarca prea greu pentru ce-mi trebuia mie.
La ce foloseste? Ei bine, toti care am lucrat cu phpmyadmin stim ca acesta este un tool foarte puternic, insa nu intotdeauna avem nevoie de toate functiile oferite de acesta. Acest tool ofera o interfata grafica pentru a lista tabelele, insa in rest pentru tot trebuie scrisa sintaxa de sql.Va astept sa imi dati idei pentru a-l imbunatatii.
Cum se instaleaza? Copiati directorul in site-ul vostru, nu necesita nici o instalare speciala, doar trebuie sa editati fisierul config.php pentru a ii spune ce servere de baze de date sa foloseasca sau daca o sa comentati linia in care sunt definite serverele scriptul o sa va lase sa va connectati la orice baza de date.

SimpleSQL

Last week

Ce mai faci? In ultima perioada m-am ocupat de deschiderea unui server pentru jocul lineage 2 si inca mai lucrez la interfata web(versiunea pentru public e inca un simplu html), insa sper ca in maxim 2 zile sa iesim cu versiunea beta a site-ului pentru public, urmand ca dezvoltarea lui sa conitnue. Urmeaza ca la mijlocul lunii viitoare sa ne mutam pe un server dedicat locat in state pentru a avea access mai bun la nivel international.

Numele proiectului? l2Apollo

Pagina web? http://www.l2apollo.com

Adresa server? server.l2apollo.com

Cine il dezolvata? phpAB Team

Status actual? Beta(speram ca pana la sfarsitul lunii viitoare sa avem toate itemurile setate, geoip instalat)

De ce o sa cerem inregistrare pe site? Vrem sa oferim un mod de a ne recompensa utilizatorii care aduc alti jucatori pe serverul nostru, iar aceasta era singura modalitate prin care putea sa facem un mecanism de refeer.

Va mai tinem la curent cu ce o sa se intample! 😉

SQL

M-am intalnit azi cu o chestie f misto…. functii facute direct in sql pe care. Mi-am facut cateva chestii de care chiar aveam nevoie pentru a reduce traficul.

Exemple(nu de alta, dar sa le am undeva notate:p):

DELIMITER $$

DROP PROCEDURE IF EXISTS `l2jserver`.`change_passwd` $$
CREATE DEFINER=`l2jserver`@`%` PROCEDURE `change_passwd`(IN s_username TEXT,IN old_passwd TEXT, IN new_passwd TEXT)
BEGIN
UPDATE `l2jserver`.`web_accounts`
SET `password`=new_passwd
WHERE `password`=old_passwd AND `username` = s_username;
UPDATE `l2jserver`.`accounts`
SET `password`=new_passwd
WHERE `password`=old_passwd AND `login` = s_username;
END $$

DELIMITER ;

And also:

DROP VIEW IF EXISTS `l2jserver`.`users`;
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `l2jserver`.`users` AS select `l2jserver`.`web_accounts`.`id` AS `id`,`l2jserver`.`accounts`.`login` AS `Username`,`l2jserver`.`web_accounts`.`password` AS `Password`,`l2jserver`.`web_accounts`.`email` AS `email`,`l2jserver`.`web_accounts`.`accesslevel` AS `Level access`,`l2jserver`.`accounts`.`lastactive` AS `Last Active`,`l2jserver`.`accounts`.`lastIP` AS `From IP last time` from (`l2jserver`.`accounts` join `l2jserver`.`web_accounts` on((`l2jserver`.`web_accounts`.`username` = `l2jserver`.`accounts`.`login`)));