OpenBSD的mysql是否被限制了什么????

cnduly

多点人测试,尽快解决了它!!!

young_king

下面是OpenBSD 4.3 Realese版的成绩：

1. export PKG_PATH=ftp://ftp.openbsd.org/pub/OpenBSD/4.3/packages/i386/
   
2. pkg_add mysql-server php5-core php5-mysql

复制代码

装完后按提示安装数据库，修改/etc/login.conf，修改/etc/rc.local。

按提示做php5和php5-mysql的连接，然后跑程序2和程序3的测试。

OpenBSD 4.3 Realese没问题。




PS.现在到了用餐时间，等下发4.4的成绩！

young_king

4.4Realese版有问题，程序2可以跑完，但N多错误（未打patch）！



看来是OB版本的问题！

cnduly

在openbsd 4.4  Realese

ports 安装的 mysql-5.0.67 还是一样的结果，我想应该是 openbsd 4.4 版本有问题。

具体的信息请看

1. 
   
2. 
   
3. $ perl test.pl
   
4. ... skip ...
   
5. 175 DBI::db=HASH(0x7e3aac78)
   
6. 176 DBI::db=HASH(0x8a92d2f4)
   
7. 177 DBI::db=HASH(0x7e3aaeac)
   
8. 178 DBI::db=HASH(0x8a92d510)
   
9. 179 DBI::db=HASH(0x7e3aac6c)
   
10. 180 DBI::db=HASH(0x8a92d2d0)
    
11. 181 DBI::db=HASH(0x7e3aaf30)
    
12. 182 DBI::db=HASH(0x8aaf15d0)
    
13. DBI connect('database=mysql;host=127.0.0.1;port=3306','root',...) failed: Can't connect to MySQL server on '127.0.0.1' (61) at test.pl line 4
    
14. $ cat test.pl
    
15. use DBI;
    
16. $dsn = "DBI:mysql:database=mysql;host=127.0.0.1;port=3306";
    
17. for ($i = 0; $i < 5000; $i++) {
    
18.         $dbh = DBI->connect($dsn, 'root', 'pass');
    
19.         if (!$dbh) { exit 1; }
    
20.         print $i, ' ', $dbh, "\n";
    
21. }
    
22. $ mysql -e 'select version();'
    
23. +------------+
    
24. | version()  |
    
25. +------------+
    
26. | 5.0.67-log |
    
27. +------------+
    
28. $ uname -a
    
29. OpenBSD puffy.example.com 4.4 GENERIC.MP#844 i386
    
30. $ pkg_info | grep mysql
    
31. mysql-client-5.0.67 multithreaded SQL database (client)
    
32. mysql-server-5.0.67 multithreaded SQL database (server)
    
33. p5-DBD-mysql-4.005  MySQL drivers for the Perl DBI
    
34. php5-mysql-5.2.6    mysql database access extensions for php5
    
35. $ dmesg | head -20
    
36. OpenBSD 4.4 (GENERIC.MP) #844: Tue Aug 12 17:24:39 MDT 2008
    
37.     [email]deraadt@i386.openbsd.org[/email]:/usr/src/sys/arch/i386/compile/GENERIC.MP
    
38. cpu0: Intel(R) Pentium(R) 4 CPU 2.80GHz ("GenuineIntel" 686-class) 2.80 GHz
    
39. cpu0: FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,MWAIT,DS-CPL,CNXT-ID,xTPR
    
40. real mem  = 526532608 (502MB)
    
41. avail mem = 500613120 (477MB)
    
42. mainbus0 at root
    
43. bios0 at mainbus0: AT/286+ BIOS, date 02/06/06, BIOS32 rev. 0 @ 0xffe90, SMBIOS rev. 2.3 @ 0xf0450 (66 entries)
    
44. bios0: vendor Dell Inc. version "A02" date 02/06/2006
    
45. bios0: Dell Inc. PowerEdge SC420
    
46. acpi0 at bios0: rev 0
    
47. acpi0: tables DSDT FACP SSDT APIC BOOT MCFG HPET
    
48. acpi0: wakeup devices VBTN(S4) PCI0(S5) PCI1(S5) PCI2(S5) PCI3(S5) PCI4(S5) MOU_(S1) USB0(S1) USB1(S1) USB2(S1) USB3(S1)
    
49. acpitimer0 at acpi0: 3579545 Hz, 24 bits
    
50. acpimadt0 at acpi0 addr 0xfee00000: PC-AT compat
    
51. cpu0 at mainbus0: apid 0 (boot processor)
    
52. cpu0: apic clock running at 199MHz
    
53. cpu1 at mainbus0: apid 1 (application processor)
    
54. cpu1: Intel(R) Pentium(R) 4 CPU 2.80GHz ("GenuineIntel" 686-class) 2.80 GHz
    
55. cpu1: FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,MWAIT,DS-CPL,CNXT-ID,xTPR
    
56. $
    
57. 
    

复制代码

Macolex

真郁闷

4.4居然 不如 4.3